APPS.AS_OPPORTUNITY_PUB_W4 dependencies on JTF_VARCHAR2_TABLE_100

Line 41: , p5_a14 JTF_VARCHAR2_TABLE_100

37: , p5_a10 JTF_NUMBER_TABLE
38: , p5_a11 JTF_NUMBER_TABLE
39: , p5_a12 JTF_NUMBER_TABLE
40: , p5_a13 JTF_NUMBER_TABLE
41: , p5_a14 JTF_VARCHAR2_TABLE_100
42: , p5_a15 JTF_VARCHAR2_TABLE_100
43: , p5_a16 JTF_VARCHAR2_TABLE_100
44: , p5_a17 JTF_VARCHAR2_TABLE_300
45: , p5_a18 JTF_NUMBER_TABLE

Line 42: , p5_a15 JTF_VARCHAR2_TABLE_100

38: , p5_a11 JTF_NUMBER_TABLE
39: , p5_a12 JTF_NUMBER_TABLE
40: , p5_a13 JTF_NUMBER_TABLE
41: , p5_a14 JTF_VARCHAR2_TABLE_100
42: , p5_a15 JTF_VARCHAR2_TABLE_100
43: , p5_a16 JTF_VARCHAR2_TABLE_100
44: , p5_a17 JTF_VARCHAR2_TABLE_300
45: , p5_a18 JTF_NUMBER_TABLE
46: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 43: , p5_a16 JTF_VARCHAR2_TABLE_100

39: , p5_a12 JTF_NUMBER_TABLE
40: , p5_a13 JTF_NUMBER_TABLE
41: , p5_a14 JTF_VARCHAR2_TABLE_100
42: , p5_a15 JTF_VARCHAR2_TABLE_100
43: , p5_a16 JTF_VARCHAR2_TABLE_100
44: , p5_a17 JTF_VARCHAR2_TABLE_300
45: , p5_a18 JTF_NUMBER_TABLE
46: , p5_a19 JTF_VARCHAR2_TABLE_100
47: , p5_a20 JTF_VARCHAR2_TABLE_100

Line 46: , p5_a19 JTF_VARCHAR2_TABLE_100

42: , p5_a15 JTF_VARCHAR2_TABLE_100
43: , p5_a16 JTF_VARCHAR2_TABLE_100
44: , p5_a17 JTF_VARCHAR2_TABLE_300
45: , p5_a18 JTF_NUMBER_TABLE
46: , p5_a19 JTF_VARCHAR2_TABLE_100
47: , p5_a20 JTF_VARCHAR2_TABLE_100
48: , p5_a21 JTF_VARCHAR2_TABLE_100
49: , p5_a22 JTF_VARCHAR2_TABLE_100
50: , p5_a23 JTF_VARCHAR2_TABLE_100

Line 47: , p5_a20 JTF_VARCHAR2_TABLE_100

43: , p5_a16 JTF_VARCHAR2_TABLE_100
44: , p5_a17 JTF_VARCHAR2_TABLE_300
45: , p5_a18 JTF_NUMBER_TABLE
46: , p5_a19 JTF_VARCHAR2_TABLE_100
47: , p5_a20 JTF_VARCHAR2_TABLE_100
48: , p5_a21 JTF_VARCHAR2_TABLE_100
49: , p5_a22 JTF_VARCHAR2_TABLE_100
50: , p5_a23 JTF_VARCHAR2_TABLE_100
51: , p5_a24 JTF_NUMBER_TABLE

Line 48: , p5_a21 JTF_VARCHAR2_TABLE_100

44: , p5_a17 JTF_VARCHAR2_TABLE_300
45: , p5_a18 JTF_NUMBER_TABLE
46: , p5_a19 JTF_VARCHAR2_TABLE_100
47: , p5_a20 JTF_VARCHAR2_TABLE_100
48: , p5_a21 JTF_VARCHAR2_TABLE_100
49: , p5_a22 JTF_VARCHAR2_TABLE_100
50: , p5_a23 JTF_VARCHAR2_TABLE_100
51: , p5_a24 JTF_NUMBER_TABLE
52: , p5_a25 JTF_VARCHAR2_TABLE_100

Line 49: , p5_a22 JTF_VARCHAR2_TABLE_100

45: , p5_a18 JTF_NUMBER_TABLE
46: , p5_a19 JTF_VARCHAR2_TABLE_100
47: , p5_a20 JTF_VARCHAR2_TABLE_100
48: , p5_a21 JTF_VARCHAR2_TABLE_100
49: , p5_a22 JTF_VARCHAR2_TABLE_100
50: , p5_a23 JTF_VARCHAR2_TABLE_100
51: , p5_a24 JTF_NUMBER_TABLE
52: , p5_a25 JTF_VARCHAR2_TABLE_100
53: , p5_a26 JTF_VARCHAR2_TABLE_100

Line 50: , p5_a23 JTF_VARCHAR2_TABLE_100

46: , p5_a19 JTF_VARCHAR2_TABLE_100
47: , p5_a20 JTF_VARCHAR2_TABLE_100
48: , p5_a21 JTF_VARCHAR2_TABLE_100
49: , p5_a22 JTF_VARCHAR2_TABLE_100
50: , p5_a23 JTF_VARCHAR2_TABLE_100
51: , p5_a24 JTF_NUMBER_TABLE
52: , p5_a25 JTF_VARCHAR2_TABLE_100
53: , p5_a26 JTF_VARCHAR2_TABLE_100
54: , p5_a27 JTF_NUMBER_TABLE

