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_GNR_PVT dependencies on HZ_GEOGRAPHIES

Line 754: ,hz_geographies hg

750:
751: CURSOR c_geo_name (v_geo_name VARCHAR2, v_geo_type VARCHAR2, v_country_code VARCHAR2) IS
752: SELECT hg.geography_name, hg.geography_id, hg.geography_code
753: FROM hz_geography_identifiers hi
754: ,hz_geographies hg
755: WHERE hi.identifier_type = 'NAME'
756: AND UPPER(hi.identifier_value) = v_geo_name
757: AND hi.geography_type = v_geo_type
758: AND hi.geography_use = 'MASTER_REF'

Line 768: ,hz_geographies hg

764:
765: CURSOR c_geo_code (v_geo_code VARCHAR2, v_geo_type VARCHAR2, v_country_code VARCHAR2) IS
766: SELECT hg.geography_name, hg.geography_id, hg.geography_code
767: FROM hz_geography_identifiers hi
768: ,hz_geographies hg
769: WHERE hi.identifier_type = 'CODE'
770: AND UPPER(hi.identifier_value) = v_geo_code
771: AND hi.geography_type = v_geo_type
772: AND hi.geography_use = 'MASTER_REF'

Line 870: l_country_only_name HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE;

866: l_error_location VARCHAR2(100);
867:
868: l_country_only_passed VARCHAR2(1);
869: l_country_only_mapped VARCHAR2(1);
870: l_country_only_name HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE;
871: l_country_only_id HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE;
872: l_country_only_code HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE;
873: l_search_type VARCHAR2(100);
874: l_addr_val_level VARCHAR2(100);

Line 871: l_country_only_id HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE;

867:
868: l_country_only_passed VARCHAR2(1);
869: l_country_only_mapped VARCHAR2(1);
870: l_country_only_name HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE;
871: l_country_only_id HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE;
872: l_country_only_code HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE;
873: l_search_type VARCHAR2(100);
874: l_addr_val_level VARCHAR2(100);
875:

Line 872: l_country_only_code HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE;

868: l_country_only_passed VARCHAR2(1);
869: l_country_only_mapped VARCHAR2(1);
870: l_country_only_name HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE;
871: l_country_only_id HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE;
872: l_country_only_code HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE;
873: l_search_type VARCHAR2(100);
874: l_addr_val_level VARCHAR2(100);
875:
876: l_max_passed_element_col_value NUMBER;

Line 879: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;

875:
876: l_max_passed_element_col_value NUMBER;
877: l_max_mapped_element_col_value NUMBER;
878: l_max_usage_element_col_value NUMBER;
879: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
880: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
881: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
882: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
883: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;

Line 880: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;

876: l_max_passed_element_col_value NUMBER;
877: l_max_mapped_element_col_value NUMBER;
878: l_max_usage_element_col_value NUMBER;
879: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
880: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
881: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
882: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
883: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;
884: l_geo_data_count INTEGER;

Line 881: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;

877: l_max_mapped_element_col_value NUMBER;
878: l_max_usage_element_col_value NUMBER;
879: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
880: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
881: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
882: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
883: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;
884: l_geo_data_count INTEGER;
885:

Line 882: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;

878: l_max_usage_element_col_value NUMBER;
879: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
880: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
881: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
882: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
883: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;
884: l_geo_data_count INTEGER;
885:
886: l_success VARCHAR2(10);

Line 883: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;

879: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
880: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
881: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
882: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
883: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;
884: l_geo_data_count INTEGER;
885:
886: l_success VARCHAR2(10);
887: l_geo_validation_passed VARCHAR2(10);

Line 913: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

909:
910: ------ multi parent record
911: TYPE rec_type_mp IS RECORD
912: (
913: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 914: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

910: ------ multi parent record
911: TYPE rec_type_mp IS RECORD
912: (
913: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 915: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

911: TYPE rec_type_mp IS RECORD
912: (
913: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 916: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

912: (
913: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

913: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

914: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

915: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

916: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

917: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

918: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

919: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

920: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

921: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

922: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

923: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

924: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

925: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

926: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

927: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

928: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

929: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

930: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

931: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

932: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

933: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

934: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

935: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

936: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

937: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

938: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

939: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

940: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

941: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
949: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

942: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
949: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
950: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

943: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
949: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
950: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
951: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

944: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
949: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
950: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
951: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
952: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE

Line 949: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

945: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
949: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
950: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
951: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
952: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE
953: );

Line 950: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

946: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
949: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
950: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
951: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
952: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE
953: );
954:

Line 951: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

947: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
949: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
950: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
951: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
952: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE
953: );
954:
955: rec_mp rec_type_mp;

Line 952: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE

948: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
949: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
950: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
951: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
952: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE
953: );
954:
955: rec_mp rec_type_mp;
956:

