eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_PROD_TEMPLATE_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_prod_template_pvt.prod_template_tbl_type, a0 JTF_NUMBER_TABLE

Line 144: , p7_a1 DATE := fnd_api.g_miss_date

140: , x_msg_count OUT NOCOPY NUMBER
141: , x_msg_data OUT NOCOPY VARCHAR2
142: , x_template_id OUT NOCOPY NUMBER
143: , p7_a0 NUMBER := 0-1962.0724
144: , p7_a1 DATE := fnd_api.g_miss_date
145: , p7_a2 NUMBER := 0-1962.0724
146: , p7_a3 DATE := fnd_api.g_miss_date
147: , p7_a4 NUMBER := 0-1962.0724
148: , p7_a5 NUMBER := 0-1962.0724

Line 146: , p7_a3 DATE := fnd_api.g_miss_date

142: , x_template_id OUT NOCOPY NUMBER
143: , p7_a0 NUMBER := 0-1962.0724
144: , p7_a1 DATE := fnd_api.g_miss_date
145: , p7_a2 NUMBER := 0-1962.0724
146: , p7_a3 DATE := fnd_api.g_miss_date
147: , p7_a4 NUMBER := 0-1962.0724
148: , p7_a5 NUMBER := 0-1962.0724
149: , p7_a6 NUMBER := 0-1962.0724
150: , p7_a7 NUMBER := 0-1962.0724

Line 151: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

147: , p7_a4 NUMBER := 0-1962.0724
148: , p7_a5 NUMBER := 0-1962.0724
149: , p7_a6 NUMBER := 0-1962.0724
150: , p7_a7 NUMBER := 0-1962.0724
151: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
154: )
155: as

Line 152: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

148: , p7_a5 NUMBER := 0-1962.0724
149: , p7_a6 NUMBER := 0-1962.0724
150: , p7_a7 NUMBER := 0-1962.0724
151: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
154: )
155: as
156: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;

Line 153: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

149: , p7_a6 NUMBER := 0-1962.0724
150: , p7_a7 NUMBER := 0-1962.0724
151: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
154: )
155: as
156: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;
157: ddindx binary_integer; indx binary_integer;

Line 211: , p7_a1 DATE := fnd_api.g_miss_date

207: , x_return_status OUT NOCOPY VARCHAR2
208: , x_msg_count OUT NOCOPY NUMBER
209: , x_msg_data OUT NOCOPY VARCHAR2
210: , p7_a0 NUMBER := 0-1962.0724
211: , p7_a1 DATE := fnd_api.g_miss_date
212: , p7_a2 NUMBER := 0-1962.0724
213: , p7_a3 DATE := fnd_api.g_miss_date
214: , p7_a4 NUMBER := 0-1962.0724
215: , p7_a5 NUMBER := 0-1962.0724

Line 213: , p7_a3 DATE := fnd_api.g_miss_date

209: , x_msg_data OUT NOCOPY VARCHAR2
210: , p7_a0 NUMBER := 0-1962.0724
211: , p7_a1 DATE := fnd_api.g_miss_date
212: , p7_a2 NUMBER := 0-1962.0724
213: , p7_a3 DATE := fnd_api.g_miss_date
214: , p7_a4 NUMBER := 0-1962.0724
215: , p7_a5 NUMBER := 0-1962.0724
216: , p7_a6 NUMBER := 0-1962.0724
217: , p7_a7 NUMBER := 0-1962.0724

Line 218: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

214: , p7_a4 NUMBER := 0-1962.0724
215: , p7_a5 NUMBER := 0-1962.0724
216: , p7_a6 NUMBER := 0-1962.0724
217: , p7_a7 NUMBER := 0-1962.0724
218: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
221: )
222: as

Line 219: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

215: , p7_a5 NUMBER := 0-1962.0724
216: , p7_a6 NUMBER := 0-1962.0724
217: , p7_a7 NUMBER := 0-1962.0724
218: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
221: )
222: as
223: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;

Line 220: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

216: , p7_a6 NUMBER := 0-1962.0724
217: , p7_a7 NUMBER := 0-1962.0724
218: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
221: )
222: as
223: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;
224: ddindx binary_integer; indx binary_integer;

Line 275: , p3_a1 DATE := fnd_api.g_miss_date

271: , x_return_status OUT NOCOPY VARCHAR2
272: , x_msg_count OUT NOCOPY NUMBER
273: , x_msg_data OUT NOCOPY VARCHAR2
274: , p3_a0 NUMBER := 0-1962.0724
275: , p3_a1 DATE := fnd_api.g_miss_date
276: , p3_a2 NUMBER := 0-1962.0724
277: , p3_a3 DATE := fnd_api.g_miss_date
278: , p3_a4 NUMBER := 0-1962.0724
279: , p3_a5 NUMBER := 0-1962.0724

Line 277: , p3_a3 DATE := fnd_api.g_miss_date

273: , x_msg_data OUT NOCOPY VARCHAR2
274: , p3_a0 NUMBER := 0-1962.0724
275: , p3_a1 DATE := fnd_api.g_miss_date
276: , p3_a2 NUMBER := 0-1962.0724
277: , p3_a3 DATE := fnd_api.g_miss_date
278: , p3_a4 NUMBER := 0-1962.0724
279: , p3_a5 NUMBER := 0-1962.0724
280: , p3_a6 NUMBER := 0-1962.0724
281: , p3_a7 NUMBER := 0-1962.0724