Line 52: , p5_a25 JTF_VARCHAR2_TABLE_100

48: , p5_a21 JTF_VARCHAR2_TABLE_100
49: , p5_a22 JTF_VARCHAR2_TABLE_100
50: , p5_a23 JTF_VARCHAR2_TABLE_100
51: , p5_a24 JTF_NUMBER_TABLE
52: , p5_a25 JTF_VARCHAR2_TABLE_100
53: , p5_a26 JTF_VARCHAR2_TABLE_100
54: , p5_a27 JTF_NUMBER_TABLE
55: , p5_a28 JTF_VARCHAR2_TABLE_100
56: , p5_a29 JTF_VARCHAR2_TABLE_200

Line 53: , p5_a26 JTF_VARCHAR2_TABLE_100

49: , p5_a22 JTF_VARCHAR2_TABLE_100
50: , p5_a23 JTF_VARCHAR2_TABLE_100
51: , p5_a24 JTF_NUMBER_TABLE
52: , p5_a25 JTF_VARCHAR2_TABLE_100
53: , p5_a26 JTF_VARCHAR2_TABLE_100
54: , p5_a27 JTF_NUMBER_TABLE
55: , p5_a28 JTF_VARCHAR2_TABLE_100
56: , p5_a29 JTF_VARCHAR2_TABLE_200
57: , p5_a30 JTF_VARCHAR2_TABLE_200

Line 55: , p5_a28 JTF_VARCHAR2_TABLE_100

51: , p5_a24 JTF_NUMBER_TABLE
52: , p5_a25 JTF_VARCHAR2_TABLE_100
53: , p5_a26 JTF_VARCHAR2_TABLE_100
54: , p5_a27 JTF_NUMBER_TABLE
55: , p5_a28 JTF_VARCHAR2_TABLE_100
56: , p5_a29 JTF_VARCHAR2_TABLE_200
57: , p5_a30 JTF_VARCHAR2_TABLE_200
58: , p5_a31 JTF_VARCHAR2_TABLE_200
59: , p5_a32 JTF_VARCHAR2_TABLE_200

Line 75: , p11_a0 JTF_VARCHAR2_TABLE_100

71: , p_check_access_flag VARCHAR2
72: , p_admin_flag VARCHAR2
73: , p_admin_group_id NUMBER
74: , p_partner_cont_party_id NUMBER
75: , p11_a0 JTF_VARCHAR2_TABLE_100
76: , p11_a1 JTF_VARCHAR2_TABLE_300
77: , p12_a0 out nocopy JTF_NUMBER_TABLE
78: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
79: , x_return_status out nocopy VARCHAR2

Line 78: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100

74: , p_partner_cont_party_id NUMBER
75: , p11_a0 JTF_VARCHAR2_TABLE_100
76: , p11_a1 JTF_VARCHAR2_TABLE_300
77: , p12_a0 out nocopy JTF_NUMBER_TABLE
78: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
79: , x_return_status out nocopy VARCHAR2
80: , x_msg_count out nocopy NUMBER
81: , x_msg_data out nocopy VARCHAR2
82: , p6_a0 DATE := fnd_api.g_miss_date

Line 415: , p5_a14 JTF_VARCHAR2_TABLE_100

411: , p5_a10 JTF_NUMBER_TABLE
412: , p5_a11 JTF_NUMBER_TABLE
413: , p5_a12 JTF_NUMBER_TABLE
414: , p5_a13 JTF_NUMBER_TABLE
415: , p5_a14 JTF_VARCHAR2_TABLE_100
416: , p5_a15 JTF_VARCHAR2_TABLE_100
417: , p5_a16 JTF_VARCHAR2_TABLE_100
418: , p5_a17 JTF_VARCHAR2_TABLE_300
419: , p5_a18 JTF_NUMBER_TABLE

Line 416: , p5_a15 JTF_VARCHAR2_TABLE_100

412: , p5_a11 JTF_NUMBER_TABLE
413: , p5_a12 JTF_NUMBER_TABLE
414: , p5_a13 JTF_NUMBER_TABLE
415: , p5_a14 JTF_VARCHAR2_TABLE_100
416: , p5_a15 JTF_VARCHAR2_TABLE_100
417: , p5_a16 JTF_VARCHAR2_TABLE_100
418: , p5_a17 JTF_VARCHAR2_TABLE_300
419: , p5_a18 JTF_NUMBER_TABLE
420: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 417: , p5_a16 JTF_VARCHAR2_TABLE_100

413: , p5_a12 JTF_NUMBER_TABLE
414: , p5_a13 JTF_NUMBER_TABLE
415: , p5_a14 JTF_VARCHAR2_TABLE_100
416: , p5_a15 JTF_VARCHAR2_TABLE_100
417: , p5_a16 JTF_VARCHAR2_TABLE_100
418: , p5_a17 JTF_VARCHAR2_TABLE_300
419: , p5_a18 JTF_NUMBER_TABLE
420: , p5_a19 JTF_VARCHAR2_TABLE_100
421: , p5_a20 JTF_VARCHAR2_TABLE_100

