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.OZF_VOL_OFFR_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_p2(t OUT NOCOPY ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 JTF_NUMBER_TABLE

Line 145: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

141: , x_msg_data OUT NOCOPY VARCHAR2
142: , x_volume_offer_tiers_id OUT NOCOPY NUMBER
143: , p7_a0 NUMBER := 0-1962.0724
144: , p7_a1 NUMBER := 0-1962.0724
145: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a3 NUMBER := 0-1962.0724
147: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a5 NUMBER := 0-1962.0724
149: , p7_a6 NUMBER := 0-1962.0724

Line 147: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

143: , p7_a0 NUMBER := 0-1962.0724
144: , p7_a1 NUMBER := 0-1962.0724
145: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a3 NUMBER := 0-1962.0724
147: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a5 NUMBER := 0-1962.0724
149: , p7_a6 NUMBER := 0-1962.0724
150: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

Line 150: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

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

Line 151: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

147: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a5 NUMBER := 0-1962.0724
149: , p7_a6 NUMBER := 0-1962.0724
150: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a10 NUMBER := 0-1962.0724
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 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a10 NUMBER := 0-1962.0724
154: )
155: as
156: ddp_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;

Line 213: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 215: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

211: , p7_a0 NUMBER := 0-1962.0724
212: , p7_a1 NUMBER := 0-1962.0724
213: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a3 NUMBER := 0-1962.0724
215: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a5 NUMBER := 0-1962.0724
217: , p7_a6 NUMBER := 0-1962.0724
218: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

Line 218: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

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

Line 219: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

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

Line 220: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

216: , p7_a5 NUMBER := 0-1962.0724
217: , p7_a6 NUMBER := 0-1962.0724
218: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a10 NUMBER := 0-1962.0724
222: )
223: as
224: ddp_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;

Line 280: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

276: , x_msg_count OUT NOCOPY NUMBER
277: , x_msg_data OUT NOCOPY VARCHAR2
278: , p3_a0 NUMBER := 0-1962.0724
279: , p3_a1 NUMBER := 0-1962.0724
280: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
281: , p3_a3 NUMBER := 0-1962.0724
282: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
283: , p3_a5 NUMBER := 0-1962.0724
284: , p3_a6 NUMBER := 0-1962.0724

Line 282: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

278: , p3_a0 NUMBER := 0-1962.0724
279: , p3_a1 NUMBER := 0-1962.0724
280: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
281: , p3_a3 NUMBER := 0-1962.0724
282: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
283: , p3_a5 NUMBER := 0-1962.0724
284: , p3_a6 NUMBER := 0-1962.0724
285: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p3_a8 VARCHAR2 := fnd_api.g_miss_char

Line 285: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

281: , p3_a3 NUMBER := 0-1962.0724
282: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
283: , p3_a5 NUMBER := 0-1962.0724
284: , p3_a6 NUMBER := 0-1962.0724
285: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p3_a10 NUMBER := 0-1962.0724
289: )

Line 286: , p3_a8 VARCHAR2 := fnd_api.g_miss_char

282: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
283: , p3_a5 NUMBER := 0-1962.0724
284: , p3_a6 NUMBER := 0-1962.0724
285: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p3_a10 NUMBER := 0-1962.0724
289: )
290: as

Line 287: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

283: , p3_a5 NUMBER := 0-1962.0724
284: , p3_a6 NUMBER := 0-1962.0724
285: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
287: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
288: , p3_a10 NUMBER := 0-1962.0724
289: )
290: as
291: ddp_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;

Line 339: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

335: procedure check_vol_offr_tier_items(p_validation_mode VARCHAR2
336: , x_return_status OUT NOCOPY VARCHAR2
337: , p0_a0 NUMBER := 0-1962.0724
338: , p0_a1 NUMBER := 0-1962.0724
339: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a3 NUMBER := 0-1962.0724
341: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a5 NUMBER := 0-1962.0724
343: , p0_a6 NUMBER := 0-1962.0724

Line 341: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

337: , p0_a0 NUMBER := 0-1962.0724
338: , p0_a1 NUMBER := 0-1962.0724
339: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a3 NUMBER := 0-1962.0724
341: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a5 NUMBER := 0-1962.0724
343: , p0_a6 NUMBER := 0-1962.0724
344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

Line 344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

340: , p0_a3 NUMBER := 0-1962.0724
341: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a5 NUMBER := 0-1962.0724
343: , p0_a6 NUMBER := 0-1962.0724
344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a10 NUMBER := 0-1962.0724
348: )

Line 345: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

341: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a5 NUMBER := 0-1962.0724
343: , p0_a6 NUMBER := 0-1962.0724
344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a10 NUMBER := 0-1962.0724
348: )
349: as

Line 346: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

342: , p0_a5 NUMBER := 0-1962.0724
343: , p0_a6 NUMBER := 0-1962.0724
344: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a10 NUMBER := 0-1962.0724
348: )
349: as
350: ddp_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;

Line 386: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

382: , x_msg_count OUT NOCOPY NUMBER
383: , x_msg_data OUT NOCOPY VARCHAR2
384: , p5_a0 NUMBER := 0-1962.0724
385: , p5_a1 NUMBER := 0-1962.0724
386: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a3 NUMBER := 0-1962.0724
388: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a5 NUMBER := 0-1962.0724
390: , p5_a6 NUMBER := 0-1962.0724

Line 388: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

384: , p5_a0 NUMBER := 0-1962.0724
385: , p5_a1 NUMBER := 0-1962.0724
386: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
387: , p5_a3 NUMBER := 0-1962.0724
388: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a5 NUMBER := 0-1962.0724
390: , p5_a6 NUMBER := 0-1962.0724
391: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 391: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

387: , p5_a3 NUMBER := 0-1962.0724
388: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a5 NUMBER := 0-1962.0724
390: , p5_a6 NUMBER := 0-1962.0724
391: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a10 NUMBER := 0-1962.0724
395: )

Line 392: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

388: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
389: , p5_a5 NUMBER := 0-1962.0724
390: , p5_a6 NUMBER := 0-1962.0724
391: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a10 NUMBER := 0-1962.0724
395: )
396: as

Line 393: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

389: , p5_a5 NUMBER := 0-1962.0724
390: , p5_a6 NUMBER := 0-1962.0724
391: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a10 NUMBER := 0-1962.0724
395: )
396: as
397: ddp_vol_offr_tier_rec ozf_vol_offr_pvt.vol_offr_tier_rec_type;