The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT HIERARCHICAL_FLAG INTO l_dummy
FROM HZ_RELATIONSHIP_TYPES
WHERE RELATIONSHIP_TYPE = p_hierarchy_type
AND ROWNUM = 1;
SELECT 'Y'
INTO l_dummy
FROM fnd_objects fo
WHERE fo.obj_name = p_parent_table_name;
SELECT 'Y'
INTO l_dummy
FROM FND_OBJECT_INSTANCE_SETS
WHERE INSTANCE_SET_NAME = p_parent_object_type;
SELECT 'Y'
INTO l_dummy
FROM fnd_objects fo
WHERE fo.obj_name = p_child_table_name;
SELECT 'Y'
INTO l_dummy
FROM FND_OBJECT_INSTANCE_SETS
WHERE INSTANCE_SET_NAME = p_child_object_type;
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;
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;
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);
p_create_update_flag => 'C',
p_column => 'p_child_id',
p_column_value => p_child_id,
x_return_status => x_return_status);
p_create_update_flag => 'C',
p_column => 'p_child_table_name',
p_column_value => p_child_table_name,
x_return_status => x_return_status);
p_create_update_flag => 'C',
p_column => 'p_child_object_type',
p_column_value => p_child_object_type,
x_return_status => x_return_status);
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);
p_create_update_flag => 'C',
p_column => 'p_parent_id',
p_column_value => p_parent_id,
x_return_status => x_return_status);
p_create_update_flag => 'C',
p_column => 'p_parent_table_name',
p_column_value => p_parent_table_name,
x_return_status => x_return_status);
p_create_update_flag => 'C',
p_column => 'p_parent_object_type',
p_column_value => p_parent_object_type,
x_return_status => x_return_status);
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;
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;
l_str := 'select '||l_column_name||' from '||l_object_name||' where '||l_predicate||' and rownum <= :1';
l_str := 'select '||l_column_name||' from '||l_object_name||' where rownum <= :1';