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_TERR_ASSIGN_PUB_W dependencies on JTF_NUMBER_TABLE

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100

Line 15: , a2 JTF_NUMBER_TABLE

11: end;
12:
13: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100

Line 23: , a10 JTF_NUMBER_TABLE

19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_500
27: , a14 JTF_VARCHAR2_TABLE_100

Line 24: , a11 JTF_NUMBER_TABLE

20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_500
27: , a14 JTF_VARCHAR2_TABLE_100
28: ) as

Line 61: , a1 out nocopy JTF_NUMBER_TABLE

57: end if;
58: end if;
59: end rosetta_table_copy_in_p15;
60: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a2 out nocopy JTF_NUMBER_TABLE

58: end if;
59: end rosetta_table_copy_in_p15;
60: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , a10 out nocopy JTF_NUMBER_TABLE

66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_NUMBER_TABLE
71: , a11 out nocopy JTF_NUMBER_TABLE
72: , a12 out nocopy JTF_VARCHAR2_TABLE_100
73: , a13 out nocopy JTF_VARCHAR2_TABLE_500
74: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 71: , a11 out nocopy JTF_NUMBER_TABLE

67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: , a10 out nocopy JTF_NUMBER_TABLE
71: , a11 out nocopy JTF_NUMBER_TABLE
72: , a12 out nocopy JTF_VARCHAR2_TABLE_100
73: , a13 out nocopy JTF_VARCHAR2_TABLE_500
74: , a14 out nocopy JTF_VARCHAR2_TABLE_100
75: ) as

Line 80: a1 := JTF_NUMBER_TABLE();

76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_VARCHAR2_TABLE_400();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();

Line 81: a2 := JTF_NUMBER_TABLE();

77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_VARCHAR2_TABLE_400();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_NUMBER_TABLE();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_VARCHAR2_TABLE_100();

Line 89: a10 := JTF_NUMBER_TABLE();

85: a6 := JTF_VARCHAR2_TABLE_100();
86: a7 := JTF_VARCHAR2_TABLE_100();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: a12 := JTF_VARCHAR2_TABLE_100();
92: a13 := JTF_VARCHAR2_TABLE_500();
93: a14 := JTF_VARCHAR2_TABLE_100();

Line 90: a11 := JTF_NUMBER_TABLE();

86: a7 := JTF_VARCHAR2_TABLE_100();
87: a8 := JTF_VARCHAR2_TABLE_100();
88: a9 := JTF_VARCHAR2_TABLE_100();
89: a10 := JTF_NUMBER_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: a12 := JTF_VARCHAR2_TABLE_100();
92: a13 := JTF_VARCHAR2_TABLE_500();
93: a14 := JTF_VARCHAR2_TABLE_100();
94: else

Line 96: a1 := JTF_NUMBER_TABLE();

92: a13 := JTF_VARCHAR2_TABLE_500();
93: a14 := JTF_VARCHAR2_TABLE_100();
94: else
95: a0 := JTF_VARCHAR2_TABLE_400();
96: a1 := JTF_NUMBER_TABLE();
97: a2 := JTF_NUMBER_TABLE();
98: a3 := JTF_VARCHAR2_TABLE_100();
99: a4 := JTF_VARCHAR2_TABLE_100();
100: a5 := JTF_VARCHAR2_TABLE_100();

Line 97: a2 := JTF_NUMBER_TABLE();

93: a14 := JTF_VARCHAR2_TABLE_100();
94: else
95: a0 := JTF_VARCHAR2_TABLE_400();
96: a1 := JTF_NUMBER_TABLE();
97: a2 := JTF_NUMBER_TABLE();
98: a3 := JTF_VARCHAR2_TABLE_100();
99: a4 := JTF_VARCHAR2_TABLE_100();
100: a5 := JTF_VARCHAR2_TABLE_100();
101: a6 := JTF_VARCHAR2_TABLE_100();

Line 105: a10 := JTF_NUMBER_TABLE();