Line 963: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,

959:
960: -----intermediate table record
961: TYPE geo_rec_type IS RECORD
962: (
963: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
964: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
965: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
966: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,

Line 964: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,

960: -----intermediate table record
961: TYPE geo_rec_type IS RECORD
962: (
963: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
964: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
965: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
966: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,

Line 965: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,

961: TYPE geo_rec_type IS RECORD
962: (
963: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
964: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
965: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
966: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,

Line 966: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,

962: (
963: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
964: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
965: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
966: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,

Line 967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,

963: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
964: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
965: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
966: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,

Line 968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,

964: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
965: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
966: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,

Line 969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,

965: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
966: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,

Line 970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,

966: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,

Line 971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,

967: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,

Line 972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,

968: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,

Line 973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,

969: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,

Line 974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,

970: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,

Line 975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,

971: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,

Line 976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,

972: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,

Line 977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,

973: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,

Line 978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,

974: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,

Line 979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,

975: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,

Line 980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,

976: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,

Line 981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,

977: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,

Line 982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,

978: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,

Line 983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,

979: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,

Line 984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,

980: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,

Line 985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,

981: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,

Line 986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,

982: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
990: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,

Line 987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,

983: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
990: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
991: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,

Line 988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,

984: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
990: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
991: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
992: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,

Line 989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,

985: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
990: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
991: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
992: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
993: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE

Line 990: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,

986: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
990: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
991: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
992: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
993: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE
994: );

Line 991: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,

987: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
990: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
991: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
992: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
993: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE
994: );
995:

Line 992: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,

988: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
990: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
991: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
992: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
993: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE
994: );
995:
996: TYPE geo_rec_tbl_type IS TABLE OF geo_rec_type INDEX BY BINARY_INTEGER;

Line 993: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE

989: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
990: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
991: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
992: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
993: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE
994: );
995:
996: TYPE geo_rec_tbl_type IS TABLE OF geo_rec_type INDEX BY BINARY_INTEGER;
997:

Line 1006: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;

1002: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
1003:
1004: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1005: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1006: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1007: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1008: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1009: l_geo_rec_country_code hz_geographies.country_code%TYPE;
1010:

Line 1007: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;

1003:
1004: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1005: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1006: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1007: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1008: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1009: l_geo_rec_country_code hz_geographies.country_code%TYPE;
1010:
1011: l_not_validated_geo_type VARCHAR2(200);

Line 1008: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;

1004: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1005: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1006: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1007: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1008: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1009: l_geo_rec_country_code hz_geographies.country_code%TYPE;
1010:
1011: l_not_validated_geo_type VARCHAR2(200);
1012: l_rec_count_flag VARCHAR2(10);

Line 1009: l_geo_rec_country_code hz_geographies.country_code%TYPE;

1005: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1006: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1007: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1008: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1009: l_geo_rec_country_code hz_geographies.country_code%TYPE;
1010:
1011: l_not_validated_geo_type VARCHAR2(200);
1012: l_rec_count_flag VARCHAR2(10);
1013:

Line 1026: -- input is element column name from hz_geographies stored in mapping table

1022: l_bind_counter NUMBER := 0;
1023:
1024: ---------------------------------------------------------------------+
1025: -- function to get table column name of hz_locations
1026: -- input is element column name from hz_geographies stored in mapping table
1027: ---------------------------------------------------------------------+
1028: FUNCTION get_mapped_tab_col (pf_element_column_name IN VARCHAR2) RETURN VARCHAR2
1029: IS
1030: x_loc_col VARCHAR2(100);

Line 1065: -- function to get element column name of hz_geographies

1061: RETURN x_loc_col;
1062: END get_tab_col_from_geo_type;
1063:
1064: ---------------------------------------------------------------------+
1065: -- function to get element column name of hz_geographies
1066: -- input is geography type from hz_geographies stored in mapping table
1067: ---------------------------------------------------------------------+
1068: FUNCTION get_element_col_for_geo_type (pf_geo_type IN VARCHAR2) RETURN VARCHAR2
1069: IS

