APPS.AMS_DM_TARGET_VALUE_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_dm_target_value_pvt.dm_target_value_tbl_type, a0 JTF_NUMBER_TABLE

Line 158: , p7_a1 DATE := fnd_api.g_miss_date

154: , x_msg_count OUT NOCOPY NUMBER
155: , x_msg_data OUT NOCOPY VARCHAR2
156: , x_target_value_id OUT NOCOPY NUMBER
157: , p7_a0 NUMBER := 0-1962.0724
158: , p7_a1 DATE := fnd_api.g_miss_date
159: , p7_a2 NUMBER := 0-1962.0724
160: , p7_a3 DATE := fnd_api.g_miss_date
161: , p7_a4 NUMBER := 0-1962.0724
162: , p7_a5 NUMBER := 0-1962.0724

Line 160: , p7_a3 DATE := fnd_api.g_miss_date

156: , x_target_value_id OUT NOCOPY NUMBER
157: , p7_a0 NUMBER := 0-1962.0724
158: , p7_a1 DATE := fnd_api.g_miss_date
159: , p7_a2 NUMBER := 0-1962.0724
160: , p7_a3 DATE := fnd_api.g_miss_date
161: , p7_a4 NUMBER := 0-1962.0724
162: , p7_a5 NUMBER := 0-1962.0724
163: , p7_a6 NUMBER := 0-1962.0724
164: , p7_a7 NUMBER := 0-1962.0724

Line 166: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

162: , p7_a5 NUMBER := 0-1962.0724
163: , p7_a6 NUMBER := 0-1962.0724
164: , p7_a7 NUMBER := 0-1962.0724
165: , p7_a8 NUMBER := 0-1962.0724
166: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
170: )

Line 167: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

163: , p7_a6 NUMBER := 0-1962.0724
164: , p7_a7 NUMBER := 0-1962.0724
165: , p7_a8 NUMBER := 0-1962.0724
166: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
170: )
171: as

Line 168: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

164: , p7_a7 NUMBER := 0-1962.0724
165: , p7_a8 NUMBER := 0-1962.0724
166: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
170: )
171: as
172: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;

Line 169: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

165: , p7_a8 NUMBER := 0-1962.0724
166: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
170: )
171: as
172: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;
173: ddindx binary_integer; indx binary_integer;

Line 230: , p7_a1 DATE := fnd_api.g_miss_date

226: , x_msg_count OUT NOCOPY NUMBER
227: , x_msg_data OUT NOCOPY VARCHAR2
228: , x_object_version_number OUT NOCOPY NUMBER
229: , p7_a0 NUMBER := 0-1962.0724
230: , p7_a1 DATE := fnd_api.g_miss_date
231: , p7_a2 NUMBER := 0-1962.0724
232: , p7_a3 DATE := fnd_api.g_miss_date
233: , p7_a4 NUMBER := 0-1962.0724
234: , p7_a5 NUMBER := 0-1962.0724

Line 232: , p7_a3 DATE := fnd_api.g_miss_date

228: , x_object_version_number OUT NOCOPY NUMBER
229: , p7_a0 NUMBER := 0-1962.0724
230: , p7_a1 DATE := fnd_api.g_miss_date
231: , p7_a2 NUMBER := 0-1962.0724
232: , p7_a3 DATE := fnd_api.g_miss_date
233: , p7_a4 NUMBER := 0-1962.0724
234: , p7_a5 NUMBER := 0-1962.0724
235: , p7_a6 NUMBER := 0-1962.0724
236: , p7_a7 NUMBER := 0-1962.0724

Line 238: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

234: , p7_a5 NUMBER := 0-1962.0724
235: , p7_a6 NUMBER := 0-1962.0724
236: , p7_a7 NUMBER := 0-1962.0724
237: , p7_a8 NUMBER := 0-1962.0724
238: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
242: )

Line 239: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

235: , p7_a6 NUMBER := 0-1962.0724
236: , p7_a7 NUMBER := 0-1962.0724
237: , p7_a8 NUMBER := 0-1962.0724
238: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
242: )
243: as

Line 240: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

236: , p7_a7 NUMBER := 0-1962.0724
237: , p7_a8 NUMBER := 0-1962.0724
238: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
242: )
243: as
244: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;

Line 241: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

237: , p7_a8 NUMBER := 0-1962.0724
238: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
240: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
242: )
243: as
244: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;
245: ddindx binary_integer; indx binary_integer;

Line 301: , p3_a1 DATE := fnd_api.g_miss_date

297: , x_return_status OUT NOCOPY VARCHAR2
298: , x_msg_count OUT NOCOPY NUMBER
299: , x_msg_data OUT NOCOPY VARCHAR2
300: , p3_a0 NUMBER := 0-1962.0724
301: , p3_a1 DATE := fnd_api.g_miss_date
302: , p3_a2 NUMBER := 0-1962.0724
303: , p3_a3 DATE := fnd_api.g_miss_date
304: , p3_a4 NUMBER := 0-1962.0724
305: , p3_a5 NUMBER := 0-1962.0724

Line 303: , p3_a3 DATE := fnd_api.g_miss_date

299: , x_msg_data OUT NOCOPY VARCHAR2
300: , p3_a0 NUMBER := 0-1962.0724
301: , p3_a1 DATE := fnd_api.g_miss_date
302: , p3_a2 NUMBER := 0-1962.0724
303: , p3_a3 DATE := fnd_api.g_miss_date
304: , p3_a4 NUMBER := 0-1962.0724
305: , p3_a5 NUMBER := 0-1962.0724
306: , p3_a6 NUMBER := 0-1962.0724
307: , p3_a7 NUMBER := 0-1962.0724