101: a6 := JTF_VARCHAR2_TABLE_100();
102: a7 := JTF_VARCHAR2_TABLE_100();
103: a8 := JTF_VARCHAR2_TABLE_100();
104: a9 := JTF_VARCHAR2_TABLE_100();
105: a10 := JTF_NUMBER_TABLE();
106: a11 := JTF_NUMBER_TABLE();
107: a12 := JTF_VARCHAR2_TABLE_100();
108: a13 := JTF_VARCHAR2_TABLE_500();
109: a14 := JTF_VARCHAR2_TABLE_100();

Line 106: a11 := JTF_NUMBER_TABLE();

102: a7 := JTF_VARCHAR2_TABLE_100();
103: a8 := JTF_VARCHAR2_TABLE_100();
104: a9 := JTF_VARCHAR2_TABLE_100();
105: a10 := JTF_NUMBER_TABLE();
106: a11 := JTF_NUMBER_TABLE();
107: a12 := JTF_VARCHAR2_TABLE_100();
108: a13 := JTF_VARCHAR2_TABLE_500();
109: a14 := JTF_VARCHAR2_TABLE_100();
110: if t.count > 0 then

Line 288: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE) as

284: end if;
285: end if;
286: end rosetta_table_copy_out_p19;
287:
288: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE) as
289: ddindx binary_integer; indx binary_integer;
290: begin
291: if a0 is null then
292: t := null;

Line 312: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE) as

308: end loop;
309: end if;
310: end if;
311: end rosetta_table_copy_in_p22;
312: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE) as
313: ddindx binary_integer; indx binary_integer;
314: begin
315: if t is null then
316: a0 := null;

Line 318: a0 := JTF_NUMBER_TABLE();

314: begin
315: if t is null then
316: a0 := null;
317: elsif t.count = 0 then
318: a0 := JTF_NUMBER_TABLE();
319: else
320: a0 := JTF_NUMBER_TABLE();
321: if t.count > 0 then
322: a0.extend(t.count);

Line 320: a0 := JTF_NUMBER_TABLE();

316: a0 := null;
317: elsif t.count = 0 then
318: a0 := JTF_NUMBER_TABLE();
319: else
320: a0 := JTF_NUMBER_TABLE();
321: if t.count > 0 then
322: a0.extend(t.count);
323: ddindx := t.first;
324: indx := 1;

Line 337: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE) as

333: end if;
334: end if;
335: end rosetta_table_copy_out_p22;
336:
337: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE) as
338: ddindx binary_integer; indx binary_integer;
339: begin
340: if a0 is null then
341: t := null;

Line 361: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE) as

357: end loop;
358: end if;
359: end if;
360: end rosetta_table_copy_in_p23;
361: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE) as
362: ddindx binary_integer; indx binary_integer;
363: begin
364: if t is null then
365: a0 := null;

Line 367: a0 := JTF_NUMBER_TABLE();

363: begin
364: if t is null then
365: a0 := null;
366: elsif t.count = 0 then
367: a0 := JTF_NUMBER_TABLE();
368: else
369: a0 := JTF_NUMBER_TABLE();
370: if t.count > 0 then
371: a0.extend(t.count);

Line 369: a0 := JTF_NUMBER_TABLE();

365: a0 := null;
366: elsif t.count = 0 then
367: a0 := JTF_NUMBER_TABLE();
368: else
369: a0 := JTF_NUMBER_TABLE();
370: if t.count > 0 then
371: a0.extend(t.count);
372: ddindx := t.first;
373: indx := 1;

Line 435: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE) as

431: end if;
432: end if;
433: end rosetta_table_copy_out_p24;
434:
435: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE) as
436: ddindx binary_integer; indx binary_integer;
437: begin
438: if a0 is null then
439: t := null;

Line 459: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE) as

455: end loop;
456: end if;
457: end if;
458: end rosetta_table_copy_in_p25;
459: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE) as
460: ddindx binary_integer; indx binary_integer;
461: begin
462: if t is null then
463: a0 := null;

Line 465: a0 := JTF_NUMBER_TABLE();

461: begin
462: if t is null then
463: a0 := null;
464: elsif t.count = 0 then
465: a0 := JTF_NUMBER_TABLE();
466: else
467: a0 := JTF_NUMBER_TABLE();
468: if t.count > 0 then
469: a0.extend(t.count);

