APPS.HZ_ORIG_SYSTEM_REF_PKG dependencies on FND_API

Line 45: IF x_orig_system_ref_id = FND_API.G_MISS_NUM THEN

41: ) IS
42:
43: BEGIN
44:
45: IF x_orig_system_ref_id = FND_API.G_MISS_NUM THEN
46: x_orig_system_ref_id := NULL;
47: END IF;
48:
49: INSERT INTO HZ_ORIG_SYS_REFERENCES (

Line 94: FND_API.G_MISS_NUM, HZ_ORIG_SYSTEM_REF_S.NEXTVAL,

90: attribute20
91: )
92: VALUES (
93: DECODE(x_orig_system_ref_id,
94: FND_API.G_MISS_NUM, HZ_ORIG_SYSTEM_REF_S.NEXTVAL,
95: NULL, HZ_ORIG_SYSTEM_REF_S.NEXTVAL,
96: x_orig_system_ref_id),
97: DECODE(x_orig_system,
98: FND_API.G_MISS_CHAR, NULL,

Line 98: FND_API.G_MISS_CHAR, NULL,

94: FND_API.G_MISS_NUM, HZ_ORIG_SYSTEM_REF_S.NEXTVAL,
95: NULL, HZ_ORIG_SYSTEM_REF_S.NEXTVAL,
96: x_orig_system_ref_id),
97: DECODE(x_orig_system,
98: FND_API.G_MISS_CHAR, NULL,
99: x_orig_system),
100: DECODE(x_orig_system_reference,
101: FND_API.G_MISS_CHAR, NULL,
102: x_orig_system_reference),

Line 101: FND_API.G_MISS_CHAR, NULL,

97: DECODE(x_orig_system,
98: FND_API.G_MISS_CHAR, NULL,
99: x_orig_system),
100: DECODE(x_orig_system_reference,
101: FND_API.G_MISS_CHAR, NULL,
102: x_orig_system_reference),
103: DECODE(x_owner_table_name,
104: FND_API.G_MISS_CHAR, NULL,
105: x_owner_table_name),

Line 104: FND_API.G_MISS_CHAR, NULL,

100: DECODE(x_orig_system_reference,
101: FND_API.G_MISS_CHAR, NULL,
102: x_orig_system_reference),
103: DECODE(x_owner_table_name,
104: FND_API.G_MISS_CHAR, NULL,
105: x_owner_table_name),
106: DECODE(x_owner_table_id,
107: FND_API.G_MISS_NUM, NULL,
108: x_owner_table_id),

Line 107: FND_API.G_MISS_NUM, NULL,

103: DECODE(x_owner_table_name,
104: FND_API.G_MISS_CHAR, NULL,
105: x_owner_table_name),
106: DECODE(x_owner_table_id,
107: FND_API.G_MISS_NUM, NULL,
108: x_owner_table_id),
109: --raji
110: DECODE(x_party_id,
111: FND_API.G_MISS_NUM,NULL,

Line 111: FND_API.G_MISS_NUM,NULL,

107: FND_API.G_MISS_NUM, NULL,
108: x_owner_table_id),
109: --raji
110: DECODE(x_party_id,
111: FND_API.G_MISS_NUM,NULL,
112: x_party_id),
113: DECODE(x_status,
114: FND_API.G_MISS_CHAR, 'A',
115: NULL, 'A',

Line 114: FND_API.G_MISS_CHAR, 'A',

110: DECODE(x_party_id,
111: FND_API.G_MISS_NUM,NULL,
112: x_party_id),
113: DECODE(x_status,
114: FND_API.G_MISS_CHAR, 'A',
115: NULL, 'A',
116: x_status),
117: DECODE(x_reason_code,
118: FND_API.G_MISS_CHAR, NULL,

Line 118: FND_API.G_MISS_CHAR, NULL,

114: FND_API.G_MISS_CHAR, 'A',
115: NULL, 'A',
116: x_status),
117: DECODE(x_reason_code,
118: FND_API.G_MISS_CHAR, NULL,
119: x_reason_code),
120: DECODE(x_old_orig_system_reference,
121: FND_API.G_MISS_CHAR, NULL,
122: x_old_orig_system_reference),

Line 121: FND_API.G_MISS_CHAR, NULL,

117: DECODE(x_reason_code,
118: FND_API.G_MISS_CHAR, NULL,
119: x_reason_code),
120: DECODE(x_old_orig_system_reference,
121: FND_API.G_MISS_CHAR, NULL,
122: x_old_orig_system_reference),
123: DECODE(x_start_date_active,
124: FND_API.G_MISS_DATE, SYSDATE,TO_DATE(NULL), SYSDATE,
125: x_start_date_active),

Line 124: FND_API.G_MISS_DATE, SYSDATE,TO_DATE(NULL), SYSDATE,

120: DECODE(x_old_orig_system_reference,
121: FND_API.G_MISS_CHAR, NULL,
122: x_old_orig_system_reference),
123: DECODE(x_start_date_active,
124: FND_API.G_MISS_DATE, SYSDATE,TO_DATE(NULL), SYSDATE,
125: x_start_date_active),
126: DECODE(x_end_date_active,
127: FND_API.G_MISS_DATE, TO_DATE(NULL),
128: x_end_date_active),

Line 127: FND_API.G_MISS_DATE, TO_DATE(NULL),

123: DECODE(x_start_date_active,
124: FND_API.G_MISS_DATE, SYSDATE,TO_DATE(NULL), SYSDATE,
125: x_start_date_active),
126: DECODE(x_end_date_active,
127: FND_API.G_MISS_DATE, TO_DATE(NULL),
128: x_end_date_active),
129: hz_utility_v2pub.created_by,
130: hz_utility_v2pub.creation_date,
131: hz_utility_v2pub.last_updated_by,

Line 135: FND_API.G_MISS_NUM, NULL,

131: hz_utility_v2pub.last_updated_by,
132: hz_utility_v2pub.last_update_date,
133: hz_utility_v2pub.last_update_login,
134: DECODE(x_object_version_number,
135: FND_API.G_MISS_NUM, NULL,
136: x_object_version_number),
137: DECODE(x_created_by_module,
138: FND_API.G_MISS_CHAR, 'MOSR',NULL, 'MOSR',
139: x_created_by_module),

Line 138: FND_API.G_MISS_CHAR, 'MOSR',NULL, 'MOSR',

134: DECODE(x_object_version_number,
135: FND_API.G_MISS_NUM, NULL,
136: x_object_version_number),
137: DECODE(x_created_by_module,
138: FND_API.G_MISS_CHAR, 'MOSR',NULL, 'MOSR',
139: x_created_by_module),
140: hz_utility_v2pub.application_id,
141: DECODE(x_attribute_category,
142: FND_API.G_MISS_CHAR, NULL,

Line 142: FND_API.G_MISS_CHAR, NULL,

138: FND_API.G_MISS_CHAR, 'MOSR',NULL, 'MOSR',
139: x_created_by_module),
140: hz_utility_v2pub.application_id,
141: DECODE(x_attribute_category,
142: FND_API.G_MISS_CHAR, NULL,
143: x_attribute_category),
144: DECODE(x_attribute1,
145: FND_API.G_MISS_CHAR, NULL,
146: x_attribute1),

Line 145: FND_API.G_MISS_CHAR, NULL,

141: DECODE(x_attribute_category,
142: FND_API.G_MISS_CHAR, NULL,
143: x_attribute_category),
144: DECODE(x_attribute1,
145: FND_API.G_MISS_CHAR, NULL,
146: x_attribute1),
147: DECODE(x_attribute2,
148: FND_API.G_MISS_CHAR, NULL,
149: x_attribute2),

Line 148: FND_API.G_MISS_CHAR, NULL,

144: DECODE(x_attribute1,
145: FND_API.G_MISS_CHAR, NULL,
146: x_attribute1),
147: DECODE(x_attribute2,
148: FND_API.G_MISS_CHAR, NULL,
149: x_attribute2),
150: DECODE(x_attribute3,
151: FND_API.G_MISS_CHAR, NULL,
152: x_attribute3),

Line 151: FND_API.G_MISS_CHAR, NULL,

147: DECODE(x_attribute2,
148: FND_API.G_MISS_CHAR, NULL,
149: x_attribute2),
150: DECODE(x_attribute3,
151: FND_API.G_MISS_CHAR, NULL,
152: x_attribute3),
153: DECODE(x_attribute4,
154: FND_API.G_MISS_CHAR, NULL,
155: x_attribute4),

Line 154: FND_API.G_MISS_CHAR, NULL,

150: DECODE(x_attribute3,
151: FND_API.G_MISS_CHAR, NULL,
152: x_attribute3),
153: DECODE(x_attribute4,
154: FND_API.G_MISS_CHAR, NULL,
155: x_attribute4),
156: DECODE(x_attribute5,
157: FND_API.G_MISS_CHAR, NULL,
158: x_attribute5),

Line 157: FND_API.G_MISS_CHAR, NULL,

153: DECODE(x_attribute4,
154: FND_API.G_MISS_CHAR, NULL,
155: x_attribute4),
156: DECODE(x_attribute5,
157: FND_API.G_MISS_CHAR, NULL,
158: x_attribute5),
159: DECODE(x_attribute6,
160: FND_API.G_MISS_CHAR, NULL,
161: x_attribute6),

Line 160: FND_API.G_MISS_CHAR, NULL,

156: DECODE(x_attribute5,
157: FND_API.G_MISS_CHAR, NULL,
158: x_attribute5),
159: DECODE(x_attribute6,
160: FND_API.G_MISS_CHAR, NULL,
161: x_attribute6),
162: DECODE(x_attribute7,
163: FND_API.G_MISS_CHAR, NULL,
164: x_attribute7),

Line 163: FND_API.G_MISS_CHAR, NULL,

159: DECODE(x_attribute6,
160: FND_API.G_MISS_CHAR, NULL,
161: x_attribute6),
162: DECODE(x_attribute7,
163: FND_API.G_MISS_CHAR, NULL,
164: x_attribute7),
165: DECODE(x_attribute8,
166: FND_API.G_MISS_CHAR, NULL,
167: x_attribute8),

Line 166: FND_API.G_MISS_CHAR, NULL,

162: DECODE(x_attribute7,
163: FND_API.G_MISS_CHAR, NULL,
164: x_attribute7),
165: DECODE(x_attribute8,
166: FND_API.G_MISS_CHAR, NULL,
167: x_attribute8),
168: DECODE(x_attribute9,
169: FND_API.G_MISS_CHAR, NULL,
170: x_attribute9),

Line 169: FND_API.G_MISS_CHAR, NULL,

165: DECODE(x_attribute8,
166: FND_API.G_MISS_CHAR, NULL,
167: x_attribute8),
168: DECODE(x_attribute9,
169: FND_API.G_MISS_CHAR, NULL,
170: x_attribute9),
171: DECODE(x_attribute10,
172: FND_API.G_MISS_CHAR, NULL,
173: x_attribute10),

Line 172: FND_API.G_MISS_CHAR, NULL,

168: DECODE(x_attribute9,
169: FND_API.G_MISS_CHAR, NULL,
170: x_attribute9),
171: DECODE(x_attribute10,
172: FND_API.G_MISS_CHAR, NULL,
173: x_attribute10),
174: DECODE(x_attribute11,
175: FND_API.G_MISS_CHAR, NULL,
176: x_attribute11),

Line 175: FND_API.G_MISS_CHAR, NULL,

171: DECODE(x_attribute10,
172: FND_API.G_MISS_CHAR, NULL,
173: x_attribute10),
174: DECODE(x_attribute11,
175: FND_API.G_MISS_CHAR, NULL,
176: x_attribute11),
177: DECODE(x_attribute12,
178: FND_API.G_MISS_CHAR, NULL,
179: x_attribute12),

Line 178: FND_API.G_MISS_CHAR, NULL,

174: DECODE(x_attribute11,
175: FND_API.G_MISS_CHAR, NULL,
176: x_attribute11),
177: DECODE(x_attribute12,
178: FND_API.G_MISS_CHAR, NULL,
179: x_attribute12),
180: DECODE(x_attribute13,
181: FND_API.G_MISS_CHAR, NULL,
182: x_attribute13),

Line 181: FND_API.G_MISS_CHAR, NULL,

177: DECODE(x_attribute12,
178: FND_API.G_MISS_CHAR, NULL,
179: x_attribute12),
180: DECODE(x_attribute13,
181: FND_API.G_MISS_CHAR, NULL,
182: x_attribute13),
183: DECODE(x_attribute14,
184: FND_API.G_MISS_CHAR, NULL,
185: x_attribute14),

Line 184: FND_API.G_MISS_CHAR, NULL,

180: DECODE(x_attribute13,
181: FND_API.G_MISS_CHAR, NULL,
182: x_attribute13),
183: DECODE(x_attribute14,
184: FND_API.G_MISS_CHAR, NULL,
185: x_attribute14),
186: DECODE(x_attribute15,
187: FND_API.G_MISS_CHAR, NULL,
188: x_attribute15),

Line 187: FND_API.G_MISS_CHAR, NULL,

183: DECODE(x_attribute14,
184: FND_API.G_MISS_CHAR, NULL,
185: x_attribute14),
186: DECODE(x_attribute15,
187: FND_API.G_MISS_CHAR, NULL,
188: x_attribute15),
189: DECODE(x_attribute16,
190: FND_API.G_MISS_CHAR, NULL,
191: x_attribute16),

Line 190: FND_API.G_MISS_CHAR, NULL,

186: DECODE(x_attribute15,
187: FND_API.G_MISS_CHAR, NULL,
188: x_attribute15),
189: DECODE(x_attribute16,
190: FND_API.G_MISS_CHAR, NULL,
191: x_attribute16),
192: DECODE(x_attribute17,
193: FND_API.G_MISS_CHAR, NULL,
194: x_attribute17),

Line 193: FND_API.G_MISS_CHAR, NULL,

189: DECODE(x_attribute16,
190: FND_API.G_MISS_CHAR, NULL,
191: x_attribute16),
192: DECODE(x_attribute17,
193: FND_API.G_MISS_CHAR, NULL,
194: x_attribute17),
195: DECODE(x_attribute18,
196: FND_API.G_MISS_CHAR, NULL,
197: x_attribute18),

Line 196: FND_API.G_MISS_CHAR, NULL,

192: DECODE(x_attribute17,
193: FND_API.G_MISS_CHAR, NULL,
194: x_attribute17),
195: DECODE(x_attribute18,
196: FND_API.G_MISS_CHAR, NULL,
197: x_attribute18),
198: DECODE(x_attribute19,
199: FND_API.G_MISS_CHAR, NULL,
200: x_attribute19),

Line 199: FND_API.G_MISS_CHAR, NULL,

195: DECODE(x_attribute18,
196: FND_API.G_MISS_CHAR, NULL,
197: x_attribute18),
198: DECODE(x_attribute19,
199: FND_API.G_MISS_CHAR, NULL,
200: x_attribute19),
201: DECODE(x_attribute20,
202: FND_API.G_MISS_CHAR, NULL,
203: x_attribute20)

Line 202: FND_API.G_MISS_CHAR, NULL,

198: DECODE(x_attribute19,
199: FND_API.G_MISS_CHAR, NULL,
200: x_attribute19),
201: DECODE(x_attribute20,
202: FND_API.G_MISS_CHAR, NULL,
203: x_attribute20)
204: ) returning orig_system_ref_id into x_orig_system_ref_id;
205:
206: END Insert_Row;

Line 253: FND_API.G_MISS_NUM, NULL,

249: SET
250: orig_system_ref_id =
251: DECODE(x_orig_system_ref_id,
252: NULL, orig_system_ref_id,
253: FND_API.G_MISS_NUM, NULL,
254: x_orig_system_ref_id),
255: orig_system =
256: DECODE(x_orig_system,
257: NULL, orig_system,

Line 258: FND_API.G_MISS_CHAR, NULL,

254: x_orig_system_ref_id),
255: orig_system =
256: DECODE(x_orig_system,
257: NULL, orig_system,
258: FND_API.G_MISS_CHAR, NULL,
259: x_orig_system),
260: orig_system_reference =
261: DECODE(x_orig_system_reference,
262: NULL, orig_system_reference,

Line 263: FND_API.G_MISS_CHAR, NULL,

259: x_orig_system),
260: orig_system_reference =
261: DECODE(x_orig_system_reference,
262: NULL, orig_system_reference,
263: FND_API.G_MISS_CHAR, NULL,
264: x_orig_system_reference),
265: owner_table_name =
266: DECODE(x_owner_table_name,
267: NULL, owner_table_name,

Line 268: FND_API.G_MISS_CHAR, NULL,

264: x_orig_system_reference),
265: owner_table_name =
266: DECODE(x_owner_table_name,
267: NULL, owner_table_name,
268: FND_API.G_MISS_CHAR, NULL,
269: x_owner_table_name),
270: owner_table_id =
271: DECODE(x_owner_table_id,
272: NULL, owner_table_id,

Line 273: FND_API.G_MISS_NUM, NULL,

269: x_owner_table_name),
270: owner_table_id =
271: DECODE(x_owner_table_id,
272: NULL, owner_table_id,
273: FND_API.G_MISS_NUM, NULL,
274: x_owner_table_id),
275: --raji
276: party_id =
277: DECODE(x_party_id,

Line 279: FND_API.G_MISS_NUM, NULL,

275: --raji
276: party_id =
277: DECODE(x_party_id,
278: NULL,party_id,
279: FND_API.G_MISS_NUM, NULL,
280: x_party_id),
281: status =
282: DECODE(x_status,
283: NULL, status,

Line 284: FND_API.G_MISS_CHAR, NULL,

280: x_party_id),
281: status =
282: DECODE(x_status,
283: NULL, status,
284: FND_API.G_MISS_CHAR, NULL,
285: x_status),
286: reason_code =
287: DECODE(x_reason_code,
288: NULL, reason_code,

Line 289: FND_API.G_MISS_CHAR, NULL,

285: x_status),
286: reason_code =
287: DECODE(x_reason_code,
288: NULL, reason_code,
289: FND_API.G_MISS_CHAR, NULL,
290: x_reason_code),
291: old_orig_system_reference =
292: DECODE(x_old_orig_system_reference,
293: NULL, old_orig_system_reference,

Line 294: FND_API.G_MISS_CHAR, NULL,

290: x_reason_code),
291: old_orig_system_reference =
292: DECODE(x_old_orig_system_reference,
293: NULL, old_orig_system_reference,
294: FND_API.G_MISS_CHAR, NULL,
295: x_old_orig_system_reference),
296: start_date_active =
297: DECODE(x_start_date_active,
298: NULL, start_date_active,

Line 299: FND_API.G_MISS_DATE, NULL,

295: x_old_orig_system_reference),
296: start_date_active =
297: DECODE(x_start_date_active,
298: NULL, start_date_active,
299: FND_API.G_MISS_DATE, NULL,
300: x_start_date_active),
301: end_date_active =
302: DECODE(x_end_date_active,
303: NULL, end_date_active,

Line 304: FND_API.G_MISS_DATE, NULL,

300: x_start_date_active),
301: end_date_active =
302: DECODE(x_end_date_active,
303: NULL, end_date_active,
304: FND_API.G_MISS_DATE, NULL,
305: x_end_date_active),
306: created_by = created_by,
307: creation_date = creation_date,
308: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 314: FND_API.G_MISS_NUM, NULL,

310: last_update_login = hz_utility_v2pub.last_update_login,
311: object_version_number =
312: DECODE(x_object_version_number,
313: NULL, object_version_number,
314: FND_API.G_MISS_NUM, NULL,
315: x_object_version_number),
316: created_by_module =
317: DECODE(x_created_by_module,
318: NULL, created_by_module,

Line 319: FND_API.G_MISS_CHAR, NULL,

315: x_object_version_number),
316: created_by_module =
317: DECODE(x_created_by_module,
318: NULL, created_by_module,
319: FND_API.G_MISS_CHAR, NULL,
320: x_created_by_module),
321: application_id = hz_utility_v2pub.application_id,
322: attribute_category =
323: DECODE(x_attribute_category,

Line 325: FND_API.G_MISS_CHAR, NULL,

321: application_id = hz_utility_v2pub.application_id,
322: attribute_category =
323: DECODE(x_attribute_category,
324: NULL, attribute_category,
325: FND_API.G_MISS_CHAR, NULL,
326: x_attribute_category),
327: attribute1 =
328: DECODE(x_attribute1,
329: NULL, attribute1,

Line 330: FND_API.G_MISS_CHAR, NULL,

326: x_attribute_category),
327: attribute1 =
328: DECODE(x_attribute1,
329: NULL, attribute1,
330: FND_API.G_MISS_CHAR, NULL,
331: x_attribute1),
332: attribute2 =
333: DECODE(x_attribute2,
334: NULL, attribute2,

Line 335: FND_API.G_MISS_CHAR, NULL,

331: x_attribute1),
332: attribute2 =
333: DECODE(x_attribute2,
334: NULL, attribute2,
335: FND_API.G_MISS_CHAR, NULL,
336: x_attribute2),
337: attribute3 =
338: DECODE(x_attribute3,
339: NULL, attribute3,

Line 340: FND_API.G_MISS_CHAR, NULL,

336: x_attribute2),
337: attribute3 =
338: DECODE(x_attribute3,
339: NULL, attribute3,
340: FND_API.G_MISS_CHAR, NULL,
341: x_attribute3),
342: attribute4 =
343: DECODE(x_attribute4,
344: NULL, attribute4,

Line 345: FND_API.G_MISS_CHAR, NULL,

341: x_attribute3),
342: attribute4 =
343: DECODE(x_attribute4,
344: NULL, attribute4,
345: FND_API.G_MISS_CHAR, NULL,
346: x_attribute4),
347: attribute5 =
348: DECODE(x_attribute5,
349: NULL, attribute5,

Line 350: FND_API.G_MISS_CHAR, NULL,

346: x_attribute4),
347: attribute5 =
348: DECODE(x_attribute5,
349: NULL, attribute5,
350: FND_API.G_MISS_CHAR, NULL,
351: x_attribute5),
352: attribute6 =
353: DECODE(x_attribute6,
354: NULL, attribute6,

Line 355: FND_API.G_MISS_CHAR, NULL,

351: x_attribute5),
352: attribute6 =
353: DECODE(x_attribute6,
354: NULL, attribute6,
355: FND_API.G_MISS_CHAR, NULL,
356: x_attribute6),
357: attribute7 =
358: DECODE(x_attribute7,
359: NULL, attribute7,

Line 360: FND_API.G_MISS_CHAR, NULL,

356: x_attribute6),
357: attribute7 =
358: DECODE(x_attribute7,
359: NULL, attribute7,
360: FND_API.G_MISS_CHAR, NULL,
361: x_attribute7),
362: attribute8 =
363: DECODE(x_attribute8,
364: NULL, attribute8,

Line 365: FND_API.G_MISS_CHAR, NULL,

361: x_attribute7),
362: attribute8 =
363: DECODE(x_attribute8,
364: NULL, attribute8,
365: FND_API.G_MISS_CHAR, NULL,
366: x_attribute8),
367: attribute9 =
368: DECODE(x_attribute9,
369: NULL, attribute9,

Line 370: FND_API.G_MISS_CHAR, NULL,

366: x_attribute8),
367: attribute9 =
368: DECODE(x_attribute9,
369: NULL, attribute9,
370: FND_API.G_MISS_CHAR, NULL,
371: x_attribute9),
372: attribute10 =
373: DECODE(x_attribute10,
374: NULL, attribute10,

Line 375: FND_API.G_MISS_CHAR, NULL,

371: x_attribute9),
372: attribute10 =
373: DECODE(x_attribute10,
374: NULL, attribute10,
375: FND_API.G_MISS_CHAR, NULL,
376: x_attribute10),
377: attribute11 =
378: DECODE(x_attribute11,
379: NULL, attribute11,

Line 380: FND_API.G_MISS_CHAR, NULL,

376: x_attribute10),
377: attribute11 =
378: DECODE(x_attribute11,
379: NULL, attribute11,
380: FND_API.G_MISS_CHAR, NULL,
381: x_attribute11),
382: attribute12 =
383: DECODE(x_attribute12,
384: NULL, attribute12,

Line 385: FND_API.G_MISS_CHAR, NULL,

381: x_attribute11),
382: attribute12 =
383: DECODE(x_attribute12,
384: NULL, attribute12,
385: FND_API.G_MISS_CHAR, NULL,
386: x_attribute12),
387: attribute13 =
388: DECODE(x_attribute13,
389: NULL, attribute13,

Line 390: FND_API.G_MISS_CHAR, NULL,

386: x_attribute12),
387: attribute13 =
388: DECODE(x_attribute13,
389: NULL, attribute13,
390: FND_API.G_MISS_CHAR, NULL,
391: x_attribute13),
392: attribute14 =
393: DECODE(x_attribute14,
394: NULL, attribute14,

Line 395: FND_API.G_MISS_CHAR, NULL,

391: x_attribute13),
392: attribute14 =
393: DECODE(x_attribute14,
394: NULL, attribute14,
395: FND_API.G_MISS_CHAR, NULL,
396: x_attribute14),
397: attribute15 =
398: DECODE(x_attribute15,
399: NULL, attribute15,

Line 400: FND_API.G_MISS_CHAR, NULL,

396: x_attribute14),
397: attribute15 =
398: DECODE(x_attribute15,
399: NULL, attribute15,
400: FND_API.G_MISS_CHAR, NULL,
401: x_attribute15),
402: attribute16 =
403: DECODE(x_attribute16,
404: NULL, attribute16,

Line 405: FND_API.G_MISS_CHAR, NULL,

401: x_attribute15),
402: attribute16 =
403: DECODE(x_attribute16,
404: NULL, attribute16,
405: FND_API.G_MISS_CHAR, NULL,
406: x_attribute16),
407: attribute17 =
408: DECODE(x_attribute17,
409: NULL, attribute17,

Line 410: FND_API.G_MISS_CHAR, NULL,

406: x_attribute16),
407: attribute17 =
408: DECODE(x_attribute17,
409: NULL, attribute17,
410: FND_API.G_MISS_CHAR, NULL,
411: x_attribute17),
412: attribute18 =
413: DECODE(x_attribute18,
414: NULL, attribute18,

Line 415: FND_API.G_MISS_CHAR, NULL,

411: x_attribute17),
412: attribute18 =
413: DECODE(x_attribute18,
414: NULL, attribute18,
415: FND_API.G_MISS_CHAR, NULL,
416: x_attribute18),
417: attribute19 =
418: DECODE(x_attribute19,
419: NULL, attribute19,

Line 420: FND_API.G_MISS_CHAR, NULL,

416: x_attribute18),
417: attribute19 =
418: DECODE(x_attribute19,
419: NULL, attribute19,
420: FND_API.G_MISS_CHAR, NULL,
421: x_attribute19),
422: attribute20 =
423: DECODE(x_attribute20,
424: NULL, attribute20,

Line 425: FND_API.G_MISS_CHAR, NULL,

421: x_attribute19),
422: attribute20 =
423: DECODE(x_attribute20,
424: NULL, attribute20,
425: FND_API.G_MISS_CHAR, NULL,
426: x_attribute20)
427: WHERE ORIG_SYSTEM_REF_ID = X_ORIG_SYSTEM_REF_ID;
428:
429: IF ( SQL%NOTFOUND ) THEN

Line 669: NVL(orig_system_ref_id, FND_API.G_MISS_NUM),

665: ) IS
666: BEGIN
667:
668: SELECT
669: NVL(orig_system_ref_id, FND_API.G_MISS_NUM),
670: NVL(orig_system, FND_API.G_MISS_CHAR),
671: NVL(orig_system_reference, FND_API.G_MISS_CHAR),
672: NVL(owner_table_name, FND_API.G_MISS_CHAR),
673: NVL(owner_table_id, FND_API.G_MISS_NUM),

Line 670: NVL(orig_system, FND_API.G_MISS_CHAR),

666: BEGIN
667:
668: SELECT
669: NVL(orig_system_ref_id, FND_API.G_MISS_NUM),
670: NVL(orig_system, FND_API.G_MISS_CHAR),
671: NVL(orig_system_reference, FND_API.G_MISS_CHAR),
672: NVL(owner_table_name, FND_API.G_MISS_CHAR),
673: NVL(owner_table_id, FND_API.G_MISS_NUM),
674: --raji

Line 671: NVL(orig_system_reference, FND_API.G_MISS_CHAR),

667:
668: SELECT
669: NVL(orig_system_ref_id, FND_API.G_MISS_NUM),
670: NVL(orig_system, FND_API.G_MISS_CHAR),
671: NVL(orig_system_reference, FND_API.G_MISS_CHAR),
672: NVL(owner_table_name, FND_API.G_MISS_CHAR),
673: NVL(owner_table_id, FND_API.G_MISS_NUM),
674: --raji
675: NVL(party_id,FND_API.G_MISS_NUM),

Line 672: NVL(owner_table_name, FND_API.G_MISS_CHAR),

668: SELECT
669: NVL(orig_system_ref_id, FND_API.G_MISS_NUM),
670: NVL(orig_system, FND_API.G_MISS_CHAR),
671: NVL(orig_system_reference, FND_API.G_MISS_CHAR),
672: NVL(owner_table_name, FND_API.G_MISS_CHAR),
673: NVL(owner_table_id, FND_API.G_MISS_NUM),
674: --raji
675: NVL(party_id,FND_API.G_MISS_NUM),
676: NVL(status, FND_API.G_MISS_CHAR),

Line 673: NVL(owner_table_id, FND_API.G_MISS_NUM),

669: NVL(orig_system_ref_id, FND_API.G_MISS_NUM),
670: NVL(orig_system, FND_API.G_MISS_CHAR),
671: NVL(orig_system_reference, FND_API.G_MISS_CHAR),
672: NVL(owner_table_name, FND_API.G_MISS_CHAR),
673: NVL(owner_table_id, FND_API.G_MISS_NUM),
674: --raji
675: NVL(party_id,FND_API.G_MISS_NUM),
676: NVL(status, FND_API.G_MISS_CHAR),
677: NVL(reason_code, FND_API.G_MISS_CHAR),

Line 675: NVL(party_id,FND_API.G_MISS_NUM),

671: NVL(orig_system_reference, FND_API.G_MISS_CHAR),
672: NVL(owner_table_name, FND_API.G_MISS_CHAR),
673: NVL(owner_table_id, FND_API.G_MISS_NUM),
674: --raji
675: NVL(party_id,FND_API.G_MISS_NUM),
676: NVL(status, FND_API.G_MISS_CHAR),
677: NVL(reason_code, FND_API.G_MISS_CHAR),
678: NVL(old_orig_system_reference, FND_API.G_MISS_CHAR),
679: NVL(start_date_active, FND_API.G_MISS_DATE),

Line 676: NVL(status, FND_API.G_MISS_CHAR),

672: NVL(owner_table_name, FND_API.G_MISS_CHAR),
673: NVL(owner_table_id, FND_API.G_MISS_NUM),
674: --raji
675: NVL(party_id,FND_API.G_MISS_NUM),
676: NVL(status, FND_API.G_MISS_CHAR),
677: NVL(reason_code, FND_API.G_MISS_CHAR),
678: NVL(old_orig_system_reference, FND_API.G_MISS_CHAR),
679: NVL(start_date_active, FND_API.G_MISS_DATE),
680: NVL(end_date_active, FND_API.G_MISS_DATE),

Line 677: NVL(reason_code, FND_API.G_MISS_CHAR),

673: NVL(owner_table_id, FND_API.G_MISS_NUM),
674: --raji
675: NVL(party_id,FND_API.G_MISS_NUM),
676: NVL(status, FND_API.G_MISS_CHAR),
677: NVL(reason_code, FND_API.G_MISS_CHAR),
678: NVL(old_orig_system_reference, FND_API.G_MISS_CHAR),
679: NVL(start_date_active, FND_API.G_MISS_DATE),
680: NVL(end_date_active, FND_API.G_MISS_DATE),
681: NVL(created_by_module, FND_API.G_MISS_CHAR),

Line 678: NVL(old_orig_system_reference, FND_API.G_MISS_CHAR),

674: --raji
675: NVL(party_id,FND_API.G_MISS_NUM),
676: NVL(status, FND_API.G_MISS_CHAR),
677: NVL(reason_code, FND_API.G_MISS_CHAR),
678: NVL(old_orig_system_reference, FND_API.G_MISS_CHAR),
679: NVL(start_date_active, FND_API.G_MISS_DATE),
680: NVL(end_date_active, FND_API.G_MISS_DATE),
681: NVL(created_by_module, FND_API.G_MISS_CHAR),
682: NVL(application_id, FND_API.G_MISS_NUM),

Line 679: NVL(start_date_active, FND_API.G_MISS_DATE),

675: NVL(party_id,FND_API.G_MISS_NUM),
676: NVL(status, FND_API.G_MISS_CHAR),
677: NVL(reason_code, FND_API.G_MISS_CHAR),
678: NVL(old_orig_system_reference, FND_API.G_MISS_CHAR),
679: NVL(start_date_active, FND_API.G_MISS_DATE),
680: NVL(end_date_active, FND_API.G_MISS_DATE),
681: NVL(created_by_module, FND_API.G_MISS_CHAR),
682: NVL(application_id, FND_API.G_MISS_NUM),
683: NVL(attribute_category, FND_API.G_MISS_CHAR),

Line 680: NVL(end_date_active, FND_API.G_MISS_DATE),

676: NVL(status, FND_API.G_MISS_CHAR),
677: NVL(reason_code, FND_API.G_MISS_CHAR),
678: NVL(old_orig_system_reference, FND_API.G_MISS_CHAR),
679: NVL(start_date_active, FND_API.G_MISS_DATE),
680: NVL(end_date_active, FND_API.G_MISS_DATE),
681: NVL(created_by_module, FND_API.G_MISS_CHAR),
682: NVL(application_id, FND_API.G_MISS_NUM),
683: NVL(attribute_category, FND_API.G_MISS_CHAR),
684: NVL(attribute1, FND_API.G_MISS_CHAR),

Line 681: NVL(created_by_module, FND_API.G_MISS_CHAR),

677: NVL(reason_code, FND_API.G_MISS_CHAR),
678: NVL(old_orig_system_reference, FND_API.G_MISS_CHAR),
679: NVL(start_date_active, FND_API.G_MISS_DATE),
680: NVL(end_date_active, FND_API.G_MISS_DATE),
681: NVL(created_by_module, FND_API.G_MISS_CHAR),
682: NVL(application_id, FND_API.G_MISS_NUM),
683: NVL(attribute_category, FND_API.G_MISS_CHAR),
684: NVL(attribute1, FND_API.G_MISS_CHAR),
685: NVL(attribute2, FND_API.G_MISS_CHAR),

Line 682: NVL(application_id, FND_API.G_MISS_NUM),

678: NVL(old_orig_system_reference, FND_API.G_MISS_CHAR),
679: NVL(start_date_active, FND_API.G_MISS_DATE),
680: NVL(end_date_active, FND_API.G_MISS_DATE),
681: NVL(created_by_module, FND_API.G_MISS_CHAR),
682: NVL(application_id, FND_API.G_MISS_NUM),
683: NVL(attribute_category, FND_API.G_MISS_CHAR),
684: NVL(attribute1, FND_API.G_MISS_CHAR),
685: NVL(attribute2, FND_API.G_MISS_CHAR),
686: NVL(attribute3, FND_API.G_MISS_CHAR),

Line 683: NVL(attribute_category, FND_API.G_MISS_CHAR),

679: NVL(start_date_active, FND_API.G_MISS_DATE),
680: NVL(end_date_active, FND_API.G_MISS_DATE),
681: NVL(created_by_module, FND_API.G_MISS_CHAR),
682: NVL(application_id, FND_API.G_MISS_NUM),
683: NVL(attribute_category, FND_API.G_MISS_CHAR),
684: NVL(attribute1, FND_API.G_MISS_CHAR),
685: NVL(attribute2, FND_API.G_MISS_CHAR),
686: NVL(attribute3, FND_API.G_MISS_CHAR),
687: NVL(attribute4, FND_API.G_MISS_CHAR),

Line 684: NVL(attribute1, FND_API.G_MISS_CHAR),

680: NVL(end_date_active, FND_API.G_MISS_DATE),
681: NVL(created_by_module, FND_API.G_MISS_CHAR),
682: NVL(application_id, FND_API.G_MISS_NUM),
683: NVL(attribute_category, FND_API.G_MISS_CHAR),
684: NVL(attribute1, FND_API.G_MISS_CHAR),
685: NVL(attribute2, FND_API.G_MISS_CHAR),
686: NVL(attribute3, FND_API.G_MISS_CHAR),
687: NVL(attribute4, FND_API.G_MISS_CHAR),
688: NVL(attribute5, FND_API.G_MISS_CHAR),

Line 685: NVL(attribute2, FND_API.G_MISS_CHAR),

681: NVL(created_by_module, FND_API.G_MISS_CHAR),
682: NVL(application_id, FND_API.G_MISS_NUM),
683: NVL(attribute_category, FND_API.G_MISS_CHAR),
684: NVL(attribute1, FND_API.G_MISS_CHAR),
685: NVL(attribute2, FND_API.G_MISS_CHAR),
686: NVL(attribute3, FND_API.G_MISS_CHAR),
687: NVL(attribute4, FND_API.G_MISS_CHAR),
688: NVL(attribute5, FND_API.G_MISS_CHAR),
689: NVL(attribute6, FND_API.G_MISS_CHAR),

Line 686: NVL(attribute3, FND_API.G_MISS_CHAR),

682: NVL(application_id, FND_API.G_MISS_NUM),
683: NVL(attribute_category, FND_API.G_MISS_CHAR),
684: NVL(attribute1, FND_API.G_MISS_CHAR),
685: NVL(attribute2, FND_API.G_MISS_CHAR),
686: NVL(attribute3, FND_API.G_MISS_CHAR),
687: NVL(attribute4, FND_API.G_MISS_CHAR),
688: NVL(attribute5, FND_API.G_MISS_CHAR),
689: NVL(attribute6, FND_API.G_MISS_CHAR),
690: NVL(attribute7, FND_API.G_MISS_CHAR),

Line 687: NVL(attribute4, FND_API.G_MISS_CHAR),

683: NVL(attribute_category, FND_API.G_MISS_CHAR),
684: NVL(attribute1, FND_API.G_MISS_CHAR),
685: NVL(attribute2, FND_API.G_MISS_CHAR),
686: NVL(attribute3, FND_API.G_MISS_CHAR),
687: NVL(attribute4, FND_API.G_MISS_CHAR),
688: NVL(attribute5, FND_API.G_MISS_CHAR),
689: NVL(attribute6, FND_API.G_MISS_CHAR),
690: NVL(attribute7, FND_API.G_MISS_CHAR),
691: NVL(attribute8, FND_API.G_MISS_CHAR),

Line 688: NVL(attribute5, FND_API.G_MISS_CHAR),

684: NVL(attribute1, FND_API.G_MISS_CHAR),
685: NVL(attribute2, FND_API.G_MISS_CHAR),
686: NVL(attribute3, FND_API.G_MISS_CHAR),
687: NVL(attribute4, FND_API.G_MISS_CHAR),
688: NVL(attribute5, FND_API.G_MISS_CHAR),
689: NVL(attribute6, FND_API.G_MISS_CHAR),
690: NVL(attribute7, FND_API.G_MISS_CHAR),
691: NVL(attribute8, FND_API.G_MISS_CHAR),
692: NVL(attribute9, FND_API.G_MISS_CHAR),

Line 689: NVL(attribute6, FND_API.G_MISS_CHAR),

685: NVL(attribute2, FND_API.G_MISS_CHAR),
686: NVL(attribute3, FND_API.G_MISS_CHAR),
687: NVL(attribute4, FND_API.G_MISS_CHAR),
688: NVL(attribute5, FND_API.G_MISS_CHAR),
689: NVL(attribute6, FND_API.G_MISS_CHAR),
690: NVL(attribute7, FND_API.G_MISS_CHAR),
691: NVL(attribute8, FND_API.G_MISS_CHAR),
692: NVL(attribute9, FND_API.G_MISS_CHAR),
693: NVL(attribute10, FND_API.G_MISS_CHAR),

Line 690: NVL(attribute7, FND_API.G_MISS_CHAR),

686: NVL(attribute3, FND_API.G_MISS_CHAR),
687: NVL(attribute4, FND_API.G_MISS_CHAR),
688: NVL(attribute5, FND_API.G_MISS_CHAR),
689: NVL(attribute6, FND_API.G_MISS_CHAR),
690: NVL(attribute7, FND_API.G_MISS_CHAR),
691: NVL(attribute8, FND_API.G_MISS_CHAR),
692: NVL(attribute9, FND_API.G_MISS_CHAR),
693: NVL(attribute10, FND_API.G_MISS_CHAR),
694: NVL(attribute11, FND_API.G_MISS_CHAR),

Line 691: NVL(attribute8, FND_API.G_MISS_CHAR),

687: NVL(attribute4, FND_API.G_MISS_CHAR),
688: NVL(attribute5, FND_API.G_MISS_CHAR),
689: NVL(attribute6, FND_API.G_MISS_CHAR),
690: NVL(attribute7, FND_API.G_MISS_CHAR),
691: NVL(attribute8, FND_API.G_MISS_CHAR),
692: NVL(attribute9, FND_API.G_MISS_CHAR),
693: NVL(attribute10, FND_API.G_MISS_CHAR),
694: NVL(attribute11, FND_API.G_MISS_CHAR),
695: NVL(attribute12, FND_API.G_MISS_CHAR),

Line 692: NVL(attribute9, FND_API.G_MISS_CHAR),

688: NVL(attribute5, FND_API.G_MISS_CHAR),
689: NVL(attribute6, FND_API.G_MISS_CHAR),
690: NVL(attribute7, FND_API.G_MISS_CHAR),
691: NVL(attribute8, FND_API.G_MISS_CHAR),
692: NVL(attribute9, FND_API.G_MISS_CHAR),
693: NVL(attribute10, FND_API.G_MISS_CHAR),
694: NVL(attribute11, FND_API.G_MISS_CHAR),
695: NVL(attribute12, FND_API.G_MISS_CHAR),
696: NVL(attribute13, FND_API.G_MISS_CHAR),

Line 693: NVL(attribute10, FND_API.G_MISS_CHAR),

689: NVL(attribute6, FND_API.G_MISS_CHAR),
690: NVL(attribute7, FND_API.G_MISS_CHAR),
691: NVL(attribute8, FND_API.G_MISS_CHAR),
692: NVL(attribute9, FND_API.G_MISS_CHAR),
693: NVL(attribute10, FND_API.G_MISS_CHAR),
694: NVL(attribute11, FND_API.G_MISS_CHAR),
695: NVL(attribute12, FND_API.G_MISS_CHAR),
696: NVL(attribute13, FND_API.G_MISS_CHAR),
697: NVL(attribute14, FND_API.G_MISS_CHAR),

Line 694: NVL(attribute11, FND_API.G_MISS_CHAR),

690: NVL(attribute7, FND_API.G_MISS_CHAR),
691: NVL(attribute8, FND_API.G_MISS_CHAR),
692: NVL(attribute9, FND_API.G_MISS_CHAR),
693: NVL(attribute10, FND_API.G_MISS_CHAR),
694: NVL(attribute11, FND_API.G_MISS_CHAR),
695: NVL(attribute12, FND_API.G_MISS_CHAR),
696: NVL(attribute13, FND_API.G_MISS_CHAR),
697: NVL(attribute14, FND_API.G_MISS_CHAR),
698: NVL(attribute15, FND_API.G_MISS_CHAR),

Line 695: NVL(attribute12, FND_API.G_MISS_CHAR),

691: NVL(attribute8, FND_API.G_MISS_CHAR),
692: NVL(attribute9, FND_API.G_MISS_CHAR),
693: NVL(attribute10, FND_API.G_MISS_CHAR),
694: NVL(attribute11, FND_API.G_MISS_CHAR),
695: NVL(attribute12, FND_API.G_MISS_CHAR),
696: NVL(attribute13, FND_API.G_MISS_CHAR),
697: NVL(attribute14, FND_API.G_MISS_CHAR),
698: NVL(attribute15, FND_API.G_MISS_CHAR),
699: NVL(attribute16, FND_API.G_MISS_CHAR),

Line 696: NVL(attribute13, FND_API.G_MISS_CHAR),

692: NVL(attribute9, FND_API.G_MISS_CHAR),
693: NVL(attribute10, FND_API.G_MISS_CHAR),
694: NVL(attribute11, FND_API.G_MISS_CHAR),
695: NVL(attribute12, FND_API.G_MISS_CHAR),
696: NVL(attribute13, FND_API.G_MISS_CHAR),
697: NVL(attribute14, FND_API.G_MISS_CHAR),
698: NVL(attribute15, FND_API.G_MISS_CHAR),
699: NVL(attribute16, FND_API.G_MISS_CHAR),
700: NVL(attribute17, FND_API.G_MISS_CHAR),

Line 697: NVL(attribute14, FND_API.G_MISS_CHAR),

693: NVL(attribute10, FND_API.G_MISS_CHAR),
694: NVL(attribute11, FND_API.G_MISS_CHAR),
695: NVL(attribute12, FND_API.G_MISS_CHAR),
696: NVL(attribute13, FND_API.G_MISS_CHAR),
697: NVL(attribute14, FND_API.G_MISS_CHAR),
698: NVL(attribute15, FND_API.G_MISS_CHAR),
699: NVL(attribute16, FND_API.G_MISS_CHAR),
700: NVL(attribute17, FND_API.G_MISS_CHAR),
701: NVL(attribute18, FND_API.G_MISS_CHAR),

Line 698: NVL(attribute15, FND_API.G_MISS_CHAR),

694: NVL(attribute11, FND_API.G_MISS_CHAR),
695: NVL(attribute12, FND_API.G_MISS_CHAR),
696: NVL(attribute13, FND_API.G_MISS_CHAR),
697: NVL(attribute14, FND_API.G_MISS_CHAR),
698: NVL(attribute15, FND_API.G_MISS_CHAR),
699: NVL(attribute16, FND_API.G_MISS_CHAR),
700: NVL(attribute17, FND_API.G_MISS_CHAR),
701: NVL(attribute18, FND_API.G_MISS_CHAR),
702: NVL(attribute19, FND_API.G_MISS_CHAR),

Line 699: NVL(attribute16, FND_API.G_MISS_CHAR),

695: NVL(attribute12, FND_API.G_MISS_CHAR),
696: NVL(attribute13, FND_API.G_MISS_CHAR),
697: NVL(attribute14, FND_API.G_MISS_CHAR),
698: NVL(attribute15, FND_API.G_MISS_CHAR),
699: NVL(attribute16, FND_API.G_MISS_CHAR),
700: NVL(attribute17, FND_API.G_MISS_CHAR),
701: NVL(attribute18, FND_API.G_MISS_CHAR),
702: NVL(attribute19, FND_API.G_MISS_CHAR),
703: NVL(attribute20, FND_API.G_MISS_CHAR)

Line 700: NVL(attribute17, FND_API.G_MISS_CHAR),

696: NVL(attribute13, FND_API.G_MISS_CHAR),
697: NVL(attribute14, FND_API.G_MISS_CHAR),
698: NVL(attribute15, FND_API.G_MISS_CHAR),
699: NVL(attribute16, FND_API.G_MISS_CHAR),
700: NVL(attribute17, FND_API.G_MISS_CHAR),
701: NVL(attribute18, FND_API.G_MISS_CHAR),
702: NVL(attribute19, FND_API.G_MISS_CHAR),
703: NVL(attribute20, FND_API.G_MISS_CHAR)
704: INTO

Line 701: NVL(attribute18, FND_API.G_MISS_CHAR),

697: NVL(attribute14, FND_API.G_MISS_CHAR),
698: NVL(attribute15, FND_API.G_MISS_CHAR),
699: NVL(attribute16, FND_API.G_MISS_CHAR),
700: NVL(attribute17, FND_API.G_MISS_CHAR),
701: NVL(attribute18, FND_API.G_MISS_CHAR),
702: NVL(attribute19, FND_API.G_MISS_CHAR),
703: NVL(attribute20, FND_API.G_MISS_CHAR)
704: INTO
705: x_orig_system_ref_id,

Line 702: NVL(attribute19, FND_API.G_MISS_CHAR),

698: NVL(attribute15, FND_API.G_MISS_CHAR),
699: NVL(attribute16, FND_API.G_MISS_CHAR),
700: NVL(attribute17, FND_API.G_MISS_CHAR),
701: NVL(attribute18, FND_API.G_MISS_CHAR),
702: NVL(attribute19, FND_API.G_MISS_CHAR),
703: NVL(attribute20, FND_API.G_MISS_CHAR)
704: INTO
705: x_orig_system_ref_id,
706: x_orig_system,

Line 703: NVL(attribute20, FND_API.G_MISS_CHAR)

699: NVL(attribute16, FND_API.G_MISS_CHAR),
700: NVL(attribute17, FND_API.G_MISS_CHAR),
701: NVL(attribute18, FND_API.G_MISS_CHAR),
702: NVL(attribute19, FND_API.G_MISS_CHAR),
703: NVL(attribute20, FND_API.G_MISS_CHAR)
704: INTO
705: x_orig_system_ref_id,
706: x_orig_system,
707: x_orig_system_reference,

Line 749: RAISE FND_API.G_EXC_ERROR;

745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
746: FND_MESSAGE.SET_TOKEN('RECORD', 'orig_sys_reference_rec');
747: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_orig_system_ref_id));
748: FND_MSG_PUB.ADD;
749: RAISE FND_API.G_EXC_ERROR;
750:
751: END Select_Row;
752:
753: PROCEDURE Delete_Row (