Line 420: , p5_a19 JTF_VARCHAR2_TABLE_100

416: , p5_a15 JTF_VARCHAR2_TABLE_100
417: , p5_a16 JTF_VARCHAR2_TABLE_100
418: , p5_a17 JTF_VARCHAR2_TABLE_300
419: , p5_a18 JTF_NUMBER_TABLE
420: , p5_a19 JTF_VARCHAR2_TABLE_100
421: , p5_a20 JTF_VARCHAR2_TABLE_100
422: , p5_a21 JTF_VARCHAR2_TABLE_100
423: , p5_a22 JTF_VARCHAR2_TABLE_100
424: , p5_a23 JTF_VARCHAR2_TABLE_100

Line 421: , p5_a20 JTF_VARCHAR2_TABLE_100

417: , p5_a16 JTF_VARCHAR2_TABLE_100
418: , p5_a17 JTF_VARCHAR2_TABLE_300
419: , p5_a18 JTF_NUMBER_TABLE
420: , p5_a19 JTF_VARCHAR2_TABLE_100
421: , p5_a20 JTF_VARCHAR2_TABLE_100
422: , p5_a21 JTF_VARCHAR2_TABLE_100
423: , p5_a22 JTF_VARCHAR2_TABLE_100
424: , p5_a23 JTF_VARCHAR2_TABLE_100
425: , p5_a24 JTF_NUMBER_TABLE

Line 422: , p5_a21 JTF_VARCHAR2_TABLE_100

418: , p5_a17 JTF_VARCHAR2_TABLE_300
419: , p5_a18 JTF_NUMBER_TABLE
420: , p5_a19 JTF_VARCHAR2_TABLE_100
421: , p5_a20 JTF_VARCHAR2_TABLE_100
422: , p5_a21 JTF_VARCHAR2_TABLE_100
423: , p5_a22 JTF_VARCHAR2_TABLE_100
424: , p5_a23 JTF_VARCHAR2_TABLE_100
425: , p5_a24 JTF_NUMBER_TABLE
426: , p5_a25 JTF_VARCHAR2_TABLE_100

Line 423: , p5_a22 JTF_VARCHAR2_TABLE_100

419: , p5_a18 JTF_NUMBER_TABLE
420: , p5_a19 JTF_VARCHAR2_TABLE_100
421: , p5_a20 JTF_VARCHAR2_TABLE_100
422: , p5_a21 JTF_VARCHAR2_TABLE_100
423: , p5_a22 JTF_VARCHAR2_TABLE_100
424: , p5_a23 JTF_VARCHAR2_TABLE_100
425: , p5_a24 JTF_NUMBER_TABLE
426: , p5_a25 JTF_VARCHAR2_TABLE_100
427: , p5_a26 JTF_VARCHAR2_TABLE_100

Line 424: , p5_a23 JTF_VARCHAR2_TABLE_100

420: , p5_a19 JTF_VARCHAR2_TABLE_100
421: , p5_a20 JTF_VARCHAR2_TABLE_100
422: , p5_a21 JTF_VARCHAR2_TABLE_100
423: , p5_a22 JTF_VARCHAR2_TABLE_100
424: , p5_a23 JTF_VARCHAR2_TABLE_100
425: , p5_a24 JTF_NUMBER_TABLE
426: , p5_a25 JTF_VARCHAR2_TABLE_100
427: , p5_a26 JTF_VARCHAR2_TABLE_100
428: , p5_a27 JTF_NUMBER_TABLE

Line 426: , p5_a25 JTF_VARCHAR2_TABLE_100

422: , p5_a21 JTF_VARCHAR2_TABLE_100
423: , p5_a22 JTF_VARCHAR2_TABLE_100
424: , p5_a23 JTF_VARCHAR2_TABLE_100
425: , p5_a24 JTF_NUMBER_TABLE
426: , p5_a25 JTF_VARCHAR2_TABLE_100
427: , p5_a26 JTF_VARCHAR2_TABLE_100
428: , p5_a27 JTF_NUMBER_TABLE
429: , p5_a28 JTF_VARCHAR2_TABLE_100
430: , p5_a29 JTF_VARCHAR2_TABLE_200

Line 427: , p5_a26 JTF_VARCHAR2_TABLE_100

423: , p5_a22 JTF_VARCHAR2_TABLE_100
424: , p5_a23 JTF_VARCHAR2_TABLE_100
425: , p5_a24 JTF_NUMBER_TABLE
426: , p5_a25 JTF_VARCHAR2_TABLE_100
427: , p5_a26 JTF_VARCHAR2_TABLE_100
428: , p5_a27 JTF_NUMBER_TABLE
429: , p5_a28 JTF_VARCHAR2_TABLE_100
430: , p5_a29 JTF_VARCHAR2_TABLE_200
431: , p5_a30 JTF_VARCHAR2_TABLE_200

Line 429: , p5_a28 JTF_VARCHAR2_TABLE_100

425: , p5_a24 JTF_NUMBER_TABLE
426: , p5_a25 JTF_VARCHAR2_TABLE_100
427: , p5_a26 JTF_VARCHAR2_TABLE_100
428: , p5_a27 JTF_NUMBER_TABLE
429: , p5_a28 JTF_VARCHAR2_TABLE_100
430: , p5_a29 JTF_VARCHAR2_TABLE_200
431: , p5_a30 JTF_VARCHAR2_TABLE_200
432: , p5_a31 JTF_VARCHAR2_TABLE_200
433: , p5_a32 JTF_VARCHAR2_TABLE_200

