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 750: ,hz_geographies hg

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

Line 764: ,hz_geographies hg

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

Line 866: l_country_only_name HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE;

862: l_error_location VARCHAR2(100);
863:
864: l_country_only_passed VARCHAR2(1);
865: l_country_only_mapped VARCHAR2(1);
866: l_country_only_name HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE;
867: l_country_only_id HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE;
868: l_country_only_code HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE;
869: l_search_type VARCHAR2(100);
870: l_addr_val_level VARCHAR2(100);

Line 867: l_country_only_id HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE;

863:
864: l_country_only_passed VARCHAR2(1);
865: l_country_only_mapped VARCHAR2(1);
866: l_country_only_name HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE;
867: l_country_only_id HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE;
868: l_country_only_code HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE;
869: l_search_type VARCHAR2(100);
870: l_addr_val_level VARCHAR2(100);
871:

Line 868: l_country_only_code HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE;

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

Line 875: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;

871:
872: l_max_passed_element_col_value NUMBER;
873: l_max_mapped_element_col_value NUMBER;
874: l_max_usage_element_col_value NUMBER;
875: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
876: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
877: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
878: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
879: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;

Line 876: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;

872: l_max_passed_element_col_value NUMBER;
873: l_max_mapped_element_col_value NUMBER;
874: l_max_usage_element_col_value NUMBER;
875: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
876: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
877: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
878: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
879: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;
880: l_geo_data_count INTEGER;

Line 877: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;

873: l_max_mapped_element_col_value NUMBER;
874: l_max_usage_element_col_value NUMBER;
875: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
876: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
877: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
878: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
879: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;
880: l_geo_data_count INTEGER;
881:

Line 878: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;

874: l_max_usage_element_col_value NUMBER;
875: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
876: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
877: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
878: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
879: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;
880: l_geo_data_count INTEGER;
881:
882: l_success VARCHAR2(10);

Line 879: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;

875: l_lowest_usage_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
876: l_last_geo_type_usg_val_psd hz_geographies.GEOGRAPHY_TYPE%TYPE;
877: l_lowest_passed_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
878: l_lowest_mapped_geo_type hz_geographies.GEOGRAPHY_TYPE%TYPE;
879: l_lowest_passed_geo_value hz_geographies.GEOGRAPHY_NAME%TYPE;
880: l_geo_data_count INTEGER;
881:
882: l_success VARCHAR2(10);
883: l_geo_validation_passed VARCHAR2(10);

Line 909: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

905:
906: ------ multi parent record
907: TYPE rec_type_mp IS RECORD
908: (
909: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
910: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
911: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
912: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
913: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 910: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

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

Line 911: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

907: TYPE rec_type_mp IS RECORD
908: (
909: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
910: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
911: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
912: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
913: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 912: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

908: (
909: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
910: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
911: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
912: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
913: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 913: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

909: geo_id_1 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
910: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
911: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
912: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
913: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 914: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

910: geo_name_1 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
911: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
912: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
913: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

911: geo_code_1 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
912: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
913: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

912: geo_type_1 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
913: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

913: geo_id_2 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
914: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

914: geo_name_2 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

915: geo_code_2 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

916: geo_type_2 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

917: geo_id_3 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

918: geo_name_3 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

919: geo_code_3 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

920: geo_type_3 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

921: geo_id_4 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

922: geo_name_4 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

923: geo_code_4 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

924: geo_type_4 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

925: geo_id_5 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

926: geo_name_5 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

927: geo_code_5 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

928: geo_type_5 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

929: geo_id_6 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

930: geo_name_6 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

931: geo_code_6 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

932: geo_type_6 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

933: geo_id_7 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

934: geo_name_7 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

935: geo_code_7 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

936: geo_type_7 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

Line 941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

937: geo_id_8 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

Line 942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

938: geo_name_8 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

Line 943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

939: geo_code_8 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

Line 944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,

940: geo_type_8 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE

Line 945: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,

941: geo_id_9 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE
949: );

Line 946: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,

942: geo_name_9 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE
949: );
950:

Line 947: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,

943: geo_code_9 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE
949: );
950:
951: rec_mp rec_type_mp;