Line 1066: -- input is geography type from hz_geographies stored in mapping table

1062: END get_tab_col_from_geo_type;
1063:
1064: ---------------------------------------------------------------------+
1065: -- function to get element column name of hz_geographies
1066: -- input is geography type from hz_geographies stored in mapping table
1067: ---------------------------------------------------------------------+
1068: FUNCTION get_element_col_for_geo_type (pf_geo_type IN VARCHAR2) RETURN VARCHAR2
1069: IS
1070: x_element_col VARCHAR2(100);

Line 1106: -- input is element column from hz_geographies stored in mapping table

1102: END get_mapped_geo_type;
1103:
1104: ---------------------------------------------------------------------+
1105: -- function to get geography type for mapped column
1106: -- input is element column from hz_geographies stored in mapping table
1107: ---------------------------------------------------------------------+
1108: FUNCTION get_geo_type_from_element_col (pf_element_column IN VARCHAR2) RETURN VARCHAR2
1109: IS
1110: x_geo_type VARCHAR2(100);

Line 1773: PROCEDURE multiple_parent_proc (ll_geo_id hz_geographies.geography_id%TYPE

1769: -- Input is geography_id for which there are multiple parents
1770: -- It will call insert_mp_in_geo_rec_proc to insert data in
1771: -- geo_rec table (intermediate plsql table)
1772: -----------------------------------------------------------------------------+
1773: PROCEDURE multiple_parent_proc (ll_geo_id hz_geographies.geography_id%TYPE
1774: ,ll_geo_type hz_geographies.geography_type%TYPE) IS
1775: l_structure_level_count NUMBER;
1776: l_insert_geo_valid_rec_final VARCHAR2(1);
1777: l_insert_geo_suggest_rec VARCHAR2(1);

Line 1774: ,ll_geo_type hz_geographies.geography_type%TYPE) IS

1770: -- It will call insert_mp_in_geo_rec_proc to insert data in
1771: -- geo_rec table (intermediate plsql table)
1772: -----------------------------------------------------------------------------+
1773: PROCEDURE multiple_parent_proc (ll_geo_id hz_geographies.geography_id%TYPE
1774: ,ll_geo_type hz_geographies.geography_type%TYPE) IS
1775: l_structure_level_count NUMBER;
1776: l_insert_geo_valid_rec_final VARCHAR2(1);
1777: l_insert_geo_suggest_rec VARCHAR2(1);
1778:

Line 1818: l_from_mp := ' FROM hz_geographies p0 '

1814: l_select_mp := 'SELECT distinct p0.geography_id , p0.geography_name ,'
1815: ||'p0.geography_code , p0.geography_type '
1816: ||',p1.geography_id , p1.geography_name ,'
1817: ||'p1.geography_code , p1.geography_type ';
1818: l_from_mp := ' FROM hz_geographies p0 '
1819: ||', hz_hierarchy_nodes hn1'
1820: ||', hz_geographies p1 ';
1821: l_where_mp := ' WHERE hn1.child_id = p0.geography_id '
1822: ||' AND p0.geography_use = ''MASTER_REF'' '

Line 1820: ||', hz_geographies p1 ';

1816: ||',p1.geography_id , p1.geography_name ,'
1817: ||'p1.geography_code , p1.geography_type ';
1818: l_from_mp := ' FROM hz_geographies p0 '
1819: ||', hz_hierarchy_nodes hn1'
1820: ||', hz_geographies p1 ';
1821: l_where_mp := ' WHERE hn1.child_id = p0.geography_id '
1822: ||' AND p0.geography_use = ''MASTER_REF'' '
1823: ||' AND SYSDATE BETWEEN p0.start_date AND p0.end_date '
1824: ||' AND hn1.child_id = :x_missing_geo_id '

Line 1827: ||' AND hn1.child_table_name = ''HZ_GEOGRAPHIES'' '

1823: ||' AND SYSDATE BETWEEN p0.start_date AND p0.end_date '
1824: ||' AND hn1.child_id = :x_missing_geo_id '
1825: ||' AND hn1.hierarchy_type = ''MASTER_REF'' '
1826: ||' AND hn1.level_number = 1 '
1827: ||' AND hn1.child_table_name = ''HZ_GEOGRAPHIES'' '
1828: ||' AND SYSDATE BETWEEN hn1.effective_start_date AND hn1.effective_end_date '
1829: ||' AND NVL(hn1.status,''A'') = ''A'' '
1830: ||' AND hn1.parent_table_name = ''HZ_GEOGRAPHIES'' '
1831: ||' AND hn1.parent_id = p1.geography_id '