Line 449: , p10_a0 JTF_VARCHAR2_TABLE_100

445: , p_check_access_flag VARCHAR2
446: , p_admin_flag VARCHAR2
447: , p_admin_group_id NUMBER
448: , p_partner_cont_party_id NUMBER
449: , p10_a0 JTF_VARCHAR2_TABLE_100
450: , p10_a1 JTF_VARCHAR2_TABLE_300
451: , p11_a0 out nocopy JTF_NUMBER_TABLE
452: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
453: , x_return_status out nocopy VARCHAR2

Line 452: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

448: , p_partner_cont_party_id NUMBER
449: , p10_a0 JTF_VARCHAR2_TABLE_100
450: , p10_a1 JTF_VARCHAR2_TABLE_300
451: , p11_a0 out nocopy JTF_NUMBER_TABLE
452: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
453: , x_return_status out nocopy VARCHAR2
454: , x_msg_count out nocopy NUMBER
455: , x_msg_data out nocopy VARCHAR2
456: )

Line 585: , p5_a14 JTF_VARCHAR2_TABLE_100

581: , p5_a10 JTF_NUMBER_TABLE
582: , p5_a11 JTF_NUMBER_TABLE
583: , p5_a12 JTF_NUMBER_TABLE
584: , p5_a13 JTF_NUMBER_TABLE
585: , p5_a14 JTF_VARCHAR2_TABLE_100
586: , p5_a15 JTF_VARCHAR2_TABLE_100
587: , p5_a16 JTF_VARCHAR2_TABLE_100
588: , p5_a17 JTF_VARCHAR2_TABLE_300
589: , p5_a18 JTF_NUMBER_TABLE

Line 586: , p5_a15 JTF_VARCHAR2_TABLE_100

582: , p5_a11 JTF_NUMBER_TABLE
583: , p5_a12 JTF_NUMBER_TABLE
584: , p5_a13 JTF_NUMBER_TABLE
585: , p5_a14 JTF_VARCHAR2_TABLE_100
586: , p5_a15 JTF_VARCHAR2_TABLE_100
587: , p5_a16 JTF_VARCHAR2_TABLE_100
588: , p5_a17 JTF_VARCHAR2_TABLE_300
589: , p5_a18 JTF_NUMBER_TABLE
590: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 587: , p5_a16 JTF_VARCHAR2_TABLE_100

583: , p5_a12 JTF_NUMBER_TABLE
584: , p5_a13 JTF_NUMBER_TABLE
585: , p5_a14 JTF_VARCHAR2_TABLE_100
586: , p5_a15 JTF_VARCHAR2_TABLE_100
587: , p5_a16 JTF_VARCHAR2_TABLE_100
588: , p5_a17 JTF_VARCHAR2_TABLE_300
589: , p5_a18 JTF_NUMBER_TABLE
590: , p5_a19 JTF_VARCHAR2_TABLE_100
591: , p5_a20 JTF_VARCHAR2_TABLE_100

Line 590: , p5_a19 JTF_VARCHAR2_TABLE_100

586: , p5_a15 JTF_VARCHAR2_TABLE_100
587: , p5_a16 JTF_VARCHAR2_TABLE_100
588: , p5_a17 JTF_VARCHAR2_TABLE_300
589: , p5_a18 JTF_NUMBER_TABLE
590: , p5_a19 JTF_VARCHAR2_TABLE_100
591: , p5_a20 JTF_VARCHAR2_TABLE_100
592: , p5_a21 JTF_VARCHAR2_TABLE_100
593: , p5_a22 JTF_VARCHAR2_TABLE_100
594: , p5_a23 JTF_VARCHAR2_TABLE_100

Line 591: , p5_a20 JTF_VARCHAR2_TABLE_100

587: , p5_a16 JTF_VARCHAR2_TABLE_100
588: , p5_a17 JTF_VARCHAR2_TABLE_300
589: , p5_a18 JTF_NUMBER_TABLE
590: , p5_a19 JTF_VARCHAR2_TABLE_100
591: , p5_a20 JTF_VARCHAR2_TABLE_100
592: , p5_a21 JTF_VARCHAR2_TABLE_100
593: , p5_a22 JTF_VARCHAR2_TABLE_100
594: , p5_a23 JTF_VARCHAR2_TABLE_100
595: , p5_a24 JTF_NUMBER_TABLE

Line 592: , p5_a21 JTF_VARCHAR2_TABLE_100

588: , p5_a17 JTF_VARCHAR2_TABLE_300
589: , p5_a18 JTF_NUMBER_TABLE
590: , p5_a19 JTF_VARCHAR2_TABLE_100
591: , p5_a20 JTF_VARCHAR2_TABLE_100
592: , p5_a21 JTF_VARCHAR2_TABLE_100
593: , p5_a22 JTF_VARCHAR2_TABLE_100
594: , p5_a23 JTF_VARCHAR2_TABLE_100
595: , p5_a24 JTF_NUMBER_TABLE
596: , p5_a25 JTF_VARCHAR2_TABLE_100

Line 593: , p5_a22 JTF_VARCHAR2_TABLE_100

