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_LOCATIONS

Line 810: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,

806: (
807: p_table_name IN VARCHAR2,
808: p_address_style IN VARCHAR2,
809: p_address_usage IN VARCHAR2,
810: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
811: p_state IN HZ_LOCATIONS.STATE%TYPE,
812: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
813: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
814: p_city IN HZ_LOCATIONS.CITY%TYPE,

Line 811: p_state IN HZ_LOCATIONS.STATE%TYPE,

807: p_table_name IN VARCHAR2,
808: p_address_style IN VARCHAR2,
809: p_address_usage IN VARCHAR2,
810: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
811: p_state IN HZ_LOCATIONS.STATE%TYPE,
812: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
813: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
814: p_city IN HZ_LOCATIONS.CITY%TYPE,
815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,

Line 812: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,

808: p_address_style IN VARCHAR2,
809: p_address_usage IN VARCHAR2,
810: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
811: p_state IN HZ_LOCATIONS.STATE%TYPE,
812: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
813: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
814: p_city IN HZ_LOCATIONS.CITY%TYPE,
815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,

Line 813: p_county IN HZ_LOCATIONS.COUNTY%TYPE,

809: p_address_usage IN VARCHAR2,
810: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
811: p_state IN HZ_LOCATIONS.STATE%TYPE,
812: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
813: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
814: p_city IN HZ_LOCATIONS.CITY%TYPE,
815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,

Line 814: p_city IN HZ_LOCATIONS.CITY%TYPE,

810: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
811: p_state IN HZ_LOCATIONS.STATE%TYPE,
812: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
813: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
814: p_city IN HZ_LOCATIONS.CITY%TYPE,
815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,

Line 815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,

811: p_state IN HZ_LOCATIONS.STATE%TYPE,
812: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
813: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
814: p_city IN HZ_LOCATIONS.CITY%TYPE,
815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,

Line 816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,

812: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
813: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
814: p_city IN HZ_LOCATIONS.CITY%TYPE,
815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,

Line 817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,

813: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
814: p_city IN HZ_LOCATIONS.CITY%TYPE,
815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,

Line 818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,

814: p_city IN HZ_LOCATIONS.CITY%TYPE,
815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,

Line 819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,

815: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
823: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,

Line 820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,

816: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
823: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
824: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,

Line 821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,

817: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
823: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
824: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
825: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,

Line 822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,

818: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
823: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
824: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
825: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,
826: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,

Line 823: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,

819: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
823: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
824: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
825: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,
826: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,
827: x_mapped_struct_count OUT NOCOPY NUMBER,

Line 824: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,

820: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
823: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
824: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
825: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,
826: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,
827: x_mapped_struct_count OUT NOCOPY NUMBER,
828: x_records_count OUT NOCOPY NUMBER,

Line 825: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,

821: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
823: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
824: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
825: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,
826: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,
827: x_mapped_struct_count OUT NOCOPY NUMBER,
828: x_records_count OUT NOCOPY NUMBER,
829: x_return_code OUT NOCOPY NUMBER,

Line 826: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,

822: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
823: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
824: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
825: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,
826: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,
827: x_mapped_struct_count OUT NOCOPY NUMBER,
828: x_records_count OUT NOCOPY NUMBER,
829: x_return_code OUT NOCOPY NUMBER,
830: x_validation_level OUT NOCOPY VARCHAR2,

Line 1025: -- function to get table column name of hz_locations

1021: bind_table_3 bind_tbl_type;
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

Line 1045: -- function to get table column name of hz_locations

1041: RETURN x_loc_col;
1042: END get_mapped_tab_col;
1043:
1044: ---------------------------------------------------------------------+
1045: -- function to get table column name of hz_locations
1046: -- input is geography type stored in mapping table
1047: ---------------------------------------------------------------------+
1048: FUNCTION get_tab_col_from_geo_type (pf_geo_type IN VARCHAR2) RETURN VARCHAR2
1049: IS

Line 1086: -- input is table column name from hz_locations stored in mapping table

1082: END get_element_col_for_geo_type;
1083:
1084: ---------------------------------------------------------------------+
1085: -- function to get geo type
1086: -- input is table column name from hz_locations stored in mapping table
1087: ---------------------------------------------------------------------+
1088: FUNCTION get_mapped_geo_type (pf_loc_column_name IN VARCHAR2) RETURN VARCHAR2
1089: IS
1090: x_geo_type VARCHAR2(100);

Line 1126: -- input is column name from hz_locations stored in mapping table

1122: END get_geo_type_from_element_col;
1123:
1124: ---------------------------------------------------------------------+
1125: -- function to get parameter value
1126: -- input is column name from hz_locations stored in mapping table
1127: ---------------------------------------------------------------------+
1128: FUNCTION get_mapped_param_value (pf_loc_column_name IN VARCHAR2) RETURN VARCHAR2
1129: IS
1130: x_param_value VARCHAR2(100);

Line 1167: -- names of HZ_LOCATIONS stored in mapping table

1163:
1164:
1165: ---------------------------------------------------------------------+
1166: -- Procedure to build l_where_5 (detailed search where clause) based on column
1167: -- names of HZ_LOCATIONS stored in mapping table
1168: -- and update geo_struct_tbl with passed in parameter value
1169: -- it also checks if lowest level parameter is passed
1170: -- Retaining the procedure as this logic is performing faster. Drawback in
1171: -- this procedure is that it does not fetch multiple parents records.

Line 4168: l_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;

4164: AND hau.status_flag = 'A'
4165: AND hau.usage_id = haud.usage_id
4166: AND haud.geography_type = dmap.geography_type
4167: ORDER BY dmap.loc_seq_num;
4168: l_postal_code HZ_LOCATIONS.POSTAL_CODE%TYPE;
4169:
4170: BEGIN
4171:
4172: -- ER#7240974: get Postal Code value from postal_code_to_validate Function.