eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_HIERARCHY_V2PUB dependencies on HZ_HIERARCHY_NODES

Line 326: FROM HZ_HIERARCHY_NODES

322: l_debug_prefix VARCHAR2(30) := '';
323:
324: CURSOR c_top_in_hierarchy IS
325: SELECT TOP_PARENT_FLAG
326: FROM HZ_HIERARCHY_NODES
327: WHERE PARENT_ID = p_parent_id
328: AND PARENT_TABLE_NAME = p_parent_table_name
329: AND PARENT_OBJECT_TYPE = p_parent_object_type
330: AND HIERARCHY_TYPE = p_hierarchy_type

Line 552: FROM HZ_HIERARCHY_NODES

548:
549: BEGIN
550: SELECT 'Y', LEVEL_NUMBER
551: INTO l_result, l_level_number
552: FROM HZ_HIERARCHY_NODES
553: WHERE PARENT_ID = p_parent_id
554: AND PARENT_TABLE_NAME = p_parent_table_name
555: AND PARENT_OBJECT_TYPE = p_parent_object_type
556: AND HIERARCHY_TYPE = p_hierarchy_type

Line 701: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;

697: x_msg_count OUT NOCOPY NUMBER,
698: x_msg_data OUT NOCOPY VARCHAR2
699: ) IS
700:
701: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
702: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
703: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
704: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;

Line 702: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;

698: x_msg_data OUT NOCOPY VARCHAR2
699: ) IS
700:
701: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
702: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
703: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
704: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
706: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;

Line 703: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;

699: ) IS
700:
701: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
702: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
703: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
704: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
706: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
707: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;

Line 704: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;

700:
701: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
702: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
703: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
704: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
706: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
707: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
708: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;

Line 705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;

701: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
702: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
703: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
704: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
706: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
707: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
708: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
709: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;

Line 706: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;

702: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
703: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
704: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
706: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
707: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
708: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
709: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
710:

Line 707: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;

703: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
704: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
706: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
707: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
708: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
709: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
710:
711: parent_id_list parent_id_type;

Line 708: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;

704: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
706: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
707: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
708: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
709: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
710:
711: parent_id_list parent_id_type;
712: parent_table_name_list parent_table_name_type;

Line 709: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;

705: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
706: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
707: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
708: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
709: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
710:
711: parent_id_list parent_id_type;
712: parent_table_name_list parent_table_name_type;
713: parent_object_type_list parent_object_type_type;

Line 734: FROM HZ_HIERARCHY_NODES

730: LEAF_CHILD_FLAG,
731: EFFECTIVE_START_DATE,
732: EFFECTIVE_END_DATE,
733: RELATIONSHIP_ID
734: FROM HZ_HIERARCHY_NODES
735: WHERE CHILD_ID = p_child_id
736: AND CHILD_TABLE_NAME = p_child_table_name
737: AND CHILD_OBJECT_TYPE = p_child_object_type
738: AND PARENT_TABLE_NAME LIKE p_parent_table_name||'%'

Line 944: TYPE child_id_type IS TABLE OF hz_hierarchy_nodes.child_id%TYPE;

940: x_msg_data OUT NOCOPY VARCHAR2
941: ) IS
942:
943:
944: TYPE child_id_type IS TABLE OF hz_hierarchy_nodes.child_id%TYPE;
945: TYPE child_table_name_type IS TABLE OF hz_hierarchy_nodes.child_table_name%TYPE;
946: TYPE child_object_type_type IS TABLE OF hz_hierarchy_nodes.child_object_type%TYPE;
947: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;

Line 945: TYPE child_table_name_type IS TABLE OF hz_hierarchy_nodes.child_table_name%TYPE;

941: ) IS
942:
943:
944: TYPE child_id_type IS TABLE OF hz_hierarchy_nodes.child_id%TYPE;
945: TYPE child_table_name_type IS TABLE OF hz_hierarchy_nodes.child_table_name%TYPE;
946: TYPE child_object_type_type IS TABLE OF hz_hierarchy_nodes.child_object_type%TYPE;
947: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
949: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;

Line 946: TYPE child_object_type_type IS TABLE OF hz_hierarchy_nodes.child_object_type%TYPE;

942:
943:
944: TYPE child_id_type IS TABLE OF hz_hierarchy_nodes.child_id%TYPE;
945: TYPE child_table_name_type IS TABLE OF hz_hierarchy_nodes.child_table_name%TYPE;
946: TYPE child_object_type_type IS TABLE OF hz_hierarchy_nodes.child_object_type%TYPE;
947: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
949: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
950: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;

Line 947: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;

943:
944: TYPE child_id_type IS TABLE OF hz_hierarchy_nodes.child_id%TYPE;
945: TYPE child_table_name_type IS TABLE OF hz_hierarchy_nodes.child_table_name%TYPE;
946: TYPE child_object_type_type IS TABLE OF hz_hierarchy_nodes.child_object_type%TYPE;
947: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
949: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
950: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
951: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;

Line 948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;