589: , p5_a18 JTF_NUMBER_TABLE
590: , p5_a19 JTF_VARCHAR2_TABLE_100
591: , p5_a20 JTF_VARCHAR2_TABLE_100
592: , p5_a21 JTF_VARCHAR2_TABLE_100
593: , p5_a22 JTF_VARCHAR2_TABLE_100
594: , p5_a23 JTF_VARCHAR2_TABLE_100
595: , p5_a24 JTF_NUMBER_TABLE
596: , p5_a25 JTF_VARCHAR2_TABLE_100
597: , p5_a26 JTF_VARCHAR2_TABLE_100

Line 594: , p5_a23 JTF_VARCHAR2_TABLE_100

590: , p5_a19 JTF_VARCHAR2_TABLE_100
591: , p5_a20 JTF_VARCHAR2_TABLE_100
592: , p5_a21 JTF_VARCHAR2_TABLE_100
593: , p5_a22 JTF_VARCHAR2_TABLE_100
594: , p5_a23 JTF_VARCHAR2_TABLE_100
595: , p5_a24 JTF_NUMBER_TABLE
596: , p5_a25 JTF_VARCHAR2_TABLE_100
597: , p5_a26 JTF_VARCHAR2_TABLE_100
598: , p5_a27 JTF_NUMBER_TABLE

Line 596: , p5_a25 JTF_VARCHAR2_TABLE_100

592: , p5_a21 JTF_VARCHAR2_TABLE_100
593: , p5_a22 JTF_VARCHAR2_TABLE_100
594: , p5_a23 JTF_VARCHAR2_TABLE_100
595: , p5_a24 JTF_NUMBER_TABLE
596: , p5_a25 JTF_VARCHAR2_TABLE_100
597: , p5_a26 JTF_VARCHAR2_TABLE_100
598: , p5_a27 JTF_NUMBER_TABLE
599: , p5_a28 JTF_VARCHAR2_TABLE_100
600: , p5_a29 JTF_VARCHAR2_TABLE_200

Line 597: , p5_a26 JTF_VARCHAR2_TABLE_100

593: , p5_a22 JTF_VARCHAR2_TABLE_100
594: , p5_a23 JTF_VARCHAR2_TABLE_100
595: , p5_a24 JTF_NUMBER_TABLE
596: , p5_a25 JTF_VARCHAR2_TABLE_100
597: , p5_a26 JTF_VARCHAR2_TABLE_100
598: , p5_a27 JTF_NUMBER_TABLE
599: , p5_a28 JTF_VARCHAR2_TABLE_100
600: , p5_a29 JTF_VARCHAR2_TABLE_200
601: , p5_a30 JTF_VARCHAR2_TABLE_200

Line 599: , p5_a28 JTF_VARCHAR2_TABLE_100

595: , p5_a24 JTF_NUMBER_TABLE
596: , p5_a25 JTF_VARCHAR2_TABLE_100
597: , p5_a26 JTF_VARCHAR2_TABLE_100
598: , p5_a27 JTF_NUMBER_TABLE
599: , p5_a28 JTF_VARCHAR2_TABLE_100
600: , p5_a29 JTF_VARCHAR2_TABLE_200
601: , p5_a30 JTF_VARCHAR2_TABLE_200
602: , p5_a31 JTF_VARCHAR2_TABLE_200
603: , p5_a32 JTF_VARCHAR2_TABLE_200

Line 619: , p10_a0 JTF_VARCHAR2_TABLE_100

615: , p_check_access_flag VARCHAR2
616: , p_admin_flag VARCHAR2
617: , p_admin_group_id NUMBER
618: , p_partner_cont_party_id NUMBER
619: , p10_a0 JTF_VARCHAR2_TABLE_100
620: , p10_a1 JTF_VARCHAR2_TABLE_300
621: , p11_a0 out nocopy JTF_NUMBER_TABLE
622: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
623: , x_return_status out nocopy VARCHAR2

Line 622: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

618: , p_partner_cont_party_id NUMBER
619: , p10_a0 JTF_VARCHAR2_TABLE_100
620: , p10_a1 JTF_VARCHAR2_TABLE_300
621: , p11_a0 out nocopy JTF_NUMBER_TABLE
622: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
623: , x_return_status out nocopy VARCHAR2
624: , x_msg_count out nocopy NUMBER
625: , x_msg_data out nocopy VARCHAR2
626: )

Line 746: , p4_a6 JTF_VARCHAR2_TABLE_100

742: , p4_a2 JTF_NUMBER_TABLE
743: , p4_a3 JTF_DATE_TABLE
744: , p4_a4 JTF_NUMBER_TABLE
745: , p4_a5 JTF_NUMBER_TABLE
746: , p4_a6 JTF_VARCHAR2_TABLE_100
747: , p4_a7 JTF_VARCHAR2_TABLE_100
748: , p4_a8 JTF_VARCHAR2_TABLE_100
749: , p4_a9 JTF_NUMBER_TABLE
750: , p4_a10 JTF_NUMBER_TABLE

Line 747: , p4_a7 JTF_VARCHAR2_TABLE_100