Line 309: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

305: , p3_a5 NUMBER := 0-1962.0724
306: , p3_a6 NUMBER := 0-1962.0724
307: , p3_a7 NUMBER := 0-1962.0724
308: , p3_a8 NUMBER := 0-1962.0724
309: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
310: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
311: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
312: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
313: )

Line 310: , p3_a10 VARCHAR2 := fnd_api.g_miss_char

306: , p3_a6 NUMBER := 0-1962.0724
307: , p3_a7 NUMBER := 0-1962.0724
308: , p3_a8 NUMBER := 0-1962.0724
309: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
310: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
311: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
312: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
313: )
314: as

Line 311: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

307: , p3_a7 NUMBER := 0-1962.0724
308: , p3_a8 NUMBER := 0-1962.0724
309: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
310: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
311: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
312: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
313: )
314: as
315: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;

Line 312: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

308: , p3_a8 NUMBER := 0-1962.0724
309: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
310: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
311: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
312: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
313: )
314: as
315: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;
316: ddindx binary_integer; indx binary_integer;

Line 364: , p0_a1 DATE := fnd_api.g_miss_date

360:
361: procedure check_dm_target_value_items(p_validation_mode VARCHAR2
362: , x_return_status OUT NOCOPY VARCHAR2
363: , p0_a0 NUMBER := 0-1962.0724
364: , p0_a1 DATE := fnd_api.g_miss_date
365: , p0_a2 NUMBER := 0-1962.0724
366: , p0_a3 DATE := fnd_api.g_miss_date
367: , p0_a4 NUMBER := 0-1962.0724
368: , p0_a5 NUMBER := 0-1962.0724

Line 366: , p0_a3 DATE := fnd_api.g_miss_date

362: , x_return_status OUT NOCOPY VARCHAR2
363: , p0_a0 NUMBER := 0-1962.0724
364: , p0_a1 DATE := fnd_api.g_miss_date
365: , p0_a2 NUMBER := 0-1962.0724
366: , p0_a3 DATE := fnd_api.g_miss_date
367: , p0_a4 NUMBER := 0-1962.0724
368: , p0_a5 NUMBER := 0-1962.0724
369: , p0_a6 NUMBER := 0-1962.0724
370: , p0_a7 NUMBER := 0-1962.0724

Line 372: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

368: , p0_a5 NUMBER := 0-1962.0724
369: , p0_a6 NUMBER := 0-1962.0724
370: , p0_a7 NUMBER := 0-1962.0724
371: , p0_a8 NUMBER := 0-1962.0724
372: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
376: )

Line 373: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

369: , p0_a6 NUMBER := 0-1962.0724
370: , p0_a7 NUMBER := 0-1962.0724
371: , p0_a8 NUMBER := 0-1962.0724
372: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
376: )
377: as

Line 374: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

370: , p0_a7 NUMBER := 0-1962.0724
371: , p0_a8 NUMBER := 0-1962.0724
372: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
376: )
377: as
378: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;

Line 375: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

371: , p0_a8 NUMBER := 0-1962.0724
372: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
373: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
375: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
376: )
377: as
378: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;
379: ddindx binary_integer; indx binary_integer;

Line 415: , p5_a1 DATE := fnd_api.g_miss_date

411: , x_return_status OUT NOCOPY VARCHAR2
412: , x_msg_count OUT NOCOPY NUMBER
413: , x_msg_data OUT NOCOPY VARCHAR2
414: , p5_a0 NUMBER := 0-1962.0724
415: , p5_a1 DATE := fnd_api.g_miss_date
416: , p5_a2 NUMBER := 0-1962.0724
417: , p5_a3 DATE := fnd_api.g_miss_date
418: , p5_a4 NUMBER := 0-1962.0724
419: , p5_a5 NUMBER := 0-1962.0724

Line 417: , p5_a3 DATE := fnd_api.g_miss_date

413: , x_msg_data OUT NOCOPY VARCHAR2
414: , p5_a0 NUMBER := 0-1962.0724
415: , p5_a1 DATE := fnd_api.g_miss_date
416: , p5_a2 NUMBER := 0-1962.0724
417: , p5_a3 DATE := fnd_api.g_miss_date
418: , p5_a4 NUMBER := 0-1962.0724
419: , p5_a5 NUMBER := 0-1962.0724
420: , p5_a6 NUMBER := 0-1962.0724
421: , p5_a7 NUMBER := 0-1962.0724

Line 423: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

419: , p5_a5 NUMBER := 0-1962.0724
420: , p5_a6 NUMBER := 0-1962.0724
421: , p5_a7 NUMBER := 0-1962.0724
422: , p5_a8 NUMBER := 0-1962.0724
423: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
427: )

Line 424: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

420: , p5_a6 NUMBER := 0-1962.0724
421: , p5_a7 NUMBER := 0-1962.0724
422: , p5_a8 NUMBER := 0-1962.0724
423: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
427: )
428: as

Line 425: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

421: , p5_a7 NUMBER := 0-1962.0724
422: , p5_a8 NUMBER := 0-1962.0724
423: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
427: )
428: as
429: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;

Line 426: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

422: , p5_a8 NUMBER := 0-1962.0724
423: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
427: )
428: as
429: ddp_dm_target_value_rec ams_dm_target_value_pvt.dm_target_value_rec_type;
430: ddindx binary_integer; indx binary_integer;