APPS.PV_GE_CHKLST_RESP_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_ge_chklst_resp_pvt.ge_chklst_resp_tbl_type, a0 JTF_NUMBER_TABLE

Line 146: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

142: , x_chklst_response_id out nocopy NUMBER
143: , p7_a0 NUMBER := 0-1962.0724
144: , p7_a1 NUMBER := 0-1962.0724
145: , p7_a2 NUMBER := 0-1962.0724
146: , p7_a3 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 DATE := fnd_api.g_miss_date

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 NUMBER := 0-1962.0724
146: , p7_a3 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 DATE := fnd_api.g_miss_date
151: , p7_a8 NUMBER := 0-1962.0724

Line 150: , p7_a7 DATE := fnd_api.g_miss_date

146: , p7_a3 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 DATE := fnd_api.g_miss_date
151: , p7_a8 NUMBER := 0-1962.0724
152: , p7_a9 DATE := fnd_api.g_miss_date
153: , p7_a10 NUMBER := 0-1962.0724
154: )

Line 152: , p7_a9 DATE := fnd_api.g_miss_date

148: , p7_a5 NUMBER := 0-1962.0724
149: , p7_a6 NUMBER := 0-1962.0724
150: , p7_a7 DATE := fnd_api.g_miss_date
151: , p7_a8 NUMBER := 0-1962.0724
152: , p7_a9 DATE := fnd_api.g_miss_date
153: , p7_a10 NUMBER := 0-1962.0724
154: )
155:
156: as

Line 214: , p7_a3 VARCHAR2 := fnd_api.g_miss_char

210: , x_msg_data out nocopy VARCHAR2
211: , p7_a0 NUMBER := 0-1962.0724
212: , p7_a1 NUMBER := 0-1962.0724
213: , p7_a2 NUMBER := 0-1962.0724
214: , p7_a3 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 DATE := fnd_api.g_miss_date

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 NUMBER := 0-1962.0724
214: , p7_a3 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 DATE := fnd_api.g_miss_date
219: , p7_a8 NUMBER := 0-1962.0724

Line 218: , p7_a7 DATE := fnd_api.g_miss_date

214: , p7_a3 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 DATE := fnd_api.g_miss_date
219: , p7_a8 NUMBER := 0-1962.0724
220: , p7_a9 DATE := fnd_api.g_miss_date
221: , p7_a10 NUMBER := 0-1962.0724
222: )

Line 220: , p7_a9 DATE := fnd_api.g_miss_date

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

Line 279: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

275: , x_msg_data out nocopy VARCHAR2
276: , p3_a0 NUMBER := 0-1962.0724
277: , p3_a1 NUMBER := 0-1962.0724
278: , p3_a2 NUMBER := 0-1962.0724
279: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
280: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
281: , p3_a5 NUMBER := 0-1962.0724
282: , p3_a6 NUMBER := 0-1962.0724
283: , p3_a7 DATE := fnd_api.g_miss_date

Line 280: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

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

Line 283: , p3_a7 DATE := fnd_api.g_miss_date

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

Line 285: , p3_a9 DATE := fnd_api.g_miss_date

281: , p3_a5 NUMBER := 0-1962.0724
282: , p3_a6 NUMBER := 0-1962.0724
283: , p3_a7 DATE := fnd_api.g_miss_date
284: , p3_a8 NUMBER := 0-1962.0724
285: , p3_a9 DATE := fnd_api.g_miss_date
286: , p3_a10 NUMBER := 0-1962.0724
287: )
288:
289: as

Line 339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

335: , x_return_status out nocopy VARCHAR2
336: , p0_a0 NUMBER := 0-1962.0724
337: , p0_a1 NUMBER := 0-1962.0724
338: , p0_a2 NUMBER := 0-1962.0724
339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a5 NUMBER := 0-1962.0724
342: , p0_a6 NUMBER := 0-1962.0724
343: , p0_a7 DATE := fnd_api.g_miss_date

Line 340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

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

Line 343: , p0_a7 DATE := fnd_api.g_miss_date

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

Line 345: , p0_a9 DATE := fnd_api.g_miss_date

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

Line 387: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

383: , x_msg_data out nocopy VARCHAR2
384: , p5_a0 NUMBER := 0-1962.0724
385: , p5_a1 NUMBER := 0-1962.0724
386: , p5_a2 NUMBER := 0-1962.0724
387: , p5_a3 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 DATE := fnd_api.g_miss_date

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 NUMBER := 0-1962.0724
387: , p5_a3 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 DATE := fnd_api.g_miss_date
392: , p5_a8 NUMBER := 0-1962.0724

Line 391: , p5_a7 DATE := fnd_api.g_miss_date

387: , p5_a3 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 DATE := fnd_api.g_miss_date
392: , p5_a8 NUMBER := 0-1962.0724
393: , p5_a9 DATE := fnd_api.g_miss_date
394: , p5_a10 NUMBER := 0-1962.0724
395: )

Line 393: , p5_a9 DATE := fnd_api.g_miss_date

389: , p5_a5 NUMBER := 0-1962.0724
390: , p5_a6 NUMBER := 0-1962.0724
391: , p5_a7 DATE := fnd_api.g_miss_date
392: , p5_a8 NUMBER := 0-1962.0724
393: , p5_a9 DATE := fnd_api.g_miss_date
394: , p5_a10 NUMBER := 0-1962.0724
395: )
396:
397: as