743: , p4_a3 JTF_DATE_TABLE
744: , p4_a4 JTF_NUMBER_TABLE
745: , p4_a5 JTF_NUMBER_TABLE
746: , p4_a6 JTF_VARCHAR2_TABLE_100
747: , p4_a7 JTF_VARCHAR2_TABLE_100
748: , p4_a8 JTF_VARCHAR2_TABLE_100
749: , p4_a9 JTF_NUMBER_TABLE
750: , p4_a10 JTF_NUMBER_TABLE
751: , p4_a11 JTF_NUMBER_TABLE

Line 748: , p4_a8 JTF_VARCHAR2_TABLE_100

744: , p4_a4 JTF_NUMBER_TABLE
745: , p4_a5 JTF_NUMBER_TABLE
746: , p4_a6 JTF_VARCHAR2_TABLE_100
747: , p4_a7 JTF_VARCHAR2_TABLE_100
748: , p4_a8 JTF_VARCHAR2_TABLE_100
749: , p4_a9 JTF_NUMBER_TABLE
750: , p4_a10 JTF_NUMBER_TABLE
751: , p4_a11 JTF_NUMBER_TABLE
752: , p4_a12 JTF_NUMBER_TABLE

Line 754: , p4_a14 JTF_VARCHAR2_TABLE_100

750: , p4_a10 JTF_NUMBER_TABLE
751: , p4_a11 JTF_NUMBER_TABLE
752: , p4_a12 JTF_NUMBER_TABLE
753: , p4_a13 JTF_VARCHAR2_TABLE_300
754: , p4_a14 JTF_VARCHAR2_TABLE_100
755: , p4_a15 JTF_VARCHAR2_TABLE_100
756: , p4_a16 JTF_VARCHAR2_TABLE_300
757: , p4_a17 JTF_VARCHAR2_TABLE_100
758: , p4_a18 JTF_NUMBER_TABLE

Line 755: , p4_a15 JTF_VARCHAR2_TABLE_100

751: , p4_a11 JTF_NUMBER_TABLE
752: , p4_a12 JTF_NUMBER_TABLE
753: , p4_a13 JTF_VARCHAR2_TABLE_300
754: , p4_a14 JTF_VARCHAR2_TABLE_100
755: , p4_a15 JTF_VARCHAR2_TABLE_100
756: , p4_a16 JTF_VARCHAR2_TABLE_300
757: , p4_a17 JTF_VARCHAR2_TABLE_100
758: , p4_a18 JTF_NUMBER_TABLE
759: , p4_a19 JTF_VARCHAR2_TABLE_100

Line 757: , p4_a17 JTF_VARCHAR2_TABLE_100

753: , p4_a13 JTF_VARCHAR2_TABLE_300
754: , p4_a14 JTF_VARCHAR2_TABLE_100
755: , p4_a15 JTF_VARCHAR2_TABLE_100
756: , p4_a16 JTF_VARCHAR2_TABLE_300
757: , p4_a17 JTF_VARCHAR2_TABLE_100
758: , p4_a18 JTF_NUMBER_TABLE
759: , p4_a19 JTF_VARCHAR2_TABLE_100
760: , p4_a20 JTF_NUMBER_TABLE
761: , p4_a21 JTF_NUMBER_TABLE

Line 759: , p4_a19 JTF_VARCHAR2_TABLE_100

755: , p4_a15 JTF_VARCHAR2_TABLE_100
756: , p4_a16 JTF_VARCHAR2_TABLE_300
757: , p4_a17 JTF_VARCHAR2_TABLE_100
758: , p4_a18 JTF_NUMBER_TABLE
759: , p4_a19 JTF_VARCHAR2_TABLE_100
760: , p4_a20 JTF_NUMBER_TABLE
761: , p4_a21 JTF_NUMBER_TABLE
762: , p4_a22 JTF_VARCHAR2_TABLE_100
763: , p4_a23 JTF_VARCHAR2_TABLE_100

Line 762: , p4_a22 JTF_VARCHAR2_TABLE_100

758: , p4_a18 JTF_NUMBER_TABLE
759: , p4_a19 JTF_VARCHAR2_TABLE_100
760: , p4_a20 JTF_NUMBER_TABLE
761: , p4_a21 JTF_NUMBER_TABLE
762: , p4_a22 JTF_VARCHAR2_TABLE_100
763: , p4_a23 JTF_VARCHAR2_TABLE_100
764: , p4_a24 JTF_VARCHAR2_TABLE_100
765: , p4_a25 JTF_VARCHAR2_TABLE_100
766: , p4_a26 JTF_VARCHAR2_TABLE_100

Line 763: , p4_a23 JTF_VARCHAR2_TABLE_100

759: , p4_a19 JTF_VARCHAR2_TABLE_100
760: , p4_a20 JTF_NUMBER_TABLE
761: , p4_a21 JTF_NUMBER_TABLE
762: , p4_a22 JTF_VARCHAR2_TABLE_100
763: , p4_a23 JTF_VARCHAR2_TABLE_100
764: , p4_a24 JTF_VARCHAR2_TABLE_100
765: , p4_a25 JTF_VARCHAR2_TABLE_100
766: , p4_a26 JTF_VARCHAR2_TABLE_100
767: , p4_a27 JTF_VARCHAR2_TABLE_100

Line 764: , p4_a24 JTF_VARCHAR2_TABLE_100

