APPS.AS_ACCESS_PUB_W2 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 has_updatepersonaccess(p_api_version_number NUMBER

Line 38: , p3_a0 VARCHAR2 := fnd_api.g_miss_char

34: , x_return_status out VARCHAR2
35: , x_msg_count out NUMBER
36: , x_msg_data out VARCHAR2
37: , x_update_access_flag out VARCHAR2
38: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
39: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
40: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
41: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
42: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

Line 39: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

35: , x_msg_count out NUMBER
36: , x_msg_data out VARCHAR2
37: , x_update_access_flag out VARCHAR2
38: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
39: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
40: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
41: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
42: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
43: )

Line 40: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

36: , x_msg_data out VARCHAR2
37: , x_update_access_flag out VARCHAR2
38: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
39: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
40: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
41: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
42: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
43: )
44:

Line 41: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

37: , x_update_access_flag out VARCHAR2
38: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
39: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
40: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
41: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
42: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
43: )
44:
45: as

Line 42: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

38: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
39: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
40: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
41: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
42: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
43: )
44:
45: as
46: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

Line 127: , p3_a0 VARCHAR2 := fnd_api.g_miss_char

123: , x_return_status out VARCHAR2
124: , x_msg_count out NUMBER
125: , x_msg_data out VARCHAR2
126: , x_view_access_flag out VARCHAR2
127: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
131: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

Line 128: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

124: , x_msg_count out NUMBER
125: , x_msg_data out VARCHAR2
126: , x_view_access_flag out VARCHAR2
127: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
131: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
132: )

Line 129: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

125: , x_msg_data out VARCHAR2
126: , x_view_access_flag out VARCHAR2
127: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
131: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
132: )
133:

Line 130: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

126: , x_view_access_flag out VARCHAR2
127: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
131: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
132: )
133:
134: as

Line 131: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

127: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
131: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
132: )
133:
134: as
135: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

Line 214: , p3_a0 VARCHAR2 := fnd_api.g_miss_char

210: , x_return_status out VARCHAR2
211: , x_msg_count out NUMBER
212: , x_msg_data out VARCHAR2
213: , x_view_access_flag out VARCHAR2
214: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
215: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
216: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
217: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
218: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

Line 215: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

211: , x_msg_count out NUMBER
212: , x_msg_data out VARCHAR2
213: , x_view_access_flag out VARCHAR2
214: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
215: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
216: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
217: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
218: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
219: )

Line 216: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

212: , x_msg_data out VARCHAR2
213: , x_view_access_flag out VARCHAR2
214: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
215: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
216: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
217: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
218: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
219: )
220:

Line 217: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

213: , x_view_access_flag out VARCHAR2
214: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
215: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
216: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
217: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
218: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
219: )
220:
221: as

Line 218: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

214: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
215: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
216: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
217: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
218: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
219: )
220:
221: as
222: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

Line 295: , p3_a0 VARCHAR2 := fnd_api.g_miss_char

291: , x_return_status out VARCHAR2
292: , x_msg_count out NUMBER
293: , x_msg_data out VARCHAR2
294: , x_view_access_flag out VARCHAR2
295: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
296: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
297: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
298: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
299: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

Line 296: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

292: , x_msg_count out NUMBER
293: , x_msg_data out VARCHAR2
294: , x_view_access_flag out VARCHAR2
295: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
296: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
297: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
298: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
299: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
300: )

Line 297: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

293: , x_msg_data out VARCHAR2
294: , x_view_access_flag out VARCHAR2
295: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
296: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
297: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
298: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
299: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
300: )
301:

Line 298: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

294: , x_view_access_flag out VARCHAR2
295: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
296: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
297: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
298: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
299: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
300: )
301:
302: as

Line 299: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

295: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
296: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
297: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
298: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
299: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
300: )
301:
302: as
303: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

Line 376: , p3_a0 VARCHAR2 := fnd_api.g_miss_char

372: , x_return_status out VARCHAR2
373: , x_msg_count out NUMBER
374: , x_msg_data out VARCHAR2
375: , x_access_privilege out VARCHAR2
376: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
377: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
378: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
379: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
380: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

Line 377: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

373: , x_msg_count out NUMBER
374: , x_msg_data out VARCHAR2
375: , x_access_privilege out VARCHAR2
376: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
377: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
378: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
379: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
380: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
381: )

Line 378: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

374: , x_msg_data out VARCHAR2
375: , x_access_privilege out VARCHAR2
376: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
377: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
378: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
379: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
380: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
381: )
382:

Line 379: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

375: , x_access_privilege out VARCHAR2
376: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
377: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
378: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
379: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
380: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
381: )
382:
383: as

Line 380: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

376: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
377: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
378: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
379: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
380: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
381: )
382:
383: as
384: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

Line 459: , p3_a0 VARCHAR2 := fnd_api.g_miss_char

455: , x_return_status out VARCHAR2
456: , x_msg_count out NUMBER
457: , x_msg_data out VARCHAR2
458: , x_access_privilege out VARCHAR2
459: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
460: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
461: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
462: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
463: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

Line 460: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

456: , x_msg_count out NUMBER
457: , x_msg_data out VARCHAR2
458: , x_access_privilege out VARCHAR2
459: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
460: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
461: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
462: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
463: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
464: )

Line 461: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

457: , x_msg_data out VARCHAR2
458: , x_access_privilege out VARCHAR2
459: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
460: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
461: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
462: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
463: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
464: )
465:

Line 462: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

458: , x_access_privilege out VARCHAR2
459: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
460: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
461: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
462: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
463: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
464: )
465:
466: as

Line 463: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

459: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
460: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
461: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
462: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
463: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
464: )
465:
466: as
467: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

Line 546: , p3_a0 VARCHAR2 := fnd_api.g_miss_char

542: , x_return_status out VARCHAR2
543: , x_msg_count out NUMBER
544: , x_msg_data out VARCHAR2
545: , x_access_privilege out VARCHAR2
546: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

Line 547: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

543: , x_msg_count out NUMBER
544: , x_msg_data out VARCHAR2
545: , x_access_privilege out VARCHAR2
546: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
551: )

Line 548: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

544: , x_msg_data out VARCHAR2
545: , x_access_privilege out VARCHAR2
546: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
551: )
552:

Line 549: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

545: , x_access_privilege out VARCHAR2
546: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
551: )
552:
553: as

Line 550: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

546: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
551: )
552:
553: as
554: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

Line 627: , p3_a0 VARCHAR2 := fnd_api.g_miss_char

623: , x_return_status out VARCHAR2
624: , x_msg_count out NUMBER
625: , x_msg_data out VARCHAR2
626: , x_access_privilege out VARCHAR2
627: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
628: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
629: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
630: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
631: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

Line 628: , p3_a1 VARCHAR2 := fnd_api.g_miss_char

624: , x_msg_count out NUMBER
625: , x_msg_data out VARCHAR2
626: , x_access_privilege out VARCHAR2
627: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
628: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
629: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
630: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
631: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
632: )

Line 629: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

625: , x_msg_data out VARCHAR2
626: , x_access_privilege out VARCHAR2
627: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
628: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
629: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
630: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
631: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
632: )
633:

Line 630: , p3_a3 VARCHAR2 := fnd_api.g_miss_char

626: , x_access_privilege out VARCHAR2
627: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
628: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
629: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
630: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
631: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
632: )
633:
634: as

Line 631: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

627: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
628: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
629: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
630: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
631: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
632: )
633:
634: as
635: ddp_access_profile_rec as_access_pub.access_profile_rec_type;