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 806: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,

802: (
803: p_table_name IN VARCHAR2,
804: p_address_style IN VARCHAR2,
805: p_address_usage IN VARCHAR2,
806: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
807: p_state IN HZ_LOCATIONS.STATE%TYPE,
808: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
809: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
810: p_city IN HZ_LOCATIONS.CITY%TYPE,

Line 807: p_state IN HZ_LOCATIONS.STATE%TYPE,

803: p_table_name IN VARCHAR2,
804: p_address_style IN VARCHAR2,
805: p_address_usage IN VARCHAR2,
806: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
807: p_state IN HZ_LOCATIONS.STATE%TYPE,
808: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
809: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
810: p_city IN HZ_LOCATIONS.CITY%TYPE,
811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,

Line 808: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,

804: p_address_style IN VARCHAR2,
805: p_address_usage IN VARCHAR2,
806: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
807: p_state IN HZ_LOCATIONS.STATE%TYPE,
808: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
809: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
810: p_city IN HZ_LOCATIONS.CITY%TYPE,
811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,

Line 809: p_county IN HZ_LOCATIONS.COUNTY%TYPE,

805: p_address_usage IN VARCHAR2,
806: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
807: p_state IN HZ_LOCATIONS.STATE%TYPE,
808: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
809: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
810: p_city IN HZ_LOCATIONS.CITY%TYPE,
811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,

Line 810: p_city IN HZ_LOCATIONS.CITY%TYPE,

806: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
807: p_state IN HZ_LOCATIONS.STATE%TYPE,
808: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
809: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
810: p_city IN HZ_LOCATIONS.CITY%TYPE,
811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,

Line 811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,

807: p_state IN HZ_LOCATIONS.STATE%TYPE,
808: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
809: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
810: p_city IN HZ_LOCATIONS.CITY%TYPE,
811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
815: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,

Line 812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,

808: p_province IN HZ_LOCATIONS.PROVINCE%TYPE,
809: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
810: p_city IN HZ_LOCATIONS.CITY%TYPE,
811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
815: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
816: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,

Line 813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,

809: p_county IN HZ_LOCATIONS.COUNTY%TYPE,
810: p_city IN HZ_LOCATIONS.CITY%TYPE,
811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
815: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
816: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
817: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,

Line 814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,

810: p_city IN HZ_LOCATIONS.CITY%TYPE,
811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
815: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
816: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
817: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
818: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,

Line 815: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,

811: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE,
812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
815: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
816: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
817: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
818: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
819: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,

Line 816: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,

812: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE,
813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
815: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
816: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
817: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
818: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
819: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
820: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,

Line 817: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,

813: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE,
814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
815: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
816: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
817: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
818: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
819: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
820: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
821: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,

Line 818: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,

814: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE,
815: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE,
816: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
817: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
818: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
819: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
820: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
821: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,
822: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,

Line 819: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,

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

Line 820: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,

816: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE,
817: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
818: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
819: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
820: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
821: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,
822: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,
823: x_mapped_struct_count OUT NOCOPY NUMBER,
824: x_records_count OUT NOCOPY NUMBER,

Line 821: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,

817: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE,
818: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
819: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
820: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
821: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,
822: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,
823: x_mapped_struct_count OUT NOCOPY NUMBER,
824: x_records_count OUT NOCOPY NUMBER,
825: x_return_code OUT NOCOPY NUMBER,

Line 822: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,

818: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE,
819: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE,
820: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE,
821: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE,
822: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE,
823: x_mapped_struct_count OUT NOCOPY NUMBER,
824: x_records_count OUT NOCOPY NUMBER,
825: x_return_code OUT NOCOPY NUMBER,
826: x_validation_level OUT NOCOPY VARCHAR2,

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

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

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

1035: RETURN x_loc_col;
1036: END get_mapped_tab_col;
1037:
1038: ---------------------------------------------------------------------+
1039: -- function to get table column name of hz_locations
1040: -- input is geography type stored in mapping table
1041: ---------------------------------------------------------------------+
1042: FUNCTION get_tab_col_from_geo_type (pf_geo_type IN VARCHAR2) RETURN VARCHAR2
1043: IS

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

1076: END get_element_col_for_geo_type;
1077:
1078: ---------------------------------------------------------------------+
1079: -- function to get geo type
1080: -- input is table column name from hz_locations stored in mapping table
1081: ---------------------------------------------------------------------+
1082: FUNCTION get_mapped_geo_type (pf_loc_column_name IN VARCHAR2) RETURN VARCHAR2
1083: IS
1084: x_geo_type VARCHAR2(100);

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

1116: END get_geo_type_from_element_col;
1117:
1118: ---------------------------------------------------------------------+
1119: -- function to get parameter value
1120: -- input is column name from hz_locations stored in mapping table
1121: ---------------------------------------------------------------------+
1122: FUNCTION get_mapped_param_value (pf_loc_column_name IN VARCHAR2) RETURN VARCHAR2
1123: IS
1124: x_param_value VARCHAR2(100);

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

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