oracle.apps.fnd.applcore.trees.uiModel.util
Class HierarchicalQuery

java.lang.Object
  oracle.apps.fnd.applcore.trees.uiModel.util.HierarchicalQuery

public final class HierarchicalQuery
extends java.lang.Object

Generates the sql query for any given hierarchichal operator based on active tree version.

Author:

Abhay K Kumar <abhay.k.kumar@oracle.com>

Nested Class Summary

static class

HierarchicalQuery.Operator Enumeration of hierarchichal operators.

Method Summary

static java.util.Map<HierarchicalQuery.Operator,java.lang.String>	getQueries(oracle.jbo.ApplicationModule passedAM, java.lang.String treeStructureCode) Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.
static java.util.Map<HierarchicalQuery.Operator,java.lang.String>	getQueries(oracle.jbo.ApplicationModule passedAM, java.lang.String treeStructureCode, java.lang.String bindSegVal) Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.
static java.util.Map<HierarchicalQuery.Operator,java.lang.String>	getQueries(java.lang.String treeStructureCode) Gets the Hierarchichal operator based query for any given operator type and hierarchy.
static java.util.Map<HierarchicalQuery.Operator,java.lang.String>	getQueries(java.lang.String treeStructureCode, java.lang.String bindSegVal) Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.
static java.util.Map<HierarchicalQuery.Operator,java.lang.String>	getQueriesForTree(oracle.jbo.ApplicationModule passedAM, java.lang.String treeStructureCode, java.lang.String treeCode) Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.
static java.util.Map<HierarchicalQuery.Operator,java.lang.String>	getQueriesForTree(oracle.jbo.ApplicationModule passedAM, java.lang.String treeStructureCode, java.lang.String treeCode, java.lang.String bindSegVal) Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.
static java.util.Map<HierarchicalQuery.Operator,java.lang.String>	getQueriesForTree(java.lang.String treeStructureCode, java.lang.String treeCode) Gets the Hierarchichal operator based query for any given operator type and hierarchy.
static java.util.Map<HierarchicalQuery.Operator,java.lang.String>	getQueriesForTree(java.lang.String treeStructureCode, java.lang.String treeCode, java.lang.String bindSegVal) Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.
static java.lang.String	getQuery(oracle.jbo.ApplicationModule passedAM, java.lang.String treeStructureCode, HierarchicalQuery.Operator operator) Gets the Hierarchichal operator based query for any given operator type and hierarchy.
static java.lang.String	getQuery(oracle.jbo.ApplicationModule passedAM, java.lang.String treeStructureCode, HierarchicalQuery.Operator operator, java.lang.String bindSegVal) Gets the Hierarchichal operator based query for any given operator type and hierarchy.
static java.lang.String	getQuery(java.lang.String treeStructureCode, HierarchicalQuery.Operator operator) Gets the Hierarchichal operator based query for any given operator type and hierarchy.
static java.lang.String	getQuery(java.lang.String treeStructureCode, HierarchicalQuery.Operator operator, java.lang.String bindSegVal) Gets the Hierarchichal operator based query for any given operator type and hierarchy.
static java.lang.String	getQueryForTree(oracle.jbo.ApplicationModule passedAM, java.lang.String treeStructureCode, java.lang.String treeCode, HierarchicalQuery.Operator operator) Gets the Hierarchichal operator based query for any given operator type and hierarchy.
static java.lang.String	getQueryForTree(oracle.jbo.ApplicationModule passedAM, java.lang.String treeStructureCode, java.lang.String treeCode, HierarchicalQuery.Operator operator, java.lang.String bindSegVal) Gets the Hierarchichal operator based query for any given operator type and hierarchy.
static java.lang.String	getQueryForTree(java.lang.String treeStructureCode, java.lang.String treeCode, HierarchicalQuery.Operator operator) Gets the Hierarchichal operator based query for any given operator type and hierarchy.
static java.lang.String	getQueryForTree(java.lang.String treeStructureCode, java.lang.String treeCode, HierarchicalQuery.Operator operator, java.lang.String bindSegVal) Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Methods inherited from class java.lang.Object

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

Method Detail

getQuery

public static java.lang.String getQuery(oracle.jbo.ApplicationModule passedAM,
                                        java.lang.String treeStructureCode,
                                        HierarchicalQuery.Operator operator)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

passedAM - which can be used as parent root AM while inovking services

treeStructureCode - Tree Structure Code of the hierarchy

operator - Enum Operator

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding

getQueryForTree

public static java.lang.String getQueryForTree(oracle.jbo.ApplicationModule passedAM,
                                               java.lang.String treeStructureCode,
                                               java.lang.String treeCode,
                                               HierarchicalQuery.Operator operator)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

passedAM - which can be used as parent root AM while inovking services

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

operator - Enum Operator

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding

getQuery

public static java.lang.String getQuery(java.lang.String treeStructureCode,
                                        HierarchicalQuery.Operator operator)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

operator - Enum Operator

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding

getQuery

