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_CODE_PVT_W dependencies on FND_API

Line 9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as

Line 14: a number := fnd_api.g_miss_num;

10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;

Line 144: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

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

Line 145: , p7_a2 DATE := fnd_api.g_miss_date

141: , x_msg_data out nocopy VARCHAR2
142: , x_attr_code_id out nocopy NUMBER
143: , p7_a0 NUMBER := 0-1962.0724
144: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a2 DATE := fnd_api.g_miss_date
146: , p7_a3 NUMBER := 0-1962.0724
147: , p7_a4 DATE := fnd_api.g_miss_date
148: , p7_a5 NUMBER := 0-1962.0724
149: , p7_a6 NUMBER := 0-1962.0724

Line 147: , p7_a4 DATE := fnd_api.g_miss_date

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

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 NUMBER := 0-1962.0724
152: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
154: )
155:
156: as

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 NUMBER := 0-1962.0724
152: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
154: )
155:
156: as
157: ddp_attribute_code_rec pv_attribute_code_pvt.attribute_code_rec_type;

Line 213: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

209: , x_msg_count out nocopy NUMBER
210: , x_msg_data out nocopy VARCHAR2
211: , x_object_version_number out nocopy NUMBER
212: , p7_a0 NUMBER := 0-1962.0724
213: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a2 DATE := fnd_api.g_miss_date
215: , p7_a3 NUMBER := 0-1962.0724
216: , p7_a4 DATE := fnd_api.g_miss_date
217: , p7_a5 NUMBER := 0-1962.0724

Line 214: , p7_a2 DATE := fnd_api.g_miss_date

210: , x_msg_data out nocopy VARCHAR2
211: , x_object_version_number out nocopy NUMBER
212: , p7_a0 NUMBER := 0-1962.0724
213: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a2 DATE := fnd_api.g_miss_date
215: , p7_a3 NUMBER := 0-1962.0724
216: , p7_a4 DATE := fnd_api.g_miss_date
217: , p7_a5 NUMBER := 0-1962.0724
218: , p7_a6 NUMBER := 0-1962.0724

Line 216: , p7_a4 DATE := fnd_api.g_miss_date

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

Line 221: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

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

Line 222: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

218: , p7_a6 NUMBER := 0-1962.0724
219: , p7_a7 NUMBER := 0-1962.0724
220: , p7_a8 NUMBER := 0-1962.0724
221: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
223: )
224:
225: as
226: ddp_attribute_code_rec pv_attribute_code_pvt.attribute_code_rec_type;

Line 281: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

277: , x_return_status out nocopy VARCHAR2
278: , x_msg_count out nocopy NUMBER
279: , x_msg_data out nocopy VARCHAR2
280: , p4_a0 NUMBER := 0-1962.0724
281: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
282: , p4_a2 DATE := fnd_api.g_miss_date
283: , p4_a3 NUMBER := 0-1962.0724
284: , p4_a4 DATE := fnd_api.g_miss_date
285: , p4_a5 NUMBER := 0-1962.0724

Line 282: , p4_a2 DATE := fnd_api.g_miss_date

278: , x_msg_count out nocopy NUMBER
279: , x_msg_data out nocopy VARCHAR2
280: , p4_a0 NUMBER := 0-1962.0724
281: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
282: , p4_a2 DATE := fnd_api.g_miss_date
283: , p4_a3 NUMBER := 0-1962.0724
284: , p4_a4 DATE := fnd_api.g_miss_date
285: , p4_a5 NUMBER := 0-1962.0724
286: , p4_a6 NUMBER := 0-1962.0724

Line 284: , p4_a4 DATE := fnd_api.g_miss_date

280: , p4_a0 NUMBER := 0-1962.0724
281: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
282: , p4_a2 DATE := fnd_api.g_miss_date
283: , p4_a3 NUMBER := 0-1962.0724
284: , p4_a4 DATE := fnd_api.g_miss_date
285: , p4_a5 NUMBER := 0-1962.0724
286: , p4_a6 NUMBER := 0-1962.0724
287: , p4_a7 NUMBER := 0-1962.0724
288: , p4_a8 NUMBER := 0-1962.0724

Line 289: , p4_a9 VARCHAR2 := fnd_api.g_miss_char

285: , p4_a5 NUMBER := 0-1962.0724
286: , p4_a6 NUMBER := 0-1962.0724
287: , p4_a7 NUMBER := 0-1962.0724
288: , p4_a8 NUMBER := 0-1962.0724
289: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
290: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
291: )
292:
293: as

Line 290: , p4_a10 VARCHAR2 := fnd_api.g_miss_char

