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.PV_ATTRIBUTE_USAGE_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 pv_attribute_usage_pvt.attribute_usage_tbl_type, a0 JTF_NUMBER_TABLE

Line 172: , p7_a1 DATE := fnd_api.g_miss_date

168: , x_msg_count out nocopy NUMBER
169: , x_msg_data out nocopy VARCHAR2
170: , x_attribute_usage_id out nocopy NUMBER
171: , p7_a0 NUMBER := 0-1962.0724
172: , p7_a1 DATE := fnd_api.g_miss_date
173: , p7_a2 NUMBER := 0-1962.0724
174: , p7_a3 DATE := fnd_api.g_miss_date
175: , p7_a4 NUMBER := 0-1962.0724
176: , p7_a5 NUMBER := 0-1962.0724

Line 174: , p7_a3 DATE := fnd_api.g_miss_date

170: , x_attribute_usage_id out nocopy NUMBER
171: , p7_a0 NUMBER := 0-1962.0724
172: , p7_a1 DATE := fnd_api.g_miss_date
173: , p7_a2 NUMBER := 0-1962.0724
174: , p7_a3 DATE := fnd_api.g_miss_date
175: , p7_a4 NUMBER := 0-1962.0724
176: , p7_a5 NUMBER := 0-1962.0724
177: , p7_a6 NUMBER := 0-1962.0724
178: , p7_a7 NUMBER := 0-1962.0724

Line 180: , p7_a9 DATE := fnd_api.g_miss_date

176: , p7_a5 NUMBER := 0-1962.0724
177: , p7_a6 NUMBER := 0-1962.0724
178: , p7_a7 NUMBER := 0-1962.0724
179: , p7_a8 NUMBER := 0-1962.0724
180: , p7_a9 DATE := fnd_api.g_miss_date
181: , p7_a10 NUMBER := 0-1962.0724
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a13 NUMBER := 0-1962.0724

Line 182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

178: , p7_a7 NUMBER := 0-1962.0724
179: , p7_a8 NUMBER := 0-1962.0724
180: , p7_a9 DATE := fnd_api.g_miss_date
181: , p7_a10 NUMBER := 0-1962.0724
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a13 NUMBER := 0-1962.0724
185: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
186: )

Line 183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

179: , p7_a8 NUMBER := 0-1962.0724
180: , p7_a9 DATE := fnd_api.g_miss_date
181: , p7_a10 NUMBER := 0-1962.0724
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a13 NUMBER := 0-1962.0724
185: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
186: )
187: as

Line 185: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

181: , p7_a10 NUMBER := 0-1962.0724
182: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a13 NUMBER := 0-1962.0724
185: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
186: )
187: as
188: ddp_attribute_usage_rec pv_attribute_usage_pvt.attribute_usage_rec_type;
189: ddindx binary_integer; indx binary_integer;

Line 248: , p7_a1 DATE := fnd_api.g_miss_date

244: , x_msg_count out nocopy NUMBER
245: , x_msg_data out nocopy VARCHAR2
246: , x_object_version_number out nocopy NUMBER
247: , p7_a0 NUMBER := 0-1962.0724
248: , p7_a1 DATE := fnd_api.g_miss_date
249: , p7_a2 NUMBER := 0-1962.0724
250: , p7_a3 DATE := fnd_api.g_miss_date
251: , p7_a4 NUMBER := 0-1962.0724
252: , p7_a5 NUMBER := 0-1962.0724

Line 250: , p7_a3 DATE := fnd_api.g_miss_date

246: , x_object_version_number out nocopy NUMBER
247: , p7_a0 NUMBER := 0-1962.0724
248: , p7_a1 DATE := fnd_api.g_miss_date
249: , p7_a2 NUMBER := 0-1962.0724
250: , p7_a3 DATE := fnd_api.g_miss_date
251: , p7_a4 NUMBER := 0-1962.0724
252: , p7_a5 NUMBER := 0-1962.0724
253: , p7_a6 NUMBER := 0-1962.0724
254: , p7_a7 NUMBER := 0-1962.0724

Line 256: , p7_a9 DATE := fnd_api.g_miss_date

252: , p7_a5 NUMBER := 0-1962.0724
253: , p7_a6 NUMBER := 0-1962.0724
254: , p7_a7 NUMBER := 0-1962.0724
255: , p7_a8 NUMBER := 0-1962.0724
256: , p7_a9 DATE := fnd_api.g_miss_date
257: , p7_a10 NUMBER := 0-1962.0724
258: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a13 NUMBER := 0-1962.0724

