APPS.HZ_HIERARCHY_V2PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 134

        SELECT HIERARCHICAL_FLAG INTO l_dummy
        FROM   HZ_RELATIONSHIP_TYPES
        WHERE  RELATIONSHIP_TYPE = p_hierarchy_type
        AND    ROWNUM = 1;

Line: 163

            SELECT 'Y'
            INTO   l_dummy
            FROM   fnd_objects fo
            WHERE  fo.obj_name = p_parent_table_name;

Line: 192

            SELECT 'Y'
            INTO   l_dummy
            FROM   FND_OBJECT_INSTANCE_SETS
            WHERE  INSTANCE_SET_NAME = p_parent_object_type;

Line: 221

            SELECT 'Y'
            INTO   l_dummy
            FROM   fnd_objects fo
            WHERE  fo.obj_name = p_child_table_name;

Line: 251

            SELECT 'Y'
            INTO   l_dummy
            FROM   FND_OBJECT_INSTANCE_SETS
            WHERE  INSTANCE_SET_NAME = p_child_object_type;

Line: 325

    SELECT TOP_PARENT_FLAG
    FROM   HZ_HIERARCHY_NODES
    WHERE  PARENT_ID = p_parent_id
    AND    PARENT_TABLE_NAME = p_parent_table_name
    AND    PARENT_OBJECT_TYPE = p_parent_object_type
    AND    HIERARCHY_TYPE = p_hierarchy_type
    AND    p_effective_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
    AND    LEVEL_NUMBER = 0;

Line: 550

        SELECT 'Y', LEVEL_NUMBER
        INTO   l_result, l_level_number
        FROM   HZ_HIERARCHY_NODES
        WHERE  PARENT_ID = p_parent_id
        AND    PARENT_TABLE_NAME = p_parent_table_name
        AND    PARENT_OBJECT_TYPE = p_parent_object_type
        AND    HIERARCHY_TYPE = p_hierarchy_type
        AND    CHILD_ID = p_child_id
        AND    CHILD_TABLE_NAME = p_child_table_name
        AND    CHILD_OBJECT_TYPE = p_child_object_type
        AND    p_effective_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
        AND    LEVEL_NUMBER > 0
        AND    ROWNUM = 1;

Line: 725

    SELECT PARENT_ID,
           PARENT_TABLE_NAME,
           PARENT_OBJECT_TYPE,
           LEVEL_NUMBER,
           TOP_PARENT_FLAG,
           LEAF_CHILD_FLAG,
           EFFECTIVE_START_DATE,
           EFFECTIVE_END_DATE,
           RELATIONSHIP_ID
    FROM   HZ_HIERARCHY_NODES
    WHERE  CHILD_ID = p_child_id
    AND    CHILD_TABLE_NAME = p_child_table_name
    AND    CHILD_OBJECT_TYPE = p_child_object_type
    AND    PARENT_TABLE_NAME LIKE p_parent_table_name||'%'
    AND    PARENT_OBJECT_TYPE LIKE p_parent_object_type||'%'
    AND    HIERARCHY_TYPE = p_hierarchy_type
    AND    p_effective_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
    AND    LEVEL_NUMBER <> DECODE(p_include_node, 'N', 0, 'Y', -1, NULL, -1);

Line: 765

        p_create_update_flag     => 'C',
        p_column                 => 'p_child_id',
        p_column_value           => p_child_id,
        x_return_status          => x_return_status);

Line: 771

        p_create_update_flag     => 'C',
        p_column                 => 'p_child_table_name',
        p_column_value           => p_child_table_name,
        x_return_status          => x_return_status);

Line: 777

        p_create_update_flag     => 'C',
        p_column                 => 'p_child_object_type',
        p_column_value           => p_child_object_type,
        x_return_status          => x_return_status);

Line: 966

    SELECT CHILD_ID,
           CHILD_TABLE_NAME,
           CHILD_OBJECT_TYPE,
           LEVEL_NUMBER,
           TOP_PARENT_FLAG,
           LEAF_CHILD_FLAG,
           EFFECTIVE_START_DATE,
           EFFECTIVE_END_DATE,
           RELATIONSHIP_ID
    FROM   HZ_HIERARCHY_NODES
    WHERE  PARENT_ID = p_parent_id
    AND    PARENT_TABLE_NAME = p_parent_table_name
    AND    PARENT_OBJECT_TYPE = p_parent_object_type
    AND    CHILD_TABLE_NAME LIKE p_child_table_name||'%'
    AND    CHILD_OBJECT_TYPE LIKE p_child_object_type||'%'
    AND    HIERARCHY_TYPE = p_hierarchy_type
    AND    p_effective_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
    AND    LEVEL_NUMBER <> DECODE(p_include_node, 'N', 0, 'Y', -1, NULL, -1);

Line: 1006

        p_create_update_flag     => 'C',
        p_column                 => 'p_parent_id',
        p_column_value           => p_parent_id,
        x_return_status          => x_return_status);

Line: 1012

        p_create_update_flag     => 'C',
        p_column                 => 'p_parent_table_name',
        p_column_value           => p_parent_table_name,
        x_return_status          => x_return_status);

Line: 1018

        p_create_update_flag     => 'C',
        p_column                 => 'p_parent_object_type',
        p_column_value           => p_parent_object_type,
        x_return_status          => x_return_status);

Line: 1212

    SELECT PARENT_ID,
           PARENT_TABLE_NAME,
           PARENT_OBJECT_TYPE,
           LEVEL_NUMBER,
           TOP_PARENT_FLAG,
           LEAF_CHILD_FLAG,
           EFFECTIVE_START_DATE,
           EFFECTIVE_END_DATE,
           RELATIONSHIP_ID
    FROM   HZ_HIERARCHY_NODES
    WHERE  HIERARCHY_TYPE = p_hierarchy_type
    AND    PARENT_TABLE_NAME LIKE p_parent_table_name||'%'
    AND    PARENT_OBJECT_TYPE LIKE p_parent_object_type||'%'
    AND    TOP_PARENT_FLAG = 'Y'
    AND    p_effective_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
    AND    LEVEL_NUMBER = 0;

Line: 1231

    SELECT OBJ_NAME,
           PK1_COLUMN_NAME,
           PREDICATE
    FROM   FND_OBJECTS FO,
           FND_OBJECT_INSTANCE_SETS FOIS
    WHERE  FOIS.INSTANCE_SET_NAME = p_parent_object_type
    AND    FOIS.OBJECT_ID = FO.OBJECT_ID;

Line: 1317

            l_str := 'select '||l_column_name||' from '||l_object_name||' where '||l_predicate||' and rownum <= :1';

Line: 1327

            l_str := 'select '||l_column_name||' from '||l_object_name||' where rownum <= :1';