760: , p4_a20 JTF_NUMBER_TABLE
761: , p4_a21 JTF_NUMBER_TABLE
762: , p4_a22 JTF_VARCHAR2_TABLE_100
763: , p4_a23 JTF_VARCHAR2_TABLE_100
764: , p4_a24 JTF_VARCHAR2_TABLE_100
765: , p4_a25 JTF_VARCHAR2_TABLE_100
766: , p4_a26 JTF_VARCHAR2_TABLE_100
767: , p4_a27 JTF_VARCHAR2_TABLE_100
768: , p4_a28 JTF_NUMBER_TABLE

Line 765: , p4_a25 JTF_VARCHAR2_TABLE_100

761: , p4_a21 JTF_NUMBER_TABLE
762: , p4_a22 JTF_VARCHAR2_TABLE_100
763: , p4_a23 JTF_VARCHAR2_TABLE_100
764: , p4_a24 JTF_VARCHAR2_TABLE_100
765: , p4_a25 JTF_VARCHAR2_TABLE_100
766: , p4_a26 JTF_VARCHAR2_TABLE_100
767: , p4_a27 JTF_VARCHAR2_TABLE_100
768: , p4_a28 JTF_NUMBER_TABLE
769: , p4_a29 JTF_NUMBER_TABLE

Line 766: , p4_a26 JTF_VARCHAR2_TABLE_100

762: , p4_a22 JTF_VARCHAR2_TABLE_100
763: , p4_a23 JTF_VARCHAR2_TABLE_100
764: , p4_a24 JTF_VARCHAR2_TABLE_100
765: , p4_a25 JTF_VARCHAR2_TABLE_100
766: , p4_a26 JTF_VARCHAR2_TABLE_100
767: , p4_a27 JTF_VARCHAR2_TABLE_100
768: , p4_a28 JTF_NUMBER_TABLE
769: , p4_a29 JTF_NUMBER_TABLE
770: , p4_a30 JTF_DATE_TABLE

Line 767: , p4_a27 JTF_VARCHAR2_TABLE_100

763: , p4_a23 JTF_VARCHAR2_TABLE_100
764: , p4_a24 JTF_VARCHAR2_TABLE_100
765: , p4_a25 JTF_VARCHAR2_TABLE_100
766: , p4_a26 JTF_VARCHAR2_TABLE_100
767: , p4_a27 JTF_VARCHAR2_TABLE_100
768: , p4_a28 JTF_NUMBER_TABLE
769: , p4_a29 JTF_NUMBER_TABLE
770: , p4_a30 JTF_DATE_TABLE
771: , p4_a31 JTF_VARCHAR2_TABLE_300

Line 774: , p4_a34 JTF_VARCHAR2_TABLE_100

770: , p4_a30 JTF_DATE_TABLE
771: , p4_a31 JTF_VARCHAR2_TABLE_300
772: , p4_a32 JTF_DATE_TABLE
773: , p4_a33 JTF_NUMBER_TABLE
774: , p4_a34 JTF_VARCHAR2_TABLE_100
775: , p4_a35 JTF_VARCHAR2_TABLE_100
776: , p4_a36 JTF_VARCHAR2_TABLE_200
777: , p4_a37 JTF_VARCHAR2_TABLE_200
778: , p4_a38 JTF_VARCHAR2_TABLE_200

Line 775: , p4_a35 JTF_VARCHAR2_TABLE_100

771: , p4_a31 JTF_VARCHAR2_TABLE_300
772: , p4_a32 JTF_DATE_TABLE
773: , p4_a33 JTF_NUMBER_TABLE
774: , p4_a34 JTF_VARCHAR2_TABLE_100
775: , p4_a35 JTF_VARCHAR2_TABLE_100
776: , p4_a36 JTF_VARCHAR2_TABLE_200
777: , p4_a37 JTF_VARCHAR2_TABLE_200
778: , p4_a38 JTF_VARCHAR2_TABLE_200
779: , p4_a39 JTF_VARCHAR2_TABLE_200

Line 791: , p4_a51 JTF_VARCHAR2_TABLE_100

787: , p4_a47 JTF_VARCHAR2_TABLE_200
788: , p4_a48 JTF_VARCHAR2_TABLE_200
789: , p4_a49 JTF_VARCHAR2_TABLE_200
790: , p4_a50 JTF_VARCHAR2_TABLE_200
791: , p4_a51 JTF_VARCHAR2_TABLE_100
792: , p4_a52 JTF_VARCHAR2_TABLE_100
793: , p4_a53 JTF_VARCHAR2_TABLE_100
794: , p4_a54 JTF_NUMBER_TABLE
795: , p4_a55 JTF_NUMBER_TABLE

Line 792: , p4_a52 JTF_VARCHAR2_TABLE_100

788: , p4_a48 JTF_VARCHAR2_TABLE_200
789: , p4_a49 JTF_VARCHAR2_TABLE_200
790: , p4_a50 JTF_VARCHAR2_TABLE_200
791: , p4_a51 JTF_VARCHAR2_TABLE_100
792: , p4_a52 JTF_VARCHAR2_TABLE_100
793: , p4_a53 JTF_VARCHAR2_TABLE_100
794: , p4_a54 JTF_NUMBER_TABLE
795: , p4_a55 JTF_NUMBER_TABLE
796: , p4_a56 JTF_VARCHAR2_TABLE_100

Line 793: , p4_a53 JTF_VARCHAR2_TABLE_100