Line 948: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE

944: geo_type_9 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE,
945: geo_id_10 HZ_GEOGRAPHIES.GEOGRAPHY_ID%TYPE,
946: geo_name_10 HZ_GEOGRAPHIES.GEOGRAPHY_NAME%TYPE,
947: geo_code_10 HZ_GEOGRAPHIES.GEOGRAPHY_CODE%TYPE,
948: geo_type_10 HZ_GEOGRAPHIES.GEOGRAPHY_TYPE%TYPE
949: );
950:
951: rec_mp rec_type_mp;
952:

Line 959: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,

955:
956: -----intermediate table record
957: TYPE geo_rec_type IS RECORD
958: (
959: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
960: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
961: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
962: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,

Line 960: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,

956: -----intermediate table record
957: TYPE geo_rec_type IS RECORD
958: (
959: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
960: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
961: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
962: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,

Line 961: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,

957: TYPE geo_rec_type IS RECORD
958: (
959: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
960: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
961: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
962: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,

Line 962: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,

958: (
959: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
960: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
961: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
962: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,

Line 963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,

959: GEOGRAPHY_ID hz_geographies.GEOGRAPHY_ID%TYPE,
960: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
961: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
962: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,

Line 964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,

960: GEOGRAPHY_TYPE hz_geographies.GEOGRAPHY_TYPE%TYPE,
961: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
962: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,

Line 965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,

961: GEOGRAPHY_NAME hz_geographies.GEOGRAPHY_NAME%TYPE,
962: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,

Line 966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,

962: GEOGRAPHY_CODE hz_geographies.GEOGRAPHY_CODE%TYPE,
963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,

Line 967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,

963: MULTIPLE_PARENT_FLAG hz_geographies.MULTIPLE_PARENT_FLAG%TYPE,
964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,

Line 968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,

964: COUNTRY_CODE hz_geographies.COUNTRY_CODE%TYPE,
965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,

Line 969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,

965: GEOGRAPHY_ELEMENT1 hz_geographies.GEOGRAPHY_ELEMENT1%TYPE,
966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,

Line 970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,

966: GEOGRAPHY_ELEMENT1_ID hz_geographies.GEOGRAPHY_ELEMENT1_ID%TYPE,
967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,

Line 971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,

967: GEOGRAPHY_ELEMENT1_CODE hz_geographies.GEOGRAPHY_ELEMENT1_CODE%TYPE,
968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,

Line 972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,

968: GEOGRAPHY_ELEMENT2 hz_geographies.GEOGRAPHY_ELEMENT2%TYPE,
969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,

Line 973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,

969: GEOGRAPHY_ELEMENT2_ID hz_geographies.GEOGRAPHY_ELEMENT2_ID%TYPE,
970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,

Line 974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,

970: GEOGRAPHY_ELEMENT2_CODE hz_geographies.GEOGRAPHY_ELEMENT2_CODE%TYPE,
971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,

Line 975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,

971: GEOGRAPHY_ELEMENT3 hz_geographies.GEOGRAPHY_ELEMENT3%TYPE,
972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,

Line 976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,

972: GEOGRAPHY_ELEMENT3_ID hz_geographies.GEOGRAPHY_ELEMENT3_ID%TYPE,
973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,

Line 977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,

973: GEOGRAPHY_ELEMENT3_CODE hz_geographies.GEOGRAPHY_ELEMENT3_CODE%TYPE,
974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,

Line 978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,

974: GEOGRAPHY_ELEMENT4 hz_geographies.GEOGRAPHY_ELEMENT4%TYPE,
975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,

Line 979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,

975: GEOGRAPHY_ELEMENT4_ID hz_geographies.GEOGRAPHY_ELEMENT4_ID%TYPE,
976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,

Line 980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,

976: GEOGRAPHY_ELEMENT4_CODE hz_geographies.GEOGRAPHY_ELEMENT4_CODE%TYPE,
977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,

Line 981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,

977: GEOGRAPHY_ELEMENT5 hz_geographies.GEOGRAPHY_ELEMENT5%TYPE,
978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,

Line 982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,

978: GEOGRAPHY_ELEMENT5_ID hz_geographies.GEOGRAPHY_ELEMENT5_ID%TYPE,
979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
986: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,

Line 983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,

979: GEOGRAPHY_ELEMENT5_CODE hz_geographies.GEOGRAPHY_ELEMENT5_CODE%TYPE,
980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
986: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
987: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,

Line 984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,

980: GEOGRAPHY_ELEMENT6 hz_geographies.GEOGRAPHY_ELEMENT6%TYPE,
981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
986: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
987: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
988: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,

Line 985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,

981: GEOGRAPHY_ELEMENT6_ID hz_geographies.GEOGRAPHY_ELEMENT6_ID%TYPE,
982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
986: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
987: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
988: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
989: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE

Line 986: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,

982: GEOGRAPHY_ELEMENT7 hz_geographies.GEOGRAPHY_ELEMENT7%TYPE,
983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
986: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
987: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
988: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
989: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE
990: );

Line 987: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,

983: GEOGRAPHY_ELEMENT7_ID hz_geographies.GEOGRAPHY_ELEMENT7_ID%TYPE,
984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
986: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
987: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
988: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
989: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE
990: );
991:

Line 988: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,

984: GEOGRAPHY_ELEMENT8 hz_geographies.GEOGRAPHY_ELEMENT8%TYPE,
985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
986: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
987: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
988: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
989: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE
990: );
991:
992: TYPE geo_rec_tbl_type IS TABLE OF geo_rec_type INDEX BY BINARY_INTEGER;

Line 989: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE

985: GEOGRAPHY_ELEMENT8_ID hz_geographies.GEOGRAPHY_ELEMENT8_ID%TYPE,
986: GEOGRAPHY_ELEMENT9 hz_geographies.GEOGRAPHY_ELEMENT9%TYPE,
987: GEOGRAPHY_ELEMENT9_ID hz_geographies.GEOGRAPHY_ELEMENT9_ID%TYPE,
988: GEOGRAPHY_ELEMENT10 hz_geographies.GEOGRAPHY_ELEMENT10%TYPE,
989: GEOGRAPHY_ELEMENT10_ID hz_geographies.GEOGRAPHY_ELEMENT10_ID%TYPE
990: );
991:
992: TYPE geo_rec_tbl_type IS TABLE OF geo_rec_type INDEX BY BINARY_INTEGER;
993:

Line 1002: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;

998: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
999:
1000: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1001: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1002: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1003: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1004: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1005: l_geo_rec_country_code hz_geographies.country_code%TYPE;
1006:

Line 1003: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;

999:
1000: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1001: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1002: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1003: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1004: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1005: l_geo_rec_country_code hz_geographies.country_code%TYPE;
1006:
1007: l_not_validated_geo_type VARCHAR2(200);

Line 1004: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;

1000: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1001: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1002: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1003: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1004: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1005: l_geo_rec_country_code hz_geographies.country_code%TYPE;
1006:
1007: l_not_validated_geo_type VARCHAR2(200);
1008: l_rec_count_flag VARCHAR2(10);

Line 1005: l_geo_rec_country_code hz_geographies.country_code%TYPE;

1001: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1002: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1003: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1004: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1005: l_geo_rec_country_code hz_geographies.country_code%TYPE;
1006:
1007: l_not_validated_geo_type VARCHAR2(200);
1008: l_rec_count_flag VARCHAR2(10);
1009:

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

1016: l_bind_counter NUMBER := 0;
1017:
1018: ---------------------------------------------------------------------+
1019: -- function to get table column name of hz_locations
1020: -- input is element column name from hz_geographies stored in mapping table
1021: ---------------------------------------------------------------------+
1022: FUNCTION get_mapped_tab_col (pf_element_column_name IN VARCHAR2) RETURN VARCHAR2
1023: IS
1024: x_loc_col VARCHAR2(100);

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

1055: RETURN x_loc_col;
1056: END get_tab_col_from_geo_type;
1057:
1058: ---------------------------------------------------------------------+
1059: -- function to get element column name of hz_geographies
1060: -- input is geography type from hz_geographies stored in mapping table
1061: ---------------------------------------------------------------------+
1062: FUNCTION get_element_col_for_geo_type (pf_geo_type IN VARCHAR2) RETURN VARCHAR2
1063: IS

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