Line 258: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

254: , p7_a7 NUMBER := 0-1962.0724
255: , p7_a8 NUMBER := 0-1962.0724
256: , p7_a9 DATE := fnd_api.g_miss_date
257: , p7_a10 NUMBER := 0-1962.0724
258: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a13 NUMBER := 0-1962.0724
261: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
262: )

Line 259: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

255: , p7_a8 NUMBER := 0-1962.0724
256: , p7_a9 DATE := fnd_api.g_miss_date
257: , p7_a10 NUMBER := 0-1962.0724
258: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a13 NUMBER := 0-1962.0724
261: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
262: )
263: as

Line 261: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

257: , p7_a10 NUMBER := 0-1962.0724
258: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a13 NUMBER := 0-1962.0724
261: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
262: )
263: as
264: ddp_attribute_usage_rec pv_attribute_usage_pvt.attribute_usage_rec_type;
265: ddindx binary_integer; indx binary_integer;

Line 323: , p4_a1 DATE := fnd_api.g_miss_date

319: , x_return_status out nocopy VARCHAR2
320: , x_msg_count out nocopy NUMBER
321: , x_msg_data out nocopy VARCHAR2
322: , p4_a0 NUMBER := 0-1962.0724
323: , p4_a1 DATE := fnd_api.g_miss_date
324: , p4_a2 NUMBER := 0-1962.0724
325: , p4_a3 DATE := fnd_api.g_miss_date
326: , p4_a4 NUMBER := 0-1962.0724
327: , p4_a5 NUMBER := 0-1962.0724

Line 325: , p4_a3 DATE := fnd_api.g_miss_date

321: , x_msg_data out nocopy VARCHAR2
322: , p4_a0 NUMBER := 0-1962.0724
323: , p4_a1 DATE := fnd_api.g_miss_date
324: , p4_a2 NUMBER := 0-1962.0724
325: , p4_a3 DATE := fnd_api.g_miss_date
326: , p4_a4 NUMBER := 0-1962.0724
327: , p4_a5 NUMBER := 0-1962.0724
328: , p4_a6 NUMBER := 0-1962.0724
329: , p4_a7 NUMBER := 0-1962.0724

Line 331: , p4_a9 DATE := fnd_api.g_miss_date

327: , p4_a5 NUMBER := 0-1962.0724
328: , p4_a6 NUMBER := 0-1962.0724
329: , p4_a7 NUMBER := 0-1962.0724
330: , p4_a8 NUMBER := 0-1962.0724
331: , p4_a9 DATE := fnd_api.g_miss_date
332: , p4_a10 NUMBER := 0-1962.0724
333: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a13 NUMBER := 0-1962.0724

Line 333: , p4_a11 VARCHAR2 := fnd_api.g_miss_char

329: , p4_a7 NUMBER := 0-1962.0724
330: , p4_a8 NUMBER := 0-1962.0724
331: , p4_a9 DATE := fnd_api.g_miss_date
332: , p4_a10 NUMBER := 0-1962.0724
333: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a13 NUMBER := 0-1962.0724
336: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
337: )

Line 334: , p4_a12 VARCHAR2 := fnd_api.g_miss_char

330: , p4_a8 NUMBER := 0-1962.0724
331: , p4_a9 DATE := fnd_api.g_miss_date
332: , p4_a10 NUMBER := 0-1962.0724
333: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a13 NUMBER := 0-1962.0724
336: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
337: )
338: as

Line 336: , p4_a14 VARCHAR2 := fnd_api.g_miss_char

332: , p4_a10 NUMBER := 0-1962.0724
333: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
334: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
335: , p4_a13 NUMBER := 0-1962.0724
336: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
337: )
338: as
339: ddp_attribute_usage_rec pv_attribute_usage_pvt.attribute_usage_rec_type;
340: ddindx binary_integer; indx binary_integer;

Line 390: , p0_a1 DATE := fnd_api.g_miss_date