Line 467: a0 := JTF_NUMBER_TABLE();

463: a0 := null;
464: elsif t.count = 0 then
465: a0 := JTF_NUMBER_TABLE();
466: else
467: a0 := JTF_NUMBER_TABLE();
468: if t.count > 0 then
469: a0.extend(t.count);
470: ddindx := t.first;
471: indx := 1;

Line 484: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE

480: end if;
481: end if;
482: end rosetta_table_copy_out_p25;
483:
484: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE
485: ) as
486: ddindx binary_integer; indx binary_integer;
487: begin
488: if a0 is not null and a0.count > 0 then

Line 503: procedure rosetta_table_copy_out_p30(t pv_terr_assign_pub.prtnr_aces_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

499: end loop;
500: end if;
501: end if;
502: end rosetta_table_copy_in_p30;
503: procedure rosetta_table_copy_out_p30(t pv_terr_assign_pub.prtnr_aces_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
504: ) as
505: ddindx binary_integer; indx binary_integer;
506: begin
507: if t is null or t.count = 0 then

Line 508: a0 := JTF_NUMBER_TABLE();

504: ) as
505: ddindx binary_integer; indx binary_integer;
506: begin
507: if t is null or t.count = 0 then
508: a0 := JTF_NUMBER_TABLE();
509: else
510: a0 := JTF_NUMBER_TABLE();
511: if t.count > 0 then
512: a0.extend(t.count);

Line 510: a0 := JTF_NUMBER_TABLE();

506: begin
507: if t is null or t.count = 0 then
508: a0 := JTF_NUMBER_TABLE();
509: else
510: a0 := JTF_NUMBER_TABLE();
511: if t.count > 0 then
512: a0.extend(t.count);
513: ddindx := t.first;
514: indx := 1;

Line 529: , p2_a0 out nocopy JTF_NUMBER_TABLE

525: end rosetta_table_copy_out_p30;
526:
527: procedure get_res_from_team_group(p_resource_id NUMBER
528: , p_resource_type VARCHAR2
529: , p2_a0 out nocopy JTF_NUMBER_TABLE
530: , p2_a1 out nocopy JTF_NUMBER_TABLE
531: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
532: , p2_a3 out nocopy JTF_NUMBER_TABLE
533: )

Line 530: , p2_a1 out nocopy JTF_NUMBER_TABLE

526:
527: procedure get_res_from_team_group(p_resource_id NUMBER
528: , p_resource_type VARCHAR2
529: , p2_a0 out nocopy JTF_NUMBER_TABLE
530: , p2_a1 out nocopy JTF_NUMBER_TABLE
531: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
532: , p2_a3 out nocopy JTF_NUMBER_TABLE
533: )
534:

Line 532: , p2_a3 out nocopy JTF_NUMBER_TABLE

528: , p_resource_type VARCHAR2
529: , p2_a0 out nocopy JTF_NUMBER_TABLE
530: , p2_a1 out nocopy JTF_NUMBER_TABLE
531: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
532: , p2_a3 out nocopy JTF_NUMBER_TABLE
533: )
534:
535: as
536: ddx_resource_rec pv_terr_assign_pub.resourcerec;

Line 563: , p4_a1 out nocopy JTF_NUMBER_TABLE

559: , x_return_status out nocopy VARCHAR2
560: , x_msg_count out nocopy NUMBER
561: , x_msg_data out nocopy VARCHAR2
562: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_400
563: , p4_a1 out nocopy JTF_NUMBER_TABLE
564: , p4_a2 out nocopy JTF_NUMBER_TABLE
565: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
566: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 564: , p4_a2 out nocopy JTF_NUMBER_TABLE

560: , x_msg_count out nocopy NUMBER
561: , x_msg_data out nocopy VARCHAR2
562: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_400
563: , p4_a1 out nocopy JTF_NUMBER_TABLE
564: , p4_a2 out nocopy JTF_NUMBER_TABLE
565: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
566: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
567: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 572: , p4_a10 out nocopy JTF_NUMBER_TABLE

568: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
571: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
572: , p4_a10 out nocopy JTF_NUMBER_TABLE
573: , p4_a11 out nocopy JTF_NUMBER_TABLE
574: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
575: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500
576: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 573: , p4_a11 out nocopy JTF_NUMBER_TABLE

569: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
571: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
572: , p4_a10 out nocopy JTF_NUMBER_TABLE
573: , p4_a11 out nocopy JTF_NUMBER_TABLE
574: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
575: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500
576: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100
577: )

Line 631: , p11_a0 out nocopy JTF_NUMBER_TABLE

627: , p_login_user NUMBER
628: , x_return_status out nocopy VARCHAR2
629: , x_msg_count out nocopy NUMBER
630: , x_msg_data out nocopy VARCHAR2
631: , p11_a0 out nocopy JTF_NUMBER_TABLE
632: )
633:
634: as
635: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;

Line 691: , p8_a1 JTF_NUMBER_TABLE

687: , p_vad_partner_id NUMBER
688: , p_mode VARCHAR2
689: , p_login_user NUMBER
690: , p8_a0 JTF_VARCHAR2_TABLE_400
691: , p8_a1 JTF_NUMBER_TABLE
692: , p8_a2 JTF_NUMBER_TABLE
693: , p8_a3 JTF_VARCHAR2_TABLE_100
694: , p8_a4 JTF_VARCHAR2_TABLE_100
695: , p8_a5 JTF_VARCHAR2_TABLE_100

Line 692: , p8_a2 JTF_NUMBER_TABLE

688: , p_mode VARCHAR2
689: , p_login_user NUMBER
690: , p8_a0 JTF_VARCHAR2_TABLE_400
691: , p8_a1 JTF_NUMBER_TABLE
692: , p8_a2 JTF_NUMBER_TABLE
693: , p8_a3 JTF_VARCHAR2_TABLE_100
694: , p8_a4 JTF_VARCHAR2_TABLE_100
695: , p8_a5 JTF_VARCHAR2_TABLE_100
696: , p8_a6 JTF_VARCHAR2_TABLE_100

Line 700: , p8_a10 JTF_NUMBER_TABLE

696: , p8_a6 JTF_VARCHAR2_TABLE_100
697: , p8_a7 JTF_VARCHAR2_TABLE_100
698: , p8_a8 JTF_VARCHAR2_TABLE_100
699: , p8_a9 JTF_VARCHAR2_TABLE_100
700: , p8_a10 JTF_NUMBER_TABLE
701: , p8_a11 JTF_NUMBER_TABLE
702: , p8_a12 JTF_VARCHAR2_TABLE_100
703: , p8_a13 JTF_VARCHAR2_TABLE_500
704: , p8_a14 JTF_VARCHAR2_TABLE_100

Line 701: , p8_a11 JTF_NUMBER_TABLE

697: , p8_a7 JTF_VARCHAR2_TABLE_100
698: , p8_a8 JTF_VARCHAR2_TABLE_100
699: , p8_a9 JTF_VARCHAR2_TABLE_100
700: , p8_a10 JTF_NUMBER_TABLE
701: , p8_a11 JTF_NUMBER_TABLE
702: , p8_a12 JTF_VARCHAR2_TABLE_100
703: , p8_a13 JTF_VARCHAR2_TABLE_500
704: , p8_a14 JTF_VARCHAR2_TABLE_100
705: , x_return_status out nocopy VARCHAR2

Line 708: , p12_a0 out nocopy JTF_NUMBER_TABLE

704: , p8_a14 JTF_VARCHAR2_TABLE_100
705: , x_return_status out nocopy VARCHAR2
706: , x_msg_count out nocopy NUMBER
707: , x_msg_data out nocopy VARCHAR2
708: , p12_a0 out nocopy JTF_NUMBER_TABLE
709: )
710:
711: as
712: ddp_partner_qualifiers_tbl pv_terr_assign_pub.partner_qualifiers_tbl_type;

Line 790: , p11_a0 out nocopy JTF_NUMBER_TABLE

786: , p_partner_id NUMBER
787: , p_vad_partner_id NUMBER
788: , p_mode VARCHAR2
789: , p_login_user NUMBER
790: , p11_a0 out nocopy JTF_NUMBER_TABLE
791: )
792:
793: as
794: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;

Line 853: , p11_a1 JTF_NUMBER_TABLE

849: , p_vad_partner_id NUMBER
850: , p_mode VARCHAR2
851: , p_login_user NUMBER
852: , p11_a0 JTF_VARCHAR2_TABLE_400
853: , p11_a1 JTF_NUMBER_TABLE
854: , p11_a2 JTF_NUMBER_TABLE
855: , p11_a3 JTF_VARCHAR2_TABLE_100
856: , p11_a4 JTF_VARCHAR2_TABLE_100
857: , p11_a5 JTF_VARCHAR2_TABLE_100

Line 854: , p11_a2 JTF_NUMBER_TABLE

850: , p_mode VARCHAR2
851: , p_login_user NUMBER
852: , p11_a0 JTF_VARCHAR2_TABLE_400
853: , p11_a1 JTF_NUMBER_TABLE
854: , p11_a2 JTF_NUMBER_TABLE
855: , p11_a3 JTF_VARCHAR2_TABLE_100
856: , p11_a4 JTF_VARCHAR2_TABLE_100
857: , p11_a5 JTF_VARCHAR2_TABLE_100
858: , p11_a6 JTF_VARCHAR2_TABLE_100

Line 862: , p11_a10 JTF_NUMBER_TABLE

858: , p11_a6 JTF_VARCHAR2_TABLE_100
859: , p11_a7 JTF_VARCHAR2_TABLE_100
860: , p11_a8 JTF_VARCHAR2_TABLE_100
861: , p11_a9 JTF_VARCHAR2_TABLE_100
862: , p11_a10 JTF_NUMBER_TABLE
863: , p11_a11 JTF_NUMBER_TABLE
864: , p11_a12 JTF_VARCHAR2_TABLE_100
865: , p11_a13 JTF_VARCHAR2_TABLE_500
866: , p11_a14 JTF_VARCHAR2_TABLE_100

Line 863: , p11_a11 JTF_NUMBER_TABLE

859: , p11_a7 JTF_VARCHAR2_TABLE_100
860: , p11_a8 JTF_VARCHAR2_TABLE_100
861: , p11_a9 JTF_VARCHAR2_TABLE_100
862: , p11_a10 JTF_NUMBER_TABLE
863: , p11_a11 JTF_NUMBER_TABLE
864: , p11_a12 JTF_VARCHAR2_TABLE_100
865: , p11_a13 JTF_VARCHAR2_TABLE_500
866: , p11_a14 JTF_VARCHAR2_TABLE_100
867: , p12_a0 out nocopy JTF_NUMBER_TABLE

Line 867: , p12_a0 out nocopy JTF_NUMBER_TABLE

863: , p11_a11 JTF_NUMBER_TABLE
864: , p11_a12 JTF_VARCHAR2_TABLE_100
865: , p11_a13 JTF_VARCHAR2_TABLE_500
866: , p11_a14 JTF_VARCHAR2_TABLE_100
867: , p12_a0 out nocopy JTF_NUMBER_TABLE
868: )
869:
870: as
871: ddp_partner_qualifiers_tbl pv_terr_assign_pub.partner_qualifiers_tbl_type;

Line 947: , p9_a0 out nocopy JTF_NUMBER_TABLE

943: , x_msg_count out nocopy NUMBER
944: , x_msg_data out nocopy VARCHAR2
945: , p_partner_id NUMBER
946: , p_vad_partner_id NUMBER
947: , p9_a0 out nocopy JTF_NUMBER_TABLE
948: )
949:
950: as
951: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;

Line 1017: , p12_a0 out nocopy JTF_NUMBER_TABLE

1013: , p8_a13 VARCHAR2
1014: , x_return_status out nocopy VARCHAR2
1015: , x_msg_count out nocopy NUMBER
1016: , x_msg_data out nocopy VARCHAR2
1017: , p12_a0 out nocopy JTF_NUMBER_TABLE
1018: )
1019:
1020: as
1021: ddp_upd_prtnr_qflr_flg_rec pv_terr_assign_pub.prtnr_qflr_flg_rec_type;