944: TYPE child_id_type IS TABLE OF hz_hierarchy_nodes.child_id%TYPE;
945: TYPE child_table_name_type IS TABLE OF hz_hierarchy_nodes.child_table_name%TYPE;
946: TYPE child_object_type_type IS TABLE OF hz_hierarchy_nodes.child_object_type%TYPE;
947: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
949: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
950: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
951: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
952: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;

Line 949: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;

945: TYPE child_table_name_type IS TABLE OF hz_hierarchy_nodes.child_table_name%TYPE;
946: TYPE child_object_type_type IS TABLE OF hz_hierarchy_nodes.child_object_type%TYPE;
947: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
949: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
950: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
951: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
952: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
953:

Line 950: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;

946: TYPE child_object_type_type IS TABLE OF hz_hierarchy_nodes.child_object_type%TYPE;
947: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
949: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
950: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
951: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
952: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
953:
954: child_id_list child_id_type;

Line 951: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;

947: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
949: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
950: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
951: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
952: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
953:
954: child_id_list child_id_type;
955: child_table_name_list child_table_name_type;

Line 952: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;

948: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
949: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
950: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
951: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
952: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
953:
954: child_id_list child_id_type;
955: child_table_name_list child_table_name_type;
956: child_object_type_list child_object_type_type;

Line 975: FROM HZ_HIERARCHY_NODES

971: LEAF_CHILD_FLAG,
972: EFFECTIVE_START_DATE,
973: EFFECTIVE_END_DATE,
974: RELATIONSHIP_ID
975: FROM HZ_HIERARCHY_NODES
976: WHERE PARENT_ID = p_parent_id
977: AND PARENT_TABLE_NAME = p_parent_table_name
978: AND PARENT_OBJECT_TYPE = p_parent_object_type
979: AND CHILD_TABLE_NAME LIKE p_child_table_name||'%'

Line 1179: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;

1175: x_msg_count OUT NOCOPY NUMBER,
1176: x_msg_data OUT NOCOPY VARCHAR2
1177: ) IS
1178:
1179: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
1180: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
1181: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
1182: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;

Line 1180: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;

1176: x_msg_data OUT NOCOPY VARCHAR2
1177: ) IS
1178:
1179: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
1180: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
1181: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
1182: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
1184: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;

Line 1181: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;

1177: ) IS
1178:
1179: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
1180: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
1181: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
1182: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
1184: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
1185: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;

Line 1182: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;

1178:
1179: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
1180: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
1181: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
1182: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
1184: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
1185: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
1186: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;

Line 1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;

1179: TYPE parent_id_type IS TABLE OF hz_hierarchy_nodes.parent_id%TYPE;
1180: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
1181: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
1182: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
1184: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
1185: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
1186: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
1187: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;

Line 1184: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;

1180: TYPE parent_table_name_type IS TABLE OF hz_hierarchy_nodes.parent_table_name%TYPE;
1181: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
1182: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
1184: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
1185: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
1186: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
1187: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
1188: TYPE entity_id_type IS TABLE OF NUMBER;

Line 1185: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;

1181: TYPE parent_object_type_type IS TABLE OF hz_hierarchy_nodes.parent_object_type%TYPE;
1182: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
1184: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
1185: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
1186: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
1187: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
1188: TYPE entity_id_type IS TABLE OF NUMBER;
1189:

Line 1186: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;

1182: TYPE level_number_type IS TABLE OF hz_hierarchy_nodes.level_number%TYPE;
1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
1184: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
1185: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
1186: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
1187: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
1188: TYPE entity_id_type IS TABLE OF NUMBER;
1189:
1190: parent_id_list parent_id_type;

Line 1187: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;

1183: TYPE top_parent_flag_type IS TABLE OF hz_hierarchy_nodes.top_parent_flag%TYPE;
1184: TYPE leaf_child_flag_type IS TABLE OF hz_hierarchy_nodes.leaf_child_flag%TYPE;
1185: TYPE effective_start_date_type IS TABLE OF hz_hierarchy_nodes.effective_start_date%TYPE;
1186: TYPE effective_end_date_type IS TABLE OF hz_hierarchy_nodes.effective_end_date%TYPE;
1187: TYPE relationship_id_type IS TABLE OF hz_hierarchy_nodes.relationship_id%TYPE;
1188: TYPE entity_id_type IS TABLE OF NUMBER;
1189:
1190: parent_id_list parent_id_type;
1191: parent_table_name_list parent_table_name_type;

Line 1221: FROM HZ_HIERARCHY_NODES

1217: LEAF_CHILD_FLAG,
1218: EFFECTIVE_START_DATE,
1219: EFFECTIVE_END_DATE,
1220: RELATIONSHIP_ID
1221: FROM HZ_HIERARCHY_NODES
1222: WHERE HIERARCHY_TYPE = p_hierarchy_type
1223: AND PARENT_TABLE_NAME LIKE p_parent_table_name||'%'
1224: AND PARENT_OBJECT_TYPE LIKE p_parent_object_type||'%'
1225: AND TOP_PARENT_FLAG = 'Y'