286: , p4_a6 NUMBER := 0-1962.0724
287: , p4_a7 NUMBER := 0-1962.0724
288: , p4_a8 NUMBER := 0-1962.0724
289: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
290: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
291: )
292:
293: as
294: ddp_attribute_code_rec pv_attribute_code_pvt.attribute_code_rec_type;

Line 341: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

337:
338: procedure check_attr_code_items(p_validation_mode VARCHAR2
339: , x_return_status out nocopy VARCHAR2
340: , p0_a0 NUMBER := 0-1962.0724
341: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a2 DATE := fnd_api.g_miss_date
343: , p0_a3 NUMBER := 0-1962.0724
344: , p0_a4 DATE := fnd_api.g_miss_date
345: , p0_a5 NUMBER := 0-1962.0724

Line 342: , p0_a2 DATE := fnd_api.g_miss_date

338: procedure check_attr_code_items(p_validation_mode VARCHAR2
339: , x_return_status out nocopy VARCHAR2
340: , p0_a0 NUMBER := 0-1962.0724
341: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a2 DATE := fnd_api.g_miss_date
343: , p0_a3 NUMBER := 0-1962.0724
344: , p0_a4 DATE := fnd_api.g_miss_date
345: , p0_a5 NUMBER := 0-1962.0724
346: , p0_a6 NUMBER := 0-1962.0724

Line 344: , p0_a4 DATE := fnd_api.g_miss_date

340: , p0_a0 NUMBER := 0-1962.0724
341: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a2 DATE := fnd_api.g_miss_date
343: , p0_a3 NUMBER := 0-1962.0724
344: , p0_a4 DATE := fnd_api.g_miss_date
345: , p0_a5 NUMBER := 0-1962.0724
346: , p0_a6 NUMBER := 0-1962.0724
347: , p0_a7 NUMBER := 0-1962.0724
348: , p0_a8 NUMBER := 0-1962.0724

Line 349: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

345: , p0_a5 NUMBER := 0-1962.0724
346: , p0_a6 NUMBER := 0-1962.0724
347: , p0_a7 NUMBER := 0-1962.0724
348: , p0_a8 NUMBER := 0-1962.0724
349: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
351: )
352:
353: as

Line 350: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

346: , p0_a6 NUMBER := 0-1962.0724
347: , p0_a7 NUMBER := 0-1962.0724
348: , p0_a8 NUMBER := 0-1962.0724
349: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
351: )
352:
353: as
354: ddp_attribute_code_rec pv_attribute_code_pvt.attribute_code_rec_type;

Line 390: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

386: , x_msg_count out nocopy NUMBER
387: , x_msg_data out nocopy VARCHAR2
388: , p_validation_mode VARCHAR2
389: , p5_a0 NUMBER := 0-1962.0724
390: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a2 DATE := fnd_api.g_miss_date
392: , p5_a3 NUMBER := 0-1962.0724
393: , p5_a4 DATE := fnd_api.g_miss_date
394: , p5_a5 NUMBER := 0-1962.0724

Line 391: , p5_a2 DATE := fnd_api.g_miss_date

387: , x_msg_data out nocopy VARCHAR2
388: , p_validation_mode VARCHAR2
389: , p5_a0 NUMBER := 0-1962.0724
390: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a2 DATE := fnd_api.g_miss_date
392: , p5_a3 NUMBER := 0-1962.0724
393: , p5_a4 DATE := fnd_api.g_miss_date
394: , p5_a5 NUMBER := 0-1962.0724
395: , p5_a6 NUMBER := 0-1962.0724

Line 393: , p5_a4 DATE := fnd_api.g_miss_date

389: , p5_a0 NUMBER := 0-1962.0724
390: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a2 DATE := fnd_api.g_miss_date
392: , p5_a3 NUMBER := 0-1962.0724
393: , p5_a4 DATE := fnd_api.g_miss_date
394: , p5_a5 NUMBER := 0-1962.0724
395: , p5_a6 NUMBER := 0-1962.0724
396: , p5_a7 NUMBER := 0-1962.0724
397: , p5_a8 NUMBER := 0-1962.0724

Line 398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

394: , p5_a5 NUMBER := 0-1962.0724
395: , p5_a6 NUMBER := 0-1962.0724
396: , p5_a7 NUMBER := 0-1962.0724
397: , p5_a8 NUMBER := 0-1962.0724
398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
400: )
401:
402: as

Line 399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

395: , p5_a6 NUMBER := 0-1962.0724
396: , p5_a7 NUMBER := 0-1962.0724
397: , p5_a8 NUMBER := 0-1962.0724
398: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
400: )
401:
402: as
403: ddp_attribute_code_rec pv_attribute_code_pvt.attribute_code_rec_type;