386:
387: procedure check_attr_usage_items(p_validation_mode VARCHAR2
388: , x_return_status out nocopy VARCHAR2
389: , p0_a0 NUMBER := 0-1962.0724
390: , p0_a1 DATE := fnd_api.g_miss_date
391: , p0_a2 NUMBER := 0-1962.0724
392: , p0_a3 DATE := fnd_api.g_miss_date
393: , p0_a4 NUMBER := 0-1962.0724
394: , p0_a5 NUMBER := 0-1962.0724

Line 392: , p0_a3 DATE := fnd_api.g_miss_date

388: , x_return_status out nocopy VARCHAR2
389: , p0_a0 NUMBER := 0-1962.0724
390: , p0_a1 DATE := fnd_api.g_miss_date
391: , p0_a2 NUMBER := 0-1962.0724
392: , p0_a3 DATE := fnd_api.g_miss_date
393: , p0_a4 NUMBER := 0-1962.0724
394: , p0_a5 NUMBER := 0-1962.0724
395: , p0_a6 NUMBER := 0-1962.0724
396: , p0_a7 NUMBER := 0-1962.0724

Line 398: , p0_a9 DATE := fnd_api.g_miss_date

394: , p0_a5 NUMBER := 0-1962.0724
395: , p0_a6 NUMBER := 0-1962.0724
396: , p0_a7 NUMBER := 0-1962.0724
397: , p0_a8 NUMBER := 0-1962.0724
398: , p0_a9 DATE := fnd_api.g_miss_date
399: , p0_a10 NUMBER := 0-1962.0724
400: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a13 NUMBER := 0-1962.0724

Line 400: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

396: , p0_a7 NUMBER := 0-1962.0724
397: , p0_a8 NUMBER := 0-1962.0724
398: , p0_a9 DATE := fnd_api.g_miss_date
399: , p0_a10 NUMBER := 0-1962.0724
400: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a13 NUMBER := 0-1962.0724
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404: )

Line 401: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

397: , p0_a8 NUMBER := 0-1962.0724
398: , p0_a9 DATE := fnd_api.g_miss_date
399: , p0_a10 NUMBER := 0-1962.0724
400: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a13 NUMBER := 0-1962.0724
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404: )
405: as

Line 403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

399: , p0_a10 NUMBER := 0-1962.0724
400: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
401: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
402: , p0_a13 NUMBER := 0-1962.0724
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404: )
405: as
406: ddp_attribute_usage_rec pv_attribute_usage_pvt.attribute_usage_rec_type;
407: ddindx binary_integer; indx binary_integer;

Line 446: , p5_a1 DATE := fnd_api.g_miss_date

442: , x_msg_count out nocopy NUMBER
443: , x_msg_data out nocopy VARCHAR2
444: , p_validation_mode VARCHAR2
445: , p5_a0 NUMBER := 0-1962.0724
446: , p5_a1 DATE := fnd_api.g_miss_date
447: , p5_a2 NUMBER := 0-1962.0724
448: , p5_a3 DATE := fnd_api.g_miss_date
449: , p5_a4 NUMBER := 0-1962.0724
450: , p5_a5 NUMBER := 0-1962.0724

Line 448: , p5_a3 DATE := fnd_api.g_miss_date

444: , p_validation_mode VARCHAR2
445: , p5_a0 NUMBER := 0-1962.0724
446: , p5_a1 DATE := fnd_api.g_miss_date
447: , p5_a2 NUMBER := 0-1962.0724
448: , p5_a3 DATE := fnd_api.g_miss_date
449: , p5_a4 NUMBER := 0-1962.0724
450: , p5_a5 NUMBER := 0-1962.0724
451: , p5_a6 NUMBER := 0-1962.0724
452: , p5_a7 NUMBER := 0-1962.0724

Line 454: , p5_a9 DATE := fnd_api.g_miss_date

450: , p5_a5 NUMBER := 0-1962.0724
451: , p5_a6 NUMBER := 0-1962.0724
452: , p5_a7 NUMBER := 0-1962.0724
453: , p5_a8 NUMBER := 0-1962.0724
454: , p5_a9 DATE := fnd_api.g_miss_date
455: , p5_a10 NUMBER := 0-1962.0724
456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a13 NUMBER := 0-1962.0724

Line 456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

452: , p5_a7 NUMBER := 0-1962.0724
453: , p5_a8 NUMBER := 0-1962.0724
454: , p5_a9 DATE := fnd_api.g_miss_date
455: , p5_a10 NUMBER := 0-1962.0724
456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a13 NUMBER := 0-1962.0724
459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
460: )

Line 457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

453: , p5_a8 NUMBER := 0-1962.0724
454: , p5_a9 DATE := fnd_api.g_miss_date
455: , p5_a10 NUMBER := 0-1962.0724
456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a13 NUMBER := 0-1962.0724
459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
460: )
461: as

Line 459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

455: , p5_a10 NUMBER := 0-1962.0724
456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a13 NUMBER := 0-1962.0724
459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
460: )
461: as
462: ddp_attribute_usage_rec pv_attribute_usage_pvt.attribute_usage_rec_type;
463: ddindx binary_integer; indx binary_integer;