1056: END get_tab_col_from_geo_type;
1057:
1058: ---------------------------------------------------------------------+
1059: -- function to get element column name of hz_geographies
1060: -- input is geography type from hz_geographies stored in mapping table
1061: ---------------------------------------------------------------------+
1062: FUNCTION get_element_col_for_geo_type (pf_geo_type IN VARCHAR2) RETURN VARCHAR2
1063: IS
1064: x_element_col VARCHAR2(100);

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

1096: END get_mapped_geo_type;
1097:
1098: ---------------------------------------------------------------------+
1099: -- function to get geography type for mapped column
1100: -- input is element column from hz_geographies stored in mapping table
1101: ---------------------------------------------------------------------+
1102: FUNCTION get_geo_type_from_element_col (pf_element_column IN VARCHAR2) RETURN VARCHAR2
1103: IS
1104: x_geo_type VARCHAR2(100);

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

1705: -- Input is geography_id for which there are multiple parents
1706: -- It will call insert_mp_in_geo_rec_proc to insert data in
1707: -- geo_rec table (intermediate plsql table)
1708: -----------------------------------------------------------------------------+
1709: PROCEDURE multiple_parent_proc (ll_geo_id hz_geographies.geography_id%TYPE
1710: ,ll_geo_type hz_geographies.geography_type%TYPE) IS
1711: l_structure_level_count NUMBER;
1712: l_insert_geo_valid_rec_final VARCHAR2(1);
1713: l_insert_geo_suggest_rec VARCHAR2(1);

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

1706: -- It will call insert_mp_in_geo_rec_proc to insert data in
1707: -- geo_rec table (intermediate plsql table)
1708: -----------------------------------------------------------------------------+
1709: PROCEDURE multiple_parent_proc (ll_geo_id hz_geographies.geography_id%TYPE
1710: ,ll_geo_type hz_geographies.geography_type%TYPE) IS
1711: l_structure_level_count NUMBER;
1712: l_insert_geo_valid_rec_final VARCHAR2(1);
1713: l_insert_geo_suggest_rec VARCHAR2(1);
1714:

Line 1754: l_from_mp := ' FROM hz_geographies p0 '

1750: l_select_mp := 'SELECT distinct p0.geography_id , p0.geography_name ,'
1751: ||'p0.geography_code , p0.geography_type '
1752: ||',p1.geography_id , p1.geography_name ,'
1753: ||'p1.geography_code , p1.geography_type ';
1754: l_from_mp := ' FROM hz_geographies p0 '
1755: ||', hz_hierarchy_nodes hn1'
1756: ||', hz_geographies p1 ';
1757: l_where_mp := ' WHERE hn1.child_id = p0.geography_id '
1758: ||' AND p0.geography_use = ''MASTER_REF'' '

Line 1756: ||', hz_geographies p1 ';

1752: ||',p1.geography_id , p1.geography_name ,'
1753: ||'p1.geography_code , p1.geography_type ';
1754: l_from_mp := ' FROM hz_geographies p0 '
1755: ||', hz_hierarchy_nodes hn1'
1756: ||', hz_geographies p1 ';
1757: l_where_mp := ' WHERE hn1.child_id = p0.geography_id '
1758: ||' AND p0.geography_use = ''MASTER_REF'' '
1759: ||' AND SYSDATE BETWEEN p0.start_date AND p0.end_date '
1760: ||' AND hn1.child_id = :x_missing_geo_id '

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

1759: ||' AND SYSDATE BETWEEN p0.start_date AND p0.end_date '
1760: ||' AND hn1.child_id = :x_missing_geo_id '
1761: ||' AND hn1.hierarchy_type = ''MASTER_REF'' '
1762: ||' AND hn1.level_number = 1 '
1763: ||' AND hn1.child_table_name = ''HZ_GEOGRAPHIES'' '
1764: ||' AND SYSDATE BETWEEN hn1.effective_start_date AND hn1.effective_end_date '
1765: ||' AND NVL(hn1.status,''A'') = ''A'' '
1766: ||' AND hn1.parent_table_name = ''HZ_GEOGRAPHIES'' '
1767: ||' AND hn1.parent_id = p1.geography_id '

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

1762: ||' AND hn1.level_number = 1 '
1763: ||' AND hn1.child_table_name = ''HZ_GEOGRAPHIES'' '
1764: ||' AND SYSDATE BETWEEN hn1.effective_start_date AND hn1.effective_end_date '
1765: ||' AND NVL(hn1.status,''A'') = ''A'' '
1766: ||' AND hn1.parent_table_name = ''HZ_GEOGRAPHIES'' '
1767: ||' AND hn1.parent_id = p1.geography_id '
1768: ||' AND p1.geography_use = ''MASTER_REF'' '
1769: ||' AND SYSDATE BETWEEN p1.start_date AND p1.end_date ';
1770:

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

1776: l_select_mp := l_select_mp ||',p'||i||'.geography_id , p'||i||'.geography_name '
1777: ||',p'||i||'.geography_code, p'||i||'.geography_type ';
1778:
1779: l_from_mp := l_from_mp ||', hz_hierarchy_nodes hn'||i
1780: ||', hz_geographies p'||i ;
1781:
1782: l_where_mp := l_where_mp ||' AND hn'||i||'.child_id = hn'||l_last_index_mp||'.parent_id '
1783: ||' AND hn'||i||'.hierarchy_type = ''MASTER_REF'' '
1784: ||' AND hn'||i||'.level_number = 1 '

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

1781:
1782: l_where_mp := l_where_mp ||' AND hn'||i||'.child_id = hn'||l_last_index_mp||'.parent_id '
1783: ||' AND hn'||i||'.hierarchy_type = ''MASTER_REF'' '
1784: ||' AND hn'||i||'.level_number = 1 '
1785: ||' AND hn'||i||'.child_table_name = ''HZ_GEOGRAPHIES'' '
1786: ||' AND SYSDATE BETWEEN hn'||i||'.effective_start_date AND hn'||i||'.effective_end_date '
1787: ||' AND NVL(hn'||i||'.status,''A'') = ''A'' '
1788: ||' AND hn'||i||'.parent_table_name = ''HZ_GEOGRAPHIES'' '
1789: ||' AND hn'||i||'.parent_id = p'||i||'.geography_id '

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

1784: ||' AND hn'||i||'.level_number = 1 '
1785: ||' AND hn'||i||'.child_table_name = ''HZ_GEOGRAPHIES'' '
1786: ||' AND SYSDATE BETWEEN hn'||i||'.effective_start_date AND hn'||i||'.effective_end_date '
1787: ||' AND NVL(hn'||i||'.status,''A'') = ''A'' '
1788: ||' AND hn'||i||'.parent_table_name = ''HZ_GEOGRAPHIES'' '
1789: ||' AND hn'||i||'.parent_id = p'||i||'.geography_id '
1790: ||' AND p'||i||'.geography_use = ''MASTER_REF'' '
1791: ||' AND SYSDATE BETWEEN p'||i||'.start_date AND p'||i||'.end_date ';
1792:

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

2120: 'hg0.GEOGRAPHY_ELEMENT9, hg0.GEOGRAPHY_ELEMENT9_ID,'||
2121: 'hg0.GEOGRAPHY_ELEMENT10, hg0.GEOGRAPHY_ELEMENT10_ID ';
2122:
2123: -- from clause
2124: l_from := ' FROM hz_geographies hg0 ';
2125:
2126: -- Mandatory where clause
2127: l_where := ' WHERE hg0.geography_use = ''MASTER_REF'' '||
2128: ' AND SYSDATE between hg0.start_date and hg0.end_date '||

Line 5300: ||', hz_geographies p1 ';

5296: IF (l_child_map_count = 1) THEN
5297: l_select_child := 'SELECT distinct p1.geography_id , p1.geography_name ,'
5298: ||'p1.geography_code , p1.geography_type ';
5299: l_from_child := ' FROM hz_hierarchy_nodes hn1'
5300: ||', hz_geographies p1 ';
5301: l_where_child := ' WHERE hn1.parent_id = :x_parent_geo_id '
5302: ||' AND hn1.HIERARCHY_TYPE = ''MASTER_REF'' '
5303: ||' AND hn1.level_number = 1 '
5304: ||' AND hn1.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '

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

5300: ||', hz_geographies p1 ';
5301: l_where_child := ' WHERE hn1.parent_id = :x_parent_geo_id '
5302: ||' AND hn1.HIERARCHY_TYPE = ''MASTER_REF'' '
5303: ||' AND hn1.level_number = 1 '
5304: ||' AND hn1.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5305: ||' AND SYSDATE BETWEEN hn1.effective_start_date AND hn1.effective_end_date '
5306: ||' AND NVL(hn1.status,''A'') = ''A'' '
5307: ||' AND hn1.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5308: ||' AND hn1.child_id = p1.geography_id '

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

5303: ||' AND hn1.level_number = 1 '
5304: ||' AND hn1.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5305: ||' AND SYSDATE BETWEEN hn1.effective_start_date AND hn1.effective_end_date '
5306: ||' AND NVL(hn1.status,''A'') = ''A'' '
5307: ||' AND hn1.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5308: ||' AND hn1.child_id = p1.geography_id '
5309: ||' AND p1.GEOGRAPHY_USE = ''MASTER_REF'' '
5310: ||' AND SYSDATE BETWEEN p1.start_date AND p1.end_date ';
5311: l_last_index_child := 1;

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

5313: l_select_child := l_select_child ||',p'||l_child_map_count||'.geography_id , p'||l_child_map_count||'.geography_name '
5314: ||',p'||l_child_map_count||'.geography_code, p'||l_child_map_count||'.geography_type ';
5315:
5316: l_from_child := l_from_child ||', hz_hierarchy_nodes hn'||l_child_map_count
5317: ||', hz_geographies p'||l_child_map_count ;
5318:
5319: l_where_child := l_where_child ||' AND hn'||l_child_map_count||'.parent_id = hn'||l_last_index_child||'.child_id '
5320: ||' AND hn'||l_child_map_count||'.HIERARCHY_TYPE = ''MASTER_REF'' '
5321: ||' AND hn'||l_child_map_count||'.level_number = 1 '

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

5318:
5319: l_where_child := l_where_child ||' AND hn'||l_child_map_count||'.parent_id = hn'||l_last_index_child||'.child_id '
5320: ||' AND hn'||l_child_map_count||'.HIERARCHY_TYPE = ''MASTER_REF'' '
5321: ||' AND hn'||l_child_map_count||'.level_number = 1 '
5322: ||' AND hn'||l_child_map_count||'.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5323: ||' AND SYSDATE BETWEEN hn'||l_child_map_count||'.effective_start_date AND hn'||l_child_map_count||'.effective_end_date '
5324: ||' AND NVL(hn'||l_child_map_count||'.status,''A'') = ''A'' '
5325: ||' AND hn'||l_child_map_count||'.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5326: ||' AND hn'||l_child_map_count||'.child_id = p'||l_child_map_count||'.geography_id '

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

5321: ||' AND hn'||l_child_map_count||'.level_number = 1 '
5322: ||' AND hn'||l_child_map_count||'.CHILD_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5323: ||' AND SYSDATE BETWEEN hn'||l_child_map_count||'.effective_start_date AND hn'||l_child_map_count||'.effective_end_date '
5324: ||' AND NVL(hn'||l_child_map_count||'.status,''A'') = ''A'' '
5325: ||' AND hn'||l_child_map_count||'.PARENT_TABLE_NAME = ''HZ_GEOGRAPHIES'' '
5326: ||' AND hn'||l_child_map_count||'.child_id = p'||l_child_map_count||'.geography_id '
5327: ||' AND p'||l_child_map_count||'.GEOGRAPHY_USE = ''MASTER_REF'' '
5328: ||' AND SYSDATE BETWEEN p'||l_child_map_count||'.start_date AND p'||l_child_map_count||'.end_date ';
5329: l_last_index_child := l_child_map_count;