3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;
14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_strats_pvt.ps_strats_tbl_type, a0 JTF_NUMBER_TABLE
161: , x_msg_count OUT NOCOPY NUMBER
162: , x_msg_data OUT NOCOPY VARCHAR2
163: , x_strategy_id OUT NOCOPY NUMBER
164: , p7_a0 NUMBER := 0-1962.0724
165: , p7_a1 DATE := fnd_api.g_miss_date
166: , p7_a2 NUMBER := 0-1962.0724
167: , p7_a3 DATE := fnd_api.g_miss_date
168: , p7_a4 NUMBER := 0-1962.0724
169: , p7_a5 NUMBER := 0-1962.0724
163: , x_strategy_id OUT NOCOPY NUMBER
164: , p7_a0 NUMBER := 0-1962.0724
165: , p7_a1 DATE := fnd_api.g_miss_date
166: , p7_a2 NUMBER := 0-1962.0724
167: , p7_a3 DATE := fnd_api.g_miss_date
168: , p7_a4 NUMBER := 0-1962.0724
169: , p7_a5 NUMBER := 0-1962.0724
170: , p7_a6 NUMBER := 0-1962.0724
171: , p7_a7 NUMBER := 0-1962.0724
168: , p7_a4 NUMBER := 0-1962.0724
169: , p7_a5 NUMBER := 0-1962.0724
170: , p7_a6 NUMBER := 0-1962.0724
171: , p7_a7 NUMBER := 0-1962.0724
172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a5 NUMBER := 0-1962.0724
170: , p7_a6 NUMBER := 0-1962.0724
171: , p7_a7 NUMBER := 0-1962.0724
172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a6 NUMBER := 0-1962.0724
171: , p7_a7 NUMBER := 0-1962.0724
172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
178: )
171: , p7_a7 NUMBER := 0-1962.0724
172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
178: )
179: as
172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
178: )
179: as
180: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
173: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
178: )
179: as
180: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
181: ddindx binary_integer; indx binary_integer;
235: , x_msg_count OUT NOCOPY NUMBER
236: , x_msg_data OUT NOCOPY VARCHAR2
237: , x_object_version_number OUT NOCOPY NUMBER
238: , p7_a0 NUMBER := 0-1962.0724
239: , p7_a1 DATE := fnd_api.g_miss_date
240: , p7_a2 NUMBER := 0-1962.0724
241: , p7_a3 DATE := fnd_api.g_miss_date
242: , p7_a4 NUMBER := 0-1962.0724
243: , p7_a5 NUMBER := 0-1962.0724
237: , x_object_version_number OUT NOCOPY NUMBER
238: , p7_a0 NUMBER := 0-1962.0724
239: , p7_a1 DATE := fnd_api.g_miss_date
240: , p7_a2 NUMBER := 0-1962.0724
241: , p7_a3 DATE := fnd_api.g_miss_date
242: , p7_a4 NUMBER := 0-1962.0724
243: , p7_a5 NUMBER := 0-1962.0724
244: , p7_a6 NUMBER := 0-1962.0724
245: , p7_a7 NUMBER := 0-1962.0724
242: , p7_a4 NUMBER := 0-1962.0724
243: , p7_a5 NUMBER := 0-1962.0724
244: , p7_a6 NUMBER := 0-1962.0724
245: , p7_a7 NUMBER := 0-1962.0724
246: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
243: , p7_a5 NUMBER := 0-1962.0724
244: , p7_a6 NUMBER := 0-1962.0724
245: , p7_a7 NUMBER := 0-1962.0724
246: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
244: , p7_a6 NUMBER := 0-1962.0724
245: , p7_a7 NUMBER := 0-1962.0724
246: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
252: )
245: , p7_a7 NUMBER := 0-1962.0724
246: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
252: )
253: as
246: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
247: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
252: )
253: as
254: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
247: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
250: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
252: )
253: as
254: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
255: ddindx binary_integer; indx binary_integer;
310: , x_msg_data OUT NOCOPY VARCHAR2
311: , x_object_version_number OUT NOCOPY NUMBER
312: , p_strat_type VARCHAR2
313: , p7_a0 NUMBER := 0-1962.0724
314: , p7_a1 DATE := fnd_api.g_miss_date
315: , p7_a2 NUMBER := 0-1962.0724
316: , p7_a3 DATE := fnd_api.g_miss_date
317: , p7_a4 NUMBER := 0-1962.0724
318: , p7_a5 NUMBER := 0-1962.0724
312: , p_strat_type VARCHAR2
313: , p7_a0 NUMBER := 0-1962.0724
314: , p7_a1 DATE := fnd_api.g_miss_date
315: , p7_a2 NUMBER := 0-1962.0724
316: , p7_a3 DATE := fnd_api.g_miss_date
317: , p7_a4 NUMBER := 0-1962.0724
318: , p7_a5 NUMBER := 0-1962.0724
319: , p7_a6 NUMBER := 0-1962.0724
320: , p7_a7 NUMBER := 0-1962.0724
317: , p7_a4 NUMBER := 0-1962.0724
318: , p7_a5 NUMBER := 0-1962.0724
319: , p7_a6 NUMBER := 0-1962.0724
320: , p7_a7 NUMBER := 0-1962.0724
321: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a5 NUMBER := 0-1962.0724
319: , p7_a6 NUMBER := 0-1962.0724
320: , p7_a7 NUMBER := 0-1962.0724
321: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a6 NUMBER := 0-1962.0724
320: , p7_a7 NUMBER := 0-1962.0724
321: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
327: )
320: , p7_a7 NUMBER := 0-1962.0724
321: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
327: )
328: as
321: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
327: )
328: as
329: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
322: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
327: )
328: as
329: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
330: ddindx binary_integer; indx binary_integer;
385: , x_return_status OUT NOCOPY VARCHAR2
386: , x_msg_count OUT NOCOPY NUMBER
387: , x_msg_data OUT NOCOPY VARCHAR2
388: , p3_a0 NUMBER := 0-1962.0724
389: , p3_a1 DATE := fnd_api.g_miss_date
390: , p3_a2 NUMBER := 0-1962.0724
391: , p3_a3 DATE := fnd_api.g_miss_date
392: , p3_a4 NUMBER := 0-1962.0724
393: , p3_a5 NUMBER := 0-1962.0724
387: , x_msg_data OUT NOCOPY VARCHAR2
388: , p3_a0 NUMBER := 0-1962.0724
389: , p3_a1 DATE := fnd_api.g_miss_date
390: , p3_a2 NUMBER := 0-1962.0724
391: , p3_a3 DATE := fnd_api.g_miss_date
392: , p3_a4 NUMBER := 0-1962.0724
393: , p3_a5 NUMBER := 0-1962.0724
394: , p3_a6 NUMBER := 0-1962.0724
395: , p3_a7 NUMBER := 0-1962.0724
392: , p3_a4 NUMBER := 0-1962.0724
393: , p3_a5 NUMBER := 0-1962.0724
394: , p3_a6 NUMBER := 0-1962.0724
395: , p3_a7 NUMBER := 0-1962.0724
396: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
393: , p3_a5 NUMBER := 0-1962.0724
394: , p3_a6 NUMBER := 0-1962.0724
395: , p3_a7 NUMBER := 0-1962.0724
396: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
394: , p3_a6 NUMBER := 0-1962.0724
395: , p3_a7 NUMBER := 0-1962.0724
396: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
402: )
395: , p3_a7 NUMBER := 0-1962.0724
396: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
402: )
403: as
396: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
397: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
402: )
403: as
404: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
397: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
398: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
399: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
400: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
401: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
402: )
403: as
404: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
405: ddindx binary_integer; indx binary_integer;
447:
448: procedure check_ps_strats_items(p_validation_mode VARCHAR2
449: , x_return_status OUT NOCOPY VARCHAR2
450: , p0_a0 NUMBER := 0-1962.0724
451: , p0_a1 DATE := fnd_api.g_miss_date
452: , p0_a2 NUMBER := 0-1962.0724
453: , p0_a3 DATE := fnd_api.g_miss_date
454: , p0_a4 NUMBER := 0-1962.0724
455: , p0_a5 NUMBER := 0-1962.0724
449: , x_return_status OUT NOCOPY VARCHAR2
450: , p0_a0 NUMBER := 0-1962.0724
451: , p0_a1 DATE := fnd_api.g_miss_date
452: , p0_a2 NUMBER := 0-1962.0724
453: , p0_a3 DATE := fnd_api.g_miss_date
454: , p0_a4 NUMBER := 0-1962.0724
455: , p0_a5 NUMBER := 0-1962.0724
456: , p0_a6 NUMBER := 0-1962.0724
457: , p0_a7 NUMBER := 0-1962.0724
454: , p0_a4 NUMBER := 0-1962.0724
455: , p0_a5 NUMBER := 0-1962.0724
456: , p0_a6 NUMBER := 0-1962.0724
457: , p0_a7 NUMBER := 0-1962.0724
458: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
459: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a5 NUMBER := 0-1962.0724
456: , p0_a6 NUMBER := 0-1962.0724
457: , p0_a7 NUMBER := 0-1962.0724
458: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
459: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
463: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
456: , p0_a6 NUMBER := 0-1962.0724
457: , p0_a7 NUMBER := 0-1962.0724
458: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
459: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
463: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
464: )
457: , p0_a7 NUMBER := 0-1962.0724
458: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
459: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
463: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
464: )
465: as
458: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
459: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
463: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
464: )
465: as
466: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
459: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
463: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
464: )
465: as
466: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
467: ddindx binary_integer; indx binary_integer;
500: , x_return_status OUT NOCOPY VARCHAR2
501: , x_msg_count OUT NOCOPY NUMBER
502: , x_msg_data OUT NOCOPY VARCHAR2
503: , p5_a0 NUMBER := 0-1962.0724
504: , p5_a1 DATE := fnd_api.g_miss_date
505: , p5_a2 NUMBER := 0-1962.0724
506: , p5_a3 DATE := fnd_api.g_miss_date
507: , p5_a4 NUMBER := 0-1962.0724
508: , p5_a5 NUMBER := 0-1962.0724
502: , x_msg_data OUT NOCOPY VARCHAR2
503: , p5_a0 NUMBER := 0-1962.0724
504: , p5_a1 DATE := fnd_api.g_miss_date
505: , p5_a2 NUMBER := 0-1962.0724
506: , p5_a3 DATE := fnd_api.g_miss_date
507: , p5_a4 NUMBER := 0-1962.0724
508: , p5_a5 NUMBER := 0-1962.0724
509: , p5_a6 NUMBER := 0-1962.0724
510: , p5_a7 NUMBER := 0-1962.0724
507: , p5_a4 NUMBER := 0-1962.0724
508: , p5_a5 NUMBER := 0-1962.0724
509: , p5_a6 NUMBER := 0-1962.0724
510: , p5_a7 NUMBER := 0-1962.0724
511: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a5 NUMBER := 0-1962.0724
509: , p5_a6 NUMBER := 0-1962.0724
510: , p5_a7 NUMBER := 0-1962.0724
511: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a6 NUMBER := 0-1962.0724
510: , p5_a7 NUMBER := 0-1962.0724
511: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
517: )
510: , p5_a7 NUMBER := 0-1962.0724
511: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
517: )
518: as
511: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
517: )
518: as
519: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
512: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
517: )
518: as
519: ddp_ps_strats_rec ams_ps_strats_pvt.ps_strats_rec_type;
520: ddindx binary_integer; indx binary_integer;