789: , p4_a49 JTF_VARCHAR2_TABLE_200
790: , p4_a50 JTF_VARCHAR2_TABLE_200
791: , p4_a51 JTF_VARCHAR2_TABLE_100
792: , p4_a52 JTF_VARCHAR2_TABLE_100
793: , p4_a53 JTF_VARCHAR2_TABLE_100
794: , p4_a54 JTF_NUMBER_TABLE
795: , p4_a55 JTF_NUMBER_TABLE
796: , p4_a56 JTF_VARCHAR2_TABLE_100
797: , p4_a57 JTF_VARCHAR2_TABLE_100

Line 796: , p4_a56 JTF_VARCHAR2_TABLE_100

792: , p4_a52 JTF_VARCHAR2_TABLE_100
793: , p4_a53 JTF_VARCHAR2_TABLE_100
794: , p4_a54 JTF_NUMBER_TABLE
795: , p4_a55 JTF_NUMBER_TABLE
796: , p4_a56 JTF_VARCHAR2_TABLE_100
797: , p4_a57 JTF_VARCHAR2_TABLE_100
798: , p4_a58 JTF_VARCHAR2_TABLE_100
799: , p4_a59 JTF_VARCHAR2_TABLE_100
800: , p_check_access_flag VARCHAR2

Line 797: , p4_a57 JTF_VARCHAR2_TABLE_100

793: , p4_a53 JTF_VARCHAR2_TABLE_100
794: , p4_a54 JTF_NUMBER_TABLE
795: , p4_a55 JTF_NUMBER_TABLE
796: , p4_a56 JTF_VARCHAR2_TABLE_100
797: , p4_a57 JTF_VARCHAR2_TABLE_100
798: , p4_a58 JTF_VARCHAR2_TABLE_100
799: , p4_a59 JTF_VARCHAR2_TABLE_100
800: , p_check_access_flag VARCHAR2
801: , p_admin_flag VARCHAR2

Line 798: , p4_a58 JTF_VARCHAR2_TABLE_100

794: , p4_a54 JTF_NUMBER_TABLE
795: , p4_a55 JTF_NUMBER_TABLE
796: , p4_a56 JTF_VARCHAR2_TABLE_100
797: , p4_a57 JTF_VARCHAR2_TABLE_100
798: , p4_a58 JTF_VARCHAR2_TABLE_100
799: , p4_a59 JTF_VARCHAR2_TABLE_100
800: , p_check_access_flag VARCHAR2
801: , p_admin_flag VARCHAR2
802: , p_admin_group_id NUMBER

Line 799: , p4_a59 JTF_VARCHAR2_TABLE_100

795: , p4_a55 JTF_NUMBER_TABLE
796: , p4_a56 JTF_VARCHAR2_TABLE_100
797: , p4_a57 JTF_VARCHAR2_TABLE_100
798: , p4_a58 JTF_VARCHAR2_TABLE_100
799: , p4_a59 JTF_VARCHAR2_TABLE_100
800: , p_check_access_flag VARCHAR2
801: , p_admin_flag VARCHAR2
802: , p_admin_group_id NUMBER
803: , p_identity_salesforce_id NUMBER

Line 805: , p10_a0 JTF_VARCHAR2_TABLE_100

801: , p_admin_flag VARCHAR2
802: , p_admin_group_id NUMBER
803: , p_identity_salesforce_id NUMBER
804: , p_partner_cont_party_id NUMBER
805: , p10_a0 JTF_VARCHAR2_TABLE_100
806: , p10_a1 JTF_VARCHAR2_TABLE_300
807: , x_return_status out nocopy VARCHAR2
808: , x_msg_count out nocopy NUMBER
809: , x_msg_data out nocopy VARCHAR2

Line 949: , p20_a0 JTF_VARCHAR2_TABLE_100

945: , p_admin_group_id NUMBER
946: , p_identity_salesforce_id NUMBER
947: , p_salesgroup_id NUMBER
948: , p_partner_cont_party_id NUMBER
949: , p20_a0 JTF_VARCHAR2_TABLE_100
950: , p20_a1 JTF_VARCHAR2_TABLE_300
951: , x_return_status out nocopy VARCHAR2
952: , x_msg_count out nocopy NUMBER
953: , x_msg_data out nocopy VARCHAR2

Line 1045: procedure get_access_profiles(p0_a0 JTF_VARCHAR2_TABLE_100

1041:
1042:
1043: end;
1044:
1045: procedure get_access_profiles(p0_a0 JTF_VARCHAR2_TABLE_100
1046: , p0_a1 JTF_VARCHAR2_TABLE_300
1047: , p1_a0 out nocopy VARCHAR2
1048: , p1_a1 out nocopy VARCHAR2
1049: , p1_a2 out nocopy VARCHAR2

Line 1079: function get_profile(p0_a0 JTF_VARCHAR2_TABLE_100

1075: p1_a3 := ddx_access_profile_rec.mgr_update_profile_value;
1076: p1_a4 := ddx_access_profile_rec.admin_update_profile_value;
1077: end;
1078:
1079: function get_profile(p0_a0 JTF_VARCHAR2_TABLE_100
1080: , p0_a1 JTF_VARCHAR2_TABLE_300
1081: , p_profile_name VARCHAR2
1082: ) return varchar2
1083: