5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
224: , x_msg_count out nocopy NUMBER
225: , x_msg_data out nocopy VARCHAR2
226: , x_entity_attr_id out nocopy NUMBER
227: , p7_a0 NUMBER := 0-1962.0724
228: , p7_a1 DATE := fnd_api.g_miss_date
229: , p7_a2 NUMBER := 0-1962.0724
230: , p7_a3 DATE := fnd_api.g_miss_date
231: , p7_a4 NUMBER := 0-1962.0724
232: , p7_a5 NUMBER := 0-1962.0724
226: , x_entity_attr_id out nocopy NUMBER
227: , p7_a0 NUMBER := 0-1962.0724
228: , p7_a1 DATE := fnd_api.g_miss_date
229: , p7_a2 NUMBER := 0-1962.0724
230: , p7_a3 DATE := fnd_api.g_miss_date
231: , p7_a4 NUMBER := 0-1962.0724
232: , p7_a5 NUMBER := 0-1962.0724
233: , p7_a6 NUMBER := 0-1962.0724
234: , p7_a7 NUMBER := 0-1962.0724
231: , p7_a4 NUMBER := 0-1962.0724
232: , p7_a5 NUMBER := 0-1962.0724
233: , p7_a6 NUMBER := 0-1962.0724
234: , p7_a7 NUMBER := 0-1962.0724
235: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a5 NUMBER := 0-1962.0724
233: , p7_a6 NUMBER := 0-1962.0724
234: , p7_a7 NUMBER := 0-1962.0724
235: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a6 NUMBER := 0-1962.0724
234: , p7_a7 NUMBER := 0-1962.0724
235: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a7 NUMBER := 0-1962.0724
235: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
242: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
242: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
243: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
242: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
243: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
244: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
242: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
243: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
244: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
245: , p7_a18 NUMBER := 0-1962.0724
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
242: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
243: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
244: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
245: , p7_a18 NUMBER := 0-1962.0724
246: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
242: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
243: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
244: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
245: , p7_a18 NUMBER := 0-1962.0724
246: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
242: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
243: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
244: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
245: , p7_a18 NUMBER := 0-1962.0724
246: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a21 DATE := fnd_api.g_miss_date
242: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
243: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
244: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
245: , p7_a18 NUMBER := 0-1962.0724
246: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a21 DATE := fnd_api.g_miss_date
249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
250: )
243: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
244: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
245: , p7_a18 NUMBER := 0-1962.0724
246: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a21 DATE := fnd_api.g_miss_date
249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
250: )
251:
244: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
245: , p7_a18 NUMBER := 0-1962.0724
246: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a21 DATE := fnd_api.g_miss_date
249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
250: )
251:
252: as
245: , p7_a18 NUMBER := 0-1962.0724
246: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a21 DATE := fnd_api.g_miss_date
249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
250: )
251:
252: as
253: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;
317: , x_msg_count out nocopy NUMBER
318: , x_msg_data out nocopy VARCHAR2
319: , x_object_version_number out nocopy NUMBER
320: , p7_a0 NUMBER := 0-1962.0724
321: , p7_a1 DATE := fnd_api.g_miss_date
322: , p7_a2 NUMBER := 0-1962.0724
323: , p7_a3 DATE := fnd_api.g_miss_date
324: , p7_a4 NUMBER := 0-1962.0724
325: , p7_a5 NUMBER := 0-1962.0724
319: , x_object_version_number out nocopy NUMBER
320: , p7_a0 NUMBER := 0-1962.0724
321: , p7_a1 DATE := fnd_api.g_miss_date
322: , p7_a2 NUMBER := 0-1962.0724
323: , p7_a3 DATE := fnd_api.g_miss_date
324: , p7_a4 NUMBER := 0-1962.0724
325: , p7_a5 NUMBER := 0-1962.0724
326: , p7_a6 NUMBER := 0-1962.0724
327: , p7_a7 NUMBER := 0-1962.0724
324: , p7_a4 NUMBER := 0-1962.0724
325: , p7_a5 NUMBER := 0-1962.0724
326: , p7_a6 NUMBER := 0-1962.0724
327: , p7_a7 NUMBER := 0-1962.0724
328: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
330: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a5 NUMBER := 0-1962.0724
326: , p7_a6 NUMBER := 0-1962.0724
327: , p7_a7 NUMBER := 0-1962.0724
328: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
330: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a6 NUMBER := 0-1962.0724
327: , p7_a7 NUMBER := 0-1962.0724
328: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
330: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a7 NUMBER := 0-1962.0724
328: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
330: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
330: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
330: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
330: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a18 NUMBER := 0-1962.0724
331: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a18 NUMBER := 0-1962.0724
339: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
332: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a18 NUMBER := 0-1962.0724
339: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
334: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
335: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a18 NUMBER := 0-1962.0724
339: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a21 DATE := fnd_api.g_miss_date
335: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
336: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a18 NUMBER := 0-1962.0724
339: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a21 DATE := fnd_api.g_miss_date
342: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
343: )
336: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
337: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a18 NUMBER := 0-1962.0724
339: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a21 DATE := fnd_api.g_miss_date
342: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
343: )
344:
337: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
338: , p7_a18 NUMBER := 0-1962.0724
339: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a21 DATE := fnd_api.g_miss_date
342: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
343: )
344:
345: as
338: , p7_a18 NUMBER := 0-1962.0724
339: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a21 DATE := fnd_api.g_miss_date
342: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
343: )
344:
345: as
346: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;
409: , x_return_status out nocopy VARCHAR2
410: , x_msg_count out nocopy NUMBER
411: , x_msg_data out nocopy VARCHAR2
412: , p4_a0 NUMBER := 0-1962.0724
413: , p4_a1 DATE := fnd_api.g_miss_date
414: , p4_a2 NUMBER := 0-1962.0724
415: , p4_a3 DATE := fnd_api.g_miss_date
416: , p4_a4 NUMBER := 0-1962.0724
417: , p4_a5 NUMBER := 0-1962.0724
411: , x_msg_data out nocopy VARCHAR2
412: , p4_a0 NUMBER := 0-1962.0724
413: , p4_a1 DATE := fnd_api.g_miss_date
414: , p4_a2 NUMBER := 0-1962.0724
415: , p4_a3 DATE := fnd_api.g_miss_date
416: , p4_a4 NUMBER := 0-1962.0724
417: , p4_a5 NUMBER := 0-1962.0724
418: , p4_a6 NUMBER := 0-1962.0724
419: , p4_a7 NUMBER := 0-1962.0724
416: , p4_a4 NUMBER := 0-1962.0724
417: , p4_a5 NUMBER := 0-1962.0724
418: , p4_a6 NUMBER := 0-1962.0724
419: , p4_a7 NUMBER := 0-1962.0724
420: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
423: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
424: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
417: , p4_a5 NUMBER := 0-1962.0724
418: , p4_a6 NUMBER := 0-1962.0724
419: , p4_a7 NUMBER := 0-1962.0724
420: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
423: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
424: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
425: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
418: , p4_a6 NUMBER := 0-1962.0724
419: , p4_a7 NUMBER := 0-1962.0724
420: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
423: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
424: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
425: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
426: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
419: , p4_a7 NUMBER := 0-1962.0724
420: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
423: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
424: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
425: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
426: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
427: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
420: , p4_a8 VARCHAR2 := fnd_api.g_miss_char
421: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
423: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
424: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
425: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
426: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
427: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
428: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
421: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
422: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
423: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
424: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
425: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
426: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
427: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
428: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
429: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
422: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
423: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
424: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
425: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
426: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
427: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
428: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
429: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
430: , p4_a18 NUMBER := 0-1962.0724
423: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
424: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
425: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
426: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
427: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
428: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
429: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
430: , p4_a18 NUMBER := 0-1962.0724
431: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
424: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
425: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
426: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
427: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
428: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
429: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
430: , p4_a18 NUMBER := 0-1962.0724
431: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
432: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
425: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
426: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
427: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
428: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
429: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
430: , p4_a18 NUMBER := 0-1962.0724
431: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
432: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
433: , p4_a21 DATE := fnd_api.g_miss_date
427: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
428: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
429: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
430: , p4_a18 NUMBER := 0-1962.0724
431: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
432: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
433: , p4_a21 DATE := fnd_api.g_miss_date
434: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
435: )
428: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
429: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
430: , p4_a18 NUMBER := 0-1962.0724
431: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
432: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
433: , p4_a21 DATE := fnd_api.g_miss_date
434: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
435: )
436:
429: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
430: , p4_a18 NUMBER := 0-1962.0724
431: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
432: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
433: , p4_a21 DATE := fnd_api.g_miss_date
434: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
435: )
436:
437: as
430: , p4_a18 NUMBER := 0-1962.0724
431: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
432: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
433: , p4_a21 DATE := fnd_api.g_miss_date
434: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
435: )
436:
437: as
438: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;
493:
494: procedure check_entity_attr_items(p_validation_mode VARCHAR2
495: , x_return_status out nocopy VARCHAR2
496: , p0_a0 NUMBER := 0-1962.0724
497: , p0_a1 DATE := fnd_api.g_miss_date
498: , p0_a2 NUMBER := 0-1962.0724
499: , p0_a3 DATE := fnd_api.g_miss_date
500: , p0_a4 NUMBER := 0-1962.0724
501: , p0_a5 NUMBER := 0-1962.0724
495: , x_return_status out nocopy VARCHAR2
496: , p0_a0 NUMBER := 0-1962.0724
497: , p0_a1 DATE := fnd_api.g_miss_date
498: , p0_a2 NUMBER := 0-1962.0724
499: , p0_a3 DATE := fnd_api.g_miss_date
500: , p0_a4 NUMBER := 0-1962.0724
501: , p0_a5 NUMBER := 0-1962.0724
502: , p0_a6 NUMBER := 0-1962.0724
503: , p0_a7 NUMBER := 0-1962.0724
500: , p0_a4 NUMBER := 0-1962.0724
501: , p0_a5 NUMBER := 0-1962.0724
502: , p0_a6 NUMBER := 0-1962.0724
503: , p0_a7 NUMBER := 0-1962.0724
504: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
505: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
507: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
508: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
501: , p0_a5 NUMBER := 0-1962.0724
502: , p0_a6 NUMBER := 0-1962.0724
503: , p0_a7 NUMBER := 0-1962.0724
504: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
505: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
507: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
508: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
502: , p0_a6 NUMBER := 0-1962.0724
503: , p0_a7 NUMBER := 0-1962.0724
504: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
505: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
507: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
508: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
503: , p0_a7 NUMBER := 0-1962.0724
504: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
505: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
507: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
508: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
511: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
504: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
505: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
507: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
508: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
511: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
512: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
505: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
507: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
508: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
511: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
512: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
507: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
508: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
511: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
512: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a18 NUMBER := 0-1962.0724
507: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
508: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
511: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
512: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a18 NUMBER := 0-1962.0724
515: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
508: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
511: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
512: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a18 NUMBER := 0-1962.0724
515: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
516: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
509: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
511: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
512: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a18 NUMBER := 0-1962.0724
515: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
516: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
517: , p0_a21 DATE := fnd_api.g_miss_date
511: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
512: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a18 NUMBER := 0-1962.0724
515: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
516: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
517: , p0_a21 DATE := fnd_api.g_miss_date
518: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
519: )
512: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a18 NUMBER := 0-1962.0724
515: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
516: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
517: , p0_a21 DATE := fnd_api.g_miss_date
518: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
519: )
520:
513: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a18 NUMBER := 0-1962.0724
515: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
516: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
517: , p0_a21 DATE := fnd_api.g_miss_date
518: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
519: )
520:
521: as
514: , p0_a18 NUMBER := 0-1962.0724
515: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
516: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
517: , p0_a21 DATE := fnd_api.g_miss_date
518: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
519: )
520:
521: as
522: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;
566: , x_msg_count out nocopy NUMBER
567: , x_msg_data out nocopy VARCHAR2
568: , p_validation_mode VARCHAR2
569: , p5_a0 NUMBER := 0-1962.0724
570: , p5_a1 DATE := fnd_api.g_miss_date
571: , p5_a2 NUMBER := 0-1962.0724
572: , p5_a3 DATE := fnd_api.g_miss_date
573: , p5_a4 NUMBER := 0-1962.0724
574: , p5_a5 NUMBER := 0-1962.0724
568: , p_validation_mode VARCHAR2
569: , p5_a0 NUMBER := 0-1962.0724
570: , p5_a1 DATE := fnd_api.g_miss_date
571: , p5_a2 NUMBER := 0-1962.0724
572: , p5_a3 DATE := fnd_api.g_miss_date
573: , p5_a4 NUMBER := 0-1962.0724
574: , p5_a5 NUMBER := 0-1962.0724
575: , p5_a6 NUMBER := 0-1962.0724
576: , p5_a7 NUMBER := 0-1962.0724
573: , p5_a4 NUMBER := 0-1962.0724
574: , p5_a5 NUMBER := 0-1962.0724
575: , p5_a6 NUMBER := 0-1962.0724
576: , p5_a7 NUMBER := 0-1962.0724
577: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a5 NUMBER := 0-1962.0724
575: , p5_a6 NUMBER := 0-1962.0724
576: , p5_a7 NUMBER := 0-1962.0724
577: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a6 NUMBER := 0-1962.0724
576: , p5_a7 NUMBER := 0-1962.0724
577: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a7 NUMBER := 0-1962.0724
577: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a18 NUMBER := 0-1962.0724
580: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a18 NUMBER := 0-1962.0724
588: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a18 NUMBER := 0-1962.0724
588: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a18 NUMBER := 0-1962.0724
588: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a21 DATE := fnd_api.g_miss_date
584: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a18 NUMBER := 0-1962.0724
588: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a21 DATE := fnd_api.g_miss_date
591: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
592: )
585: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a18 NUMBER := 0-1962.0724
588: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a21 DATE := fnd_api.g_miss_date
591: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
592: )
593:
586: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a18 NUMBER := 0-1962.0724
588: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a21 DATE := fnd_api.g_miss_date
591: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
592: )
593:
594: as
587: , p5_a18 NUMBER := 0-1962.0724
588: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a21 DATE := fnd_api.g_miss_date
591: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
592: )
593:
594: as
595: ddp_entity_attr_rec pv_entity_attribute_pvt.entity_attr_rec_type;