public static java.lang.String getQuery(java.lang.String treeStructureCode,
                                        HierarchicalQuery.Operator operator,
                                        java.lang.String bindSegVal)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

operator - Enum Operator

bindSegVal - name of the bind variable which should be used for

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding

getQueryForTree

public static java.lang.String getQueryForTree(java.lang.String treeStructureCode,
                                               java.lang.String treeCode,
                                               HierarchicalQuery.Operator operator,
                                               java.lang.String bindSegVal)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

operator - Enum Operator

bindSegVal - name of the bind variable which should be used for binding for selected value

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding

getQueryForTree

public static java.lang.String getQueryForTree(java.lang.String treeStructureCode,
                                               java.lang.String treeCode,
                                               HierarchicalQuery.Operator operator)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

operator - Enum Operator

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding

getQuery

public static java.lang.String getQuery(oracle.jbo.ApplicationModule passedAM,
                                        java.lang.String treeStructureCode,
                                        HierarchicalQuery.Operator operator,
                                        java.lang.String bindSegVal)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

passedAM - which can be used as parent root AM while inovking services

treeStructureCode - Tree Structure Code of the hierarchy

operator - Enum Operator

bindSegVal - name of the bind variable which should be used for binding for selected value

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding

getQueryForTree

public static java.lang.String getQueryForTree(oracle.jbo.ApplicationModule passedAM,
                                               java.lang.String treeStructureCode,
                                               java.lang.String treeCode,
                                               HierarchicalQuery.Operator operator,
                                               java.lang.String bindSegVal)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

passedAM - which can be used as parent root AM while inovking services

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

operator - Enum Operator

bindSegVal - name of the bind variable which should be used for binding for selected value

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding

getQueries

public static java.util.Map<HierarchicalQuery.Operator,java.lang.String> getQueries(oracle.jbo.ApplicationModule passedAM,
                                                                                    java.lang.String treeStructureCode)

Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

passedAM - which can be used as parent root AM while inovking services

treeStructureCode - Tree Structure Code of the hierarchy

Returns:

Map of Hierarchy Operator and corresponding sql query pair where default bind variable "segVal" is used for Value binding

getQueriesForTree

public static java.util.Map<HierarchicalQuery.Operator,java.lang.String> getQueriesForTree(oracle.jbo.ApplicationModule passedAM,
                                                                                           java.lang.String treeStructureCode,
                                                                                           java.lang.String treeCode)

Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

passedAM - which can be used as parent root AM while inovking services

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

Returns:

Map of Hierarchy Operator and corresponding sql query pair where default bind variable "segVal" is used for Value binding

getQueries

public static java.util.Map<HierarchicalQuery.Operator,java.lang.String> getQueries(java.lang.String treeStructureCode)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

Returns:

Map of Hierarchy Operator and corresponding sql query pair where default bind variable "segVal" is used for Value binding

getQueriesForTree

public static java.util.Map<HierarchicalQuery.Operator,java.lang.String> getQueriesForTree(java.lang.String treeStructureCode,
                                                                                           java.lang.String treeCode)

Gets the Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

Returns:

Map of Hierarchy Operator and corresponding sql query pair where default bind variable "segVal" is used for Value binding

getQueries

public static java.util.Map<HierarchicalQuery.Operator,java.lang.String> getQueries(java.lang.String treeStructureCode,
                                                                                    java.lang.String bindSegVal)

Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

bindSegVal - name of the bind variable which should be used for binding for selected value

Returns:

Map of Hierarchy Operator and corresponding sql query pair

getQueriesForTree

public static java.util.Map<HierarchicalQuery.Operator,java.lang.String> getQueriesForTree(java.lang.String treeStructureCode,
                                                                                           java.lang.String treeCode,
                                                                                           java.lang.String bindSegVal)

Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

bindSegVal - name of the bind variable which should be used for binding for selected value

Returns:

Map of Hierarchy Operator and corresponding sql query pair

getQueries

public static java.util.Map<HierarchicalQuery.Operator,java.lang.String> getQueries(oracle.jbo.ApplicationModule passedAM,
                                                                                    java.lang.String treeStructureCode,
                                                                                    java.lang.String bindSegVal)

Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

passedAM - which can be used as parent root AM while inovking services

treeStructureCode - Tree Structure Code of the hierarchy

bindSegVal - name of the bind variable which should be used for binding for selected value

Returns:

Map of Hierarchy Operator and corresponding sql query pair

getQueriesForTree

public static java.util.Map<HierarchicalQuery.Operator,java.lang.String> getQueriesForTree(oracle.jbo.ApplicationModule passedAM,
                                                                                           java.lang.String treeStructureCode,
                                                                                           java.lang.String treeCode,
                                                                                           java.lang.String bindSegVal)

Gets the Map of Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

passedAM - which can be used as parent root AM while inovking services

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

bindSegVal - name of the bind variable which should be used for binding for selected value

Returns:

Map of Hierarchy Operator and corresponding sql query pair