Line 282: , p3_a8 VARCHAR2 := fnd_api.g_miss_char

278: , p3_a4 NUMBER := 0-1962.0724
279: , p3_a5 NUMBER := 0-1962.0724
280: , p3_a6 NUMBER := 0-1962.0724
281: , p3_a7 NUMBER := 0-1962.0724
282: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
283: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
285: )
286: as

Line 283: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

279: , p3_a5 NUMBER := 0-1962.0724
280: , p3_a6 NUMBER := 0-1962.0724
281: , p3_a7 NUMBER := 0-1962.0724
282: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
283: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
285: )
286: as
287: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;

Line 284: , p3_a10 VARCHAR2 := fnd_api.g_miss_char

280: , p3_a6 NUMBER := 0-1962.0724
281: , p3_a7 NUMBER := 0-1962.0724
282: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
283: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
284: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
285: )
286: as
287: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;
288: ddindx binary_integer; indx binary_integer;

Line 334: , p0_a1 DATE := fnd_api.g_miss_date

330:
331: procedure check_prod_template_items(p_validation_mode VARCHAR2
332: , x_return_status OUT NOCOPY VARCHAR2
333: , p0_a0 NUMBER := 0-1962.0724
334: , p0_a1 DATE := fnd_api.g_miss_date
335: , p0_a2 NUMBER := 0-1962.0724
336: , p0_a3 DATE := fnd_api.g_miss_date
337: , p0_a4 NUMBER := 0-1962.0724
338: , p0_a5 NUMBER := 0-1962.0724

Line 336: , p0_a3 DATE := fnd_api.g_miss_date

332: , x_return_status OUT NOCOPY VARCHAR2
333: , p0_a0 NUMBER := 0-1962.0724
334: , p0_a1 DATE := fnd_api.g_miss_date
335: , p0_a2 NUMBER := 0-1962.0724
336: , p0_a3 DATE := fnd_api.g_miss_date
337: , p0_a4 NUMBER := 0-1962.0724
338: , p0_a5 NUMBER := 0-1962.0724
339: , p0_a6 NUMBER := 0-1962.0724
340: , p0_a7 NUMBER := 0-1962.0724

Line 341: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

337: , p0_a4 NUMBER := 0-1962.0724
338: , p0_a5 NUMBER := 0-1962.0724
339: , p0_a6 NUMBER := 0-1962.0724
340: , p0_a7 NUMBER := 0-1962.0724
341: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
344: )
345: as

Line 342: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

338: , p0_a5 NUMBER := 0-1962.0724
339: , p0_a6 NUMBER := 0-1962.0724
340: , p0_a7 NUMBER := 0-1962.0724
341: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
344: )
345: as
346: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;

Line 343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

339: , p0_a6 NUMBER := 0-1962.0724
340: , p0_a7 NUMBER := 0-1962.0724
341: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
344: )
345: as
346: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;
347: ddindx binary_integer; indx binary_integer;

Line 381: , p5_a1 DATE := fnd_api.g_miss_date

377: , x_return_status OUT NOCOPY VARCHAR2
378: , x_msg_count OUT NOCOPY NUMBER
379: , x_msg_data OUT NOCOPY VARCHAR2
380: , p5_a0 NUMBER := 0-1962.0724
381: , p5_a1 DATE := fnd_api.g_miss_date
382: , p5_a2 NUMBER := 0-1962.0724
383: , p5_a3 DATE := fnd_api.g_miss_date
384: , p5_a4 NUMBER := 0-1962.0724
385: , p5_a5 NUMBER := 0-1962.0724

Line 383: , p5_a3 DATE := fnd_api.g_miss_date

379: , x_msg_data OUT NOCOPY VARCHAR2
380: , p5_a0 NUMBER := 0-1962.0724
381: , p5_a1 DATE := fnd_api.g_miss_date
382: , p5_a2 NUMBER := 0-1962.0724
383: , p5_a3 DATE := fnd_api.g_miss_date
384: , p5_a4 NUMBER := 0-1962.0724
385: , p5_a5 NUMBER := 0-1962.0724
386: , p5_a6 NUMBER := 0-1962.0724
387: , p5_a7 NUMBER := 0-1962.0724

Line 388: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

384: , p5_a4 NUMBER := 0-1962.0724
385: , p5_a5 NUMBER := 0-1962.0724
386: , p5_a6 NUMBER := 0-1962.0724
387: , p5_a7 NUMBER := 0-1962.0724
388: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
391: )
392: as

Line 389: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

385: , p5_a5 NUMBER := 0-1962.0724
386: , p5_a6 NUMBER := 0-1962.0724
387: , p5_a7 NUMBER := 0-1962.0724
388: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
391: )
392: as
393: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;

Line 390: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

386: , p5_a6 NUMBER := 0-1962.0724
387: , p5_a7 NUMBER := 0-1962.0724
388: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
391: )
392: as
393: ddp_prod_template_rec ams_prod_template_pvt.prod_template_rec_type;
394: ddindx binary_integer; indx binary_integer;