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_LOCATION_PROFILES_PKG dependencies on FND_API

Line 38: x_location_profile_id <> fnd_api.g_miss_num

34: -- and raise corresponding exception. We donot need to do anything
35: -- for those tables without polity functions.
36:
37: IF x_location_profile_id IS NOT NULL AND
38: x_location_profile_id <> fnd_api.g_miss_num
39: THEN
40: l_primary_key_passed := TRUE;
41: END IF;
42:

Line 72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,

68: object_version_number
69: )
70: VALUES (
71: DECODE(x_location_profile_id,
72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,
73: NULL, hz_location_profiles_s.NEXTVAL,
74: x_location_profile_id),
75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),

Line 75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),

71: DECODE(x_location_profile_id,
72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,
73: NULL, hz_location_profiles_s.NEXTVAL,
74: x_location_profile_id),
75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),
77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),
78: DECODE(x_effective_end_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_end_date),
79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),

Line 76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),

72: fnd_api.g_miss_num, hz_location_profiles_s.NEXTVAL,
73: NULL, hz_location_profiles_s.NEXTVAL,
74: x_location_profile_id),
75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),
77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),
78: DECODE(x_effective_end_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_end_date),
79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),
80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),

Line 77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),

73: NULL, hz_location_profiles_s.NEXTVAL,
74: x_location_profile_id),
75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),
77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),
78: DECODE(x_effective_end_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_end_date),
79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),
80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),
81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),

Line 78: DECODE(x_effective_end_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_end_date),

74: x_location_profile_id),
75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),
77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),
78: DECODE(x_effective_end_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_end_date),
79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),
80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),
81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),
82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),

Line 79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),

75: DECODE(x_location_id, fnd_api.g_miss_num, NULL, x_location_id),
76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),
77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),
78: DECODE(x_effective_end_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_end_date),
79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),
80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),
81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),
82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),

Line 80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),

76: DECODE(x_actual_content_source, fnd_api.g_miss_char, NULL, x_actual_content_source),
77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),
78: DECODE(x_effective_end_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_end_date),
79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),
80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),
81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),
82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),

Line 81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),

77: DECODE(x_effective_start_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_start_date),
78: DECODE(x_effective_end_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_end_date),
79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),
80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),
81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),
82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),

Line 82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),

78: DECODE(x_effective_end_date, fnd_api.g_miss_date, TO_DATE(NULL), x_effective_end_date),
79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),
80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),
81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),
82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),

Line 83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),

79: DECODE(x_validation_sst_flag, fnd_api.g_miss_char, NULL, x_validation_sst_flag),
80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),
81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),
82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
87: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),

Line 84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),

80: DECODE(x_validation_status_code, fnd_api.g_miss_char, NULL, x_validation_status_code),
81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),
82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
87: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
88: DECODE(x_prov_state_admin_code, fnd_api.g_miss_char, NULL, x_prov_state_admin_code),

Line 85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),

81: DECODE(x_date_validated, fnd_api.g_miss_date, TO_DATE(NULL), x_date_validated),
82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
87: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
88: DECODE(x_prov_state_admin_code, fnd_api.g_miss_char, NULL, x_prov_state_admin_code),
89: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),

Line 86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),

82: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
87: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
88: DECODE(x_prov_state_admin_code, fnd_api.g_miss_char, NULL, x_prov_state_admin_code),
89: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
90: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),

Line 87: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),

83: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
87: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
88: DECODE(x_prov_state_admin_code, fnd_api.g_miss_char, NULL, x_prov_state_admin_code),
89: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
90: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
91: hz_utility_v2pub.last_update_date,

Line 88: DECODE(x_prov_state_admin_code, fnd_api.g_miss_char, NULL, x_prov_state_admin_code),

84: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
87: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
88: DECODE(x_prov_state_admin_code, fnd_api.g_miss_char, NULL, x_prov_state_admin_code),
89: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
90: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
91: hz_utility_v2pub.last_update_date,
92: hz_utility_v2pub.last_updated_by,

Line 89: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),

85: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
87: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
88: DECODE(x_prov_state_admin_code, fnd_api.g_miss_char, NULL, x_prov_state_admin_code),
89: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
90: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
91: hz_utility_v2pub.last_update_date,
92: hz_utility_v2pub.last_updated_by,
93: hz_utility_v2pub.creation_date,

Line 90: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),

86: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
87: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
88: DECODE(x_prov_state_admin_code, fnd_api.g_miss_char, NULL, x_prov_state_admin_code),
89: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
90: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
91: hz_utility_v2pub.last_update_date,
92: hz_utility_v2pub.last_updated_by,
93: hz_utility_v2pub.creation_date,
94: hz_utility_v2pub.created_by,

Line 96: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number)

92: hz_utility_v2pub.last_updated_by,
93: hz_utility_v2pub.creation_date,
94: hz_utility_v2pub.created_by,
95: hz_utility_v2pub.last_update_login,
96: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number)
97: ) RETURNING
98: location_profile_id
99: INTO
100: x_location_profile_id;

Line 113: RAISE fnd_api.g_exc_error;

109: IF l_primary_key_passed THEN
110: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
111: fnd_message.set_token('COLUMN', 'location_profile_id');
112: fnd_msg_pub.add;
113: RAISE fnd_api.g_exc_error;
114: END IF;
115:
116: DECLARE
117: l_temp_profile_id NUMBER;

Line 161: fnd_api.g_miss_num, NULL,

157: BEGIN
158: UPDATE hz_location_profiles
159: SET location_profile_id = DECODE(x_location_profile_id,
160: NULL, location_profile_id,
161: fnd_api.g_miss_num, NULL,
162: x_location_profile_id),
163: location_id = DECODE(x_location_id,
164: NULL, location_id,
165: fnd_api.g_miss_num, NULL,

Line 165: fnd_api.g_miss_num, NULL,

161: fnd_api.g_miss_num, NULL,
162: x_location_profile_id),
163: location_id = DECODE(x_location_id,
164: NULL, location_id,
165: fnd_api.g_miss_num, NULL,
166: x_location_id),
167: actual_content_source = DECODE(x_actual_content_source,
168: NULL, actual_content_source,
169: fnd_api.g_miss_char, NULL,

Line 169: fnd_api.g_miss_char, NULL,

165: fnd_api.g_miss_num, NULL,
166: x_location_id),
167: actual_content_source = DECODE(x_actual_content_source,
168: NULL, actual_content_source,
169: fnd_api.g_miss_char, NULL,
170: x_actual_content_source),
171: effective_start_date = DECODE(x_effective_start_date,
172: NULL, effective_start_date,
173: fnd_api.g_miss_date, NULL,

Line 173: fnd_api.g_miss_date, NULL,

169: fnd_api.g_miss_char, NULL,
170: x_actual_content_source),
171: effective_start_date = DECODE(x_effective_start_date,
172: NULL, effective_start_date,
173: fnd_api.g_miss_date, NULL,
174: x_effective_start_date),
175: effective_end_date = DECODE(x_effective_end_date,
176: NULL, effective_end_date,
177: fnd_api.g_miss_date, NULL,

Line 177: fnd_api.g_miss_date, NULL,

173: fnd_api.g_miss_date, NULL,
174: x_effective_start_date),
175: effective_end_date = DECODE(x_effective_end_date,
176: NULL, effective_end_date,
177: fnd_api.g_miss_date, NULL,
178: x_effective_end_date),
179: validation_sst_flag = DECODE(x_validation_sst_flag,
180: NULL, validation_sst_flag,
181: fnd_api.g_miss_char, NULL,

Line 181: fnd_api.g_miss_char, NULL,

177: fnd_api.g_miss_date, NULL,
178: x_effective_end_date),
179: validation_sst_flag = DECODE(x_validation_sst_flag,
180: NULL, validation_sst_flag,
181: fnd_api.g_miss_char, NULL,
182: x_validation_sst_flag),
183: validation_status_code = DECODE(x_validation_status_code,
184: NULL, validation_status_code,
185: fnd_api.g_miss_char, NULL,

Line 185: fnd_api.g_miss_char, NULL,

181: fnd_api.g_miss_char, NULL,
182: x_validation_sst_flag),
183: validation_status_code = DECODE(x_validation_status_code,
184: NULL, validation_status_code,
185: fnd_api.g_miss_char, NULL,
186: x_validation_status_code),
187: date_validated = DECODE(x_date_validated,
188: NULL, date_validated,
189: fnd_api.g_miss_date, NULL,

Line 189: fnd_api.g_miss_date, NULL,

185: fnd_api.g_miss_char, NULL,
186: x_validation_status_code),
187: date_validated = DECODE(x_date_validated,
188: NULL, date_validated,
189: fnd_api.g_miss_date, NULL,
190: x_date_validated),
191: address1 = DECODE(x_address1,
192: NULL, address1,
193: fnd_api.g_miss_char, NULL,

Line 193: fnd_api.g_miss_char, NULL,

189: fnd_api.g_miss_date, NULL,
190: x_date_validated),
191: address1 = DECODE(x_address1,
192: NULL, address1,
193: fnd_api.g_miss_char, NULL,
194: x_address1),
195: address2 = DECODE(x_address2,
196: NULL, address2,
197: fnd_api.g_miss_char, NULL,

Line 197: fnd_api.g_miss_char, NULL,

193: fnd_api.g_miss_char, NULL,
194: x_address1),
195: address2 = DECODE(x_address2,
196: NULL, address2,
197: fnd_api.g_miss_char, NULL,
198: x_address2),
199: address3 = DECODE(x_address3,
200: NULL, address3,
201: fnd_api.g_miss_char, NULL,

Line 201: fnd_api.g_miss_char, NULL,

197: fnd_api.g_miss_char, NULL,
198: x_address2),
199: address3 = DECODE(x_address3,
200: NULL, address3,
201: fnd_api.g_miss_char, NULL,
202: x_address3),
203: address4 = DECODE(x_address4,
204: NULL, address4,
205: fnd_api.g_miss_char, NULL,

Line 205: fnd_api.g_miss_char, NULL,

201: fnd_api.g_miss_char, NULL,
202: x_address3),
203: address4 = DECODE(x_address4,
204: NULL, address4,
205: fnd_api.g_miss_char, NULL,
206: x_address4),
207: city = DECODE(x_city,
208: NULL, city,
209: fnd_api.g_miss_char, NULL,

Line 209: fnd_api.g_miss_char, NULL,

205: fnd_api.g_miss_char, NULL,
206: x_address4),
207: city = DECODE(x_city,
208: NULL, city,
209: fnd_api.g_miss_char, NULL,
210: x_city),
211: postal_code = DECODE(x_postal_code,
212: NULL, postal_code,
213: fnd_api.g_miss_char, NULL,

Line 213: fnd_api.g_miss_char, NULL,

209: fnd_api.g_miss_char, NULL,
210: x_city),
211: postal_code = DECODE(x_postal_code,
212: NULL, postal_code,
213: fnd_api.g_miss_char, NULL,
214: x_postal_code),
215: prov_state_admin_code = DECODE(x_prov_state_admin_code,
216: NULL, prov_state_admin_code,
217: fnd_api.g_miss_char, NULL,

Line 217: fnd_api.g_miss_char, NULL,

213: fnd_api.g_miss_char, NULL,
214: x_postal_code),
215: prov_state_admin_code = DECODE(x_prov_state_admin_code,
216: NULL, prov_state_admin_code,
217: fnd_api.g_miss_char, NULL,
218: x_prov_state_admin_code),
219: county = DECODE(x_county,
220: NULL, county,
221: fnd_api.g_miss_char, NULL,

Line 221: fnd_api.g_miss_char, NULL,

217: fnd_api.g_miss_char, NULL,
218: x_prov_state_admin_code),
219: county = DECODE(x_county,
220: NULL, county,
221: fnd_api.g_miss_char, NULL,
222: x_county),
223: country = DECODE(x_country,
224: NULL, country,
225: fnd_api.g_miss_char, NULL,

Line 225: fnd_api.g_miss_char, NULL,

221: fnd_api.g_miss_char, NULL,
222: x_county),
223: country = DECODE(x_country,
224: NULL, country,
225: fnd_api.g_miss_char, NULL,
226: x_country),
227: last_update_date = hz_utility_v2pub.last_update_date,
228: last_updated_by = hz_utility_v2pub.last_updated_by,
229: creation_date = creation_date,

Line 234: fnd_api.g_miss_num, NULL,

230: created_by = created_by,
231: last_update_login = hz_utility_v2pub.last_update_login,
232: object_version_number = DECODE(x_object_version_number,
233: NULL, object_version_number,
234: fnd_api.g_miss_num, NULL,
235: x_object_version_number)
236: WHERE ROWID = x_rowid;
237:
238: IF (SQL%NOTFOUND) THEN