Line 1830: ||' AND hn1.parent_table_name = ''HZ_GEOGRAPHIES'' '

1826: ||' AND hn1.level_number = 1 '
1827: ||' AND hn1.child_table_name = ''HZ_GEOGRAPHIES'' '
1828: ||' AND SYSDATE BETWEEN hn1.effective_start_date AND hn1.effective_end_date '
1829: ||' AND NVL(hn1.status,''A'') = ''A'' '
1830: ||' AND hn1.parent_table_name = ''HZ_GEOGRAPHIES'' '
1831: ||' AND hn1.parent_id = p1.geography_id '
1832: ||' AND p1.geography_use = ''MASTER_REF'' '
1833: ||' AND SYSDATE BETWEEN p1.start_date AND p1.end_date ';
1834:

Line 1844: ||', hz_geographies p'||i ;

1840: l_select_mp := l_select_mp ||',p'||i||'.geography_id , p'||i||'.geography_name '
1841: ||',p'||i||'.geography_code, p'||i||'.geography_type ';
1842:
1843: l_from_mp := l_from_mp ||', hz_hierarchy_nodes hn'||i
1844: ||', hz_geographies p'||i ;
1845:
1846: l_where_mp := l_where_mp ||' AND hn'||i||'.child_id = hn'||l_last_index_mp||'.parent_id '
1847: ||' AND hn'||i||'.hierarchy_type = ''MASTER_REF'' '
1848: ||' AND hn'||i||'.level_number = 1 '

Line 1849: ||' AND hn'||i||'.child_table_name = ''HZ_GEOGRAPHIES'' '

1845:
1846: l_where_mp := l_where_mp ||' AND hn'||i||'.child_id = hn'||l_last_index_mp||'.parent_id '
1847: ||' AND hn'||i||'.hierarchy_type = ''MASTER_REF'' '
1848: ||' AND hn'||i||'.level_number = 1 '
1849: ||' AND hn'||i||'.child_table_name = ''HZ_GEOGRAPHIES'' '
1850: ||' AND SYSDATE BETWEEN hn'||i||'.effective_start_date AND hn'||i||'.effective_end_date '
1851: ||' AND NVL(hn'||i||'.status,''A'') = ''A'' '
1852: ||' AND hn'||i||'.parent_table_name = ''HZ_GEOGRAPHIES'' '
1853: ||' AND hn'||i||'.parent_id = p'||i||'.geography_id '

Line 1852: ||' AND hn'||i||'.parent_table_name = ''HZ_GEOGRAPHIES'' '

1848: ||' AND hn'||i||'.level_number = 1 '
1849: ||' AND hn'||i||'.child_table_name = ''HZ_GEOGRAPHIES'' '
1850: ||' AND SYSDATE BETWEEN hn'||i||'.effective_start_date AND hn'||i||'.effective_end_date '
1851: ||' AND NVL(hn'||i||'.status,''A'') = ''A'' '
1852: ||' AND hn'||i||'.parent_table_name = ''HZ_GEOGRAPHIES'' '
1853: ||' AND hn'||i||'.parent_id = p'||i||'.geography_id '
1854: ||' AND p'||i||'.geography_use = ''MASTER_REF'' '
1855: ||' AND SYSDATE BETWEEN p'||i||'.start_date AND p'||i||'.end_date ';
1856:

Line 2188: l_from := ' FROM hz_geographies hg0 ';

2184: 'hg0.GEOGRAPHY_ELEMENT9, hg0.GEOGRAPHY_ELEMENT9_ID,'||
2185: 'hg0.GEOGRAPHY_ELEMENT10, hg0.GEOGRAPHY_ELEMENT10_ID ';
2186:
2187: -- from clause
2188: l_from := ' FROM hz_geographies hg0 ';
2189:
2190: -- Mandatory where clause
2191: l_where := ' WHERE hg0.geography_use = ''MASTER_REF'' '||
2192: ' AND SYSDATE between hg0.start_date and hg0.end_date '||

Line 5431: ||', hz_geographies p1 ';

5427: IF (l_child_map_count = 1) THEN
5428: l_select_child := 'SELECT distinct p1.geography_id , p1.geography_name ,'
5429: ||'p1.geography_code , p1.geography_type ';
5430: l_from_child := ' FROM hz_hierarchy_nodes hn1'
5431: ||', hz_geographies p1 ';
5432: l_where_child := ' WHERE hn1.parent_id = :x_parent_geo_id '
5433: ||' AND hn1.HIERARCHY_TYPE = ''MASTER_REF'' '
5434: ||' AND hn1.level_number = 1 '
5435: ||' AND hn1.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '

Line 5435: ||' AND hn1.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '

5431: ||', hz_geographies p1 ';
5432: l_where_child := ' WHERE hn1.parent_id = :x_parent_geo_id '
5433: ||' AND hn1.HIERARCHY_TYPE = ''MASTER_REF'' '
5434: ||' AND hn1.level_number = 1 '
5435: ||' AND hn1.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5436: ||' AND SYSDATE BETWEEN hn1.effective_start_date AND hn1.effective_end_date '
5437: ||' AND NVL(hn1.status,''A'') = ''A'' '
5438: ||' AND hn1.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5439: ||' AND hn1.child_id = p1.geography_id '

Line 5438: ||' AND hn1.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '

5434: ||' AND hn1.level_number = 1 '
5435: ||' AND hn1.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5436: ||' AND SYSDATE BETWEEN hn1.effective_start_date AND hn1.effective_end_date '
5437: ||' AND NVL(hn1.status,''A'') = ''A'' '
5438: ||' AND hn1.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5439: ||' AND hn1.child_id = p1.geography_id '
5440: ||' AND p1.GEOGRAPHY_USE = ''MASTER_REF'' '
5441: ||' AND SYSDATE BETWEEN p1.start_date AND p1.end_date ';
5442: l_last_index_child := 1;

Line 5448: ||', hz_geographies p'||l_child_map_count ;

5444: l_select_child := l_select_child ||',p'||l_child_map_count||'.geography_id , p'||l_child_map_count||'.geography_name '
5445: ||',p'||l_child_map_count||'.geography_code, p'||l_child_map_count||'.geography_type ';
5446:
5447: l_from_child := l_from_child ||', hz_hierarchy_nodes hn'||l_child_map_count
5448: ||', hz_geographies p'||l_child_map_count ;
5449:
5450: l_where_child := l_where_child ||' AND hn'||l_child_map_count||'.parent_id = hn'||l_last_index_child||'.child_id '
5451: ||' AND hn'||l_child_map_count||'.HIERARCHY_TYPE = ''MASTER_REF'' '
5452: ||' AND hn'||l_child_map_count||'.level_number = 1 '

Line 5453: ||' AND hn'||l_child_map_count||'.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '

5449:
5450: l_where_child := l_where_child ||' AND hn'||l_child_map_count||'.parent_id = hn'||l_last_index_child||'.child_id '
5451: ||' AND hn'||l_child_map_count||'.HIERARCHY_TYPE = ''MASTER_REF'' '
5452: ||' AND hn'||l_child_map_count||'.level_number = 1 '
5453: ||' AND hn'||l_child_map_count||'.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5454: ||' AND SYSDATE BETWEEN hn'||l_child_map_count||'.effective_start_date AND hn'||l_child_map_count||'.effective_end_date '
5455: ||' AND NVL(hn'||l_child_map_count||'.status,''A'') = ''A'' '
5456: ||' AND hn'||l_child_map_count||'.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5457: ||' AND hn'||l_child_map_count||'.child_id = p'||l_child_map_count||'.geography_id '

Line 5456: ||' AND hn'||l_child_map_count||'.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '

5452: ||' AND hn'||l_child_map_count||'.level_number = 1 '
5453: ||' AND hn'||l_child_map_count||'.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5454: ||' AND SYSDATE BETWEEN hn'||l_child_map_count||'.effective_start_date AND hn'||l_child_map_count||'.effective_end_date '
5455: ||' AND NVL(hn'||l_child_map_count||'.status,''A'') = ''A'' '
5456: ||' AND hn'||l_child_map_count||'.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5457: ||' AND hn'||l_child_map_count||'.child_id = p'||l_child_map_count||'.geography_id '
5458: ||' AND p'||l_child_map_count||'.GEOGRAPHY_USE = ''MASTER_REF'' '
5459: ||' AND SYSDATE BETWEEN p'||l_child_map_count||'.start_date AND p'||l_child_map_count||'.end_date ';
5460: l_last_index_child := l_child_map_count;