DBA Data[Home] [Help]

APPS.AMS_PS_STRATS_PVT_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

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;

Line 18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; 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

Line 165: , p7_a1 DATE := fnd_api.g_miss_date

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

Line 167: , p7_a3 DATE := fnd_api.g_miss_date

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

Line 172: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 173: , p7_a9 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

Line 174: , p7_a10 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: )

Line 175: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

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

Line 176: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

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;

Line 177: , p7_a13 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;
181: ddindx binary_integer; indx binary_integer;

Line 239: , p7_a1 DATE := fnd_api.g_miss_date

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

Line 241: , p7_a3 DATE := fnd_api.g_miss_date

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

Line 246: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 247: , p7_a9 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

Line 248: , p7_a10 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: )

Line 249: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

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

Line 250: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

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;

Line 251: , p7_a13 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;
255: ddindx binary_integer; indx binary_integer;

Line 314: , p7_a1 DATE := fnd_api.g_miss_date

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

Line 316: , p7_a3 DATE := fnd_api.g_miss_date

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

Line 321: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 322: , p7_a9 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

Line 323: , p7_a10 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: )

Line 324: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

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

Line 325: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

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;

Line 326: , p7_a13 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;
330: ddindx binary_integer; indx binary_integer;

Line 389: , p3_a1 DATE := fnd_api.g_miss_date

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

Line 391: , p3_a3 DATE := fnd_api.g_miss_date

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

Line 396: , p3_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 397: , p3_a9 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

Line 398: , p3_a10 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: )

Line 399: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

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

Line 400: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

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;

Line 401: , p3_a13 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;
405: ddindx binary_integer; indx binary_integer;

Line 451: , p0_a1 DATE := fnd_api.g_miss_date

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

Line 453: , p0_a3 DATE := fnd_api.g_miss_date

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

Line 458: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 459: , p0_a9 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

Line 460: , p0_a10 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: )

Line 461: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

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

Line 462: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

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;

Line 463: , p0_a13 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;
467: ddindx binary_integer; indx binary_integer;

Line 504: , p5_a1 DATE := fnd_api.g_miss_date

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

Line 506: , p5_a3 DATE := fnd_api.g_miss_date

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

Line 511: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 512: , p5_a9 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

Line 513: , p5_a10 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: )

Line 514: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

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

Line 515: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

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;

Line 516: , p5_a13 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;
520: ddindx binary_integer; indx binary_integer;