oracle.apps.fnd.applseed.rt.extract.common
Class SDSqlGenerator

java.lang.Object
  oracle.apps.fnd.applseed.rt.extract.common.SDSqlGenerator

public class SDSqlGenerator
extends java.lang.Object

Class that generates sql's used by the xlf upload the generic format of the queries is Update Query with surrogate update where id=(select id from _B, where and ) Update Query without surrogate update where exists (select 1 from _B, where and ) Select Query select count(1) from _B, where and

Author:

pariga

Constructor Summary

SDSqlGenerator(oracle.jbo.server.EntityDefImpl vlEntityDef, oracle.jbo.server.EntityDefImpl transEntityDef, SDViewNode viewNode)

Method Summary

java.lang.StringBuffer	addTLAndBJoinCondition(java.lang.StringBuffer query)
static SDSqlGenerator	createSqlGenerator(SDViewNode viewNode) creates the instance of the SDSqlGenerator
java.lang.String	getKeyBinds() Constructs the comma seperated string using the key attributes and returns it
java.lang.String	getLanguageAttribute()
static java.lang.String	getReferenceAttributeName(SDViewNode node, java.lang.String attrName)
java.lang.String	getSelectBindsString() Constructs the comma seperated string using the select query binds and returns it
java.lang.String	getSelectQuery()
java.lang.String	getUpdateBindsString() Constructs the comma seperated string using the update query binds and returns it
java.lang.String	getUpdateQuery()
java.lang.String	getWhoCols() returns the whocols in the following format ::, ::,...

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SDSqlGenerator

public SDSqlGenerator(oracle.jbo.server.EntityDefImpl vlEntityDef,
                      oracle.jbo.server.EntityDefImpl transEntityDef,
                      SDViewNode viewNode)

Parameters:

vlEntityDef - VL Entity definition object

transEntityDef - translation entity definition object

viewNode - SDViewNode instance

Method Detail

getLanguageAttribute

public java.lang.String getLanguageAttribute()

getReferenceAttributeName

public static java.lang.String getReferenceAttributeName(SDViewNode node,
                                                         java.lang.String attrName)

addTLAndBJoinCondition

public java.lang.StringBuffer addTLAndBJoinCondition(java.lang.StringBuffer query)

getUpdateQuery

public java.lang.String getUpdateQuery()

Returns:

updateQuery

getSelectQuery

public java.lang.String getSelectQuery()

Returns:

select query

getUpdateBindsString

public java.lang.String getUpdateBindsString()

Constructs the comma seperated string using the update query binds and returns it

Returns:

getSelectBindsString

public java.lang.String getSelectBindsString()

Constructs the comma seperated string using the select query binds and returns it

Returns:

getKeyBinds

public java.lang.String getKeyBinds()

Constructs the comma seperated string using the key attributes and returns it

Returns:

createSqlGenerator

public static SDSqlGenerator createSqlGenerator(SDViewNode viewNode)

creates the instance of the SDSqlGenerator

Parameters:

viewNode -

Returns:

getWhoCols

public java.lang.String getWhoCols()

returns the whocols in the following format ::, ::,...

Returns: