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 35: country hz_locations.country%TYPE,

31: TYPE geo_struct_tbl_type IS TABLE OF geo_struct_rec INDEX BY BINARY_INTEGER;
32:
33: TYPE geo_suggest_rec IS RECORD
34: (
35: country hz_locations.country%TYPE,
36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,

Line 39: state hz_locations.state%TYPE,

35: country hz_locations.country%TYPE,
36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,

Line 43: province hz_locations.province%TYPE,

39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,

Line 47: county hz_locations.county%TYPE,

43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,

Line 50: city hz_locations.city%TYPE,

46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,

Line 53: postal_code hz_locations.postal_code%TYPE,

49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,

Line 56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,

52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,

Line 59: attribute1 hz_locations.attribute1%TYPE,

55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,

Line 62: attribute2 hz_locations.attribute2%TYPE,

58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,

Line 65: attribute3 hz_locations.attribute3%TYPE,

61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,

Line 68: attribute4 hz_locations.attribute4%TYPE,

64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,

Line 71: attribute5 hz_locations.attribute5%TYPE,

67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,

Line 74: attribute6 hz_locations.attribute6%TYPE,

70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,

Line 77: attribute7 hz_locations.attribute7%TYPE,

73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,

Line 80: attribute8 hz_locations.attribute8%TYPE,

76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,

Line 83: attribute9 hz_locations.attribute9%TYPE,

79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,

Line 86: attribute10 hz_locations.attribute10%TYPE,

82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,
88: attribute10_geo_type hz_geographies.geography_type%TYPE,
89: suggestion_list VARCHAR2(4000)
90: );

Line 96: p_table_name IN VARCHAR2 DEFAULT 'HZ_LOCATIONS',

92: TYPE geo_suggest_tbl_type IS TABLE OF geo_suggest_rec INDEX BY BINARY_INTEGER;
93:
94: PROCEDURE search_geographies
95: (
96: p_table_name IN VARCHAR2 DEFAULT 'HZ_LOCATIONS',
97: p_address_style IN VARCHAR2 DEFAULT NULL,
98: p_address_usage IN VARCHAR2 DEFAULT 'GEOGRAPHY',
99: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
100: p_state IN HZ_LOCATIONS.STATE%TYPE DEFAULT NULL,

Line 99: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,

95: (
96: p_table_name IN VARCHAR2 DEFAULT 'HZ_LOCATIONS',
97: p_address_style IN VARCHAR2 DEFAULT NULL,
98: p_address_usage IN VARCHAR2 DEFAULT 'GEOGRAPHY',
99: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
100: p_state IN HZ_LOCATIONS.STATE%TYPE DEFAULT NULL,
101: p_province IN HZ_LOCATIONS.PROVINCE%TYPE DEFAULT NULL,
102: p_county IN HZ_LOCATIONS.COUNTY%TYPE DEFAULT NULL,
103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,

Line 100: p_state IN HZ_LOCATIONS.STATE%TYPE DEFAULT NULL,

96: p_table_name IN VARCHAR2 DEFAULT 'HZ_LOCATIONS',
97: p_address_style IN VARCHAR2 DEFAULT NULL,
98: p_address_usage IN VARCHAR2 DEFAULT 'GEOGRAPHY',
99: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
100: p_state IN HZ_LOCATIONS.STATE%TYPE DEFAULT NULL,
101: p_province IN HZ_LOCATIONS.PROVINCE%TYPE DEFAULT NULL,
102: p_county IN HZ_LOCATIONS.COUNTY%TYPE DEFAULT NULL,
103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,
104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,

Line 101: p_province IN HZ_LOCATIONS.PROVINCE%TYPE DEFAULT NULL,

97: p_address_style IN VARCHAR2 DEFAULT NULL,
98: p_address_usage IN VARCHAR2 DEFAULT 'GEOGRAPHY',
99: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
100: p_state IN HZ_LOCATIONS.STATE%TYPE DEFAULT NULL,
101: p_province IN HZ_LOCATIONS.PROVINCE%TYPE DEFAULT NULL,
102: p_county IN HZ_LOCATIONS.COUNTY%TYPE DEFAULT NULL,
103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,
104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,

Line 102: p_county IN HZ_LOCATIONS.COUNTY%TYPE DEFAULT NULL,

98: p_address_usage IN VARCHAR2 DEFAULT 'GEOGRAPHY',
99: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
100: p_state IN HZ_LOCATIONS.STATE%TYPE DEFAULT NULL,
101: p_province IN HZ_LOCATIONS.PROVINCE%TYPE DEFAULT NULL,
102: p_county IN HZ_LOCATIONS.COUNTY%TYPE DEFAULT NULL,
103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,
104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,
106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,

Line 103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,

99: p_country_code IN HZ_LOCATIONS.COUNTRY%TYPE,
100: p_state IN HZ_LOCATIONS.STATE%TYPE DEFAULT NULL,
101: p_province IN HZ_LOCATIONS.PROVINCE%TYPE DEFAULT NULL,
102: p_county IN HZ_LOCATIONS.COUNTY%TYPE DEFAULT NULL,
103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,
104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,
106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,

100: p_state IN HZ_LOCATIONS.STATE%TYPE DEFAULT NULL,
101: p_province IN HZ_LOCATIONS.PROVINCE%TYPE DEFAULT NULL,
102: p_county IN HZ_LOCATIONS.COUNTY%TYPE DEFAULT NULL,
103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,
104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,
106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,

101: p_province IN HZ_LOCATIONS.PROVINCE%TYPE DEFAULT NULL,
102: p_county IN HZ_LOCATIONS.COUNTY%TYPE DEFAULT NULL,
103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,
104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,
106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,

102: p_county IN HZ_LOCATIONS.COUNTY%TYPE DEFAULT NULL,
103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,
104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,
106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,

103: p_city IN HZ_LOCATIONS.CITY%TYPE DEFAULT NULL,
104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,
106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,

104: p_postal_code IN HZ_LOCATIONS.POSTAL_CODE%TYPE DEFAULT NULL,
105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,
106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
112: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,

105: p_postal_plus4_code IN HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE DEFAULT NULL,
106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
112: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
113: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

106: p_attribute1 IN HZ_LOCATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
112: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
113: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
114: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

107: p_attribute2 IN HZ_LOCATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
112: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
113: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
114: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
115: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 112: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

108: p_attribute3 IN HZ_LOCATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
112: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
113: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
114: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
115: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
116: x_mapped_struct_count OUT NOCOPY NUMBER,

Line 113: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

109: p_attribute4 IN HZ_LOCATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
112: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
113: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
114: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
115: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
116: x_mapped_struct_count OUT NOCOPY NUMBER,
117: x_records_count OUT NOCOPY NUMBER,

Line 114: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

110: p_attribute5 IN HZ_LOCATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
112: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
113: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
114: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
115: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
116: x_mapped_struct_count OUT NOCOPY NUMBER,
117: x_records_count OUT NOCOPY NUMBER,
118: x_return_code OUT NOCOPY NUMBER,

Line 115: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,

111: p_attribute6 IN HZ_LOCATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
112: p_attribute7 IN HZ_LOCATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
113: p_attribute8 IN HZ_LOCATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
114: p_attribute9 IN HZ_LOCATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
115: p_attribute10 IN HZ_LOCATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
116: x_mapped_struct_count OUT NOCOPY NUMBER,
117: x_records_count OUT NOCOPY NUMBER,
118: x_return_code OUT NOCOPY NUMBER,
119: x_validation_level OUT NOCOPY VARCHAR2,