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 PV_TERR_ASSIGN_PUB

Line 1: package body pv_terr_assign_pub_w as

1: package body pv_terr_assign_pub_w as
2: /* $Header: pvxwptab.pls 120.1 2005/08/10 01:44 appldev ship $ */
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:

Line 13: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
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

Line 60: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400

56: end loop;
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

Line 154: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100

150: end if;
151: end if;
152: end rosetta_table_copy_out_p15;
153:
154: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
155: , a1 JTF_VARCHAR2_TABLE_100
156: , a2 JTF_VARCHAR2_TABLE_100
157: , a3 JTF_VARCHAR2_TABLE_100
158: , a4 JTF_VARCHAR2_TABLE_100

Line 199: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

195: end loop;
196: end if;
197: end if;
198: end rosetta_table_copy_in_p19;
199: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , a1 out nocopy JTF_VARCHAR2_TABLE_100
201: , a2 out nocopy JTF_VARCHAR2_TABLE_100
202: , a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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 294: t := pv_terr_assign_pub.resourcelist();

290: begin
291: if a0 is null then
292: t := null;
293: elsif a0.count = 0 then
294: t := pv_terr_assign_pub.resourcelist();
295: else
296: if a0.count > 0 then
297: t := pv_terr_assign_pub.resourcelist();
298: t.extend(a0.count);

Line 297: t := pv_terr_assign_pub.resourcelist();

293: elsif a0.count = 0 then
294: t := pv_terr_assign_pub.resourcelist();
295: else
296: if a0.count > 0 then
297: t := pv_terr_assign_pub.resourcelist();
298: t.extend(a0.count);
299: indx := a0.first;
300: ddindx := 1;
301: while true loop

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 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 343: t := pv_terr_assign_pub.personlist();

339: begin
340: if a0 is null then
341: t := null;
342: elsif a0.count = 0 then
343: t := pv_terr_assign_pub.personlist();
344: else
345: if a0.count > 0 then
346: t := pv_terr_assign_pub.personlist();
347: t.extend(a0.count);

Line 346: t := pv_terr_assign_pub.personlist();

342: elsif a0.count = 0 then
343: t := pv_terr_assign_pub.personlist();
344: else
345: if a0.count > 0 then
346: t := pv_terr_assign_pub.personlist();
347: t.extend(a0.count);
348: indx := a0.first;
349: ddindx := 1;
350: while true loop

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 386: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100) as

382: end if;
383: end if;
384: end rosetta_table_copy_out_p23;
385:
386: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100) as
387: ddindx binary_integer; indx binary_integer;
388: begin
389: if a0 is null then
390: t := null;

Line 392: t := pv_terr_assign_pub.resourcecategorylist();

388: begin
389: if a0 is null then
390: t := null;
391: elsif a0.count = 0 then
392: t := pv_terr_assign_pub.resourcecategorylist();
393: else
394: if a0.count > 0 then
395: t := pv_terr_assign_pub.resourcecategorylist();
396: t.extend(a0.count);

Line 395: t := pv_terr_assign_pub.resourcecategorylist();

391: elsif a0.count = 0 then
392: t := pv_terr_assign_pub.resourcecategorylist();
393: else
394: if a0.count > 0 then
395: t := pv_terr_assign_pub.resourcecategorylist();
396: t.extend(a0.count);
397: indx := a0.first;
398: ddindx := 1;
399: while true loop

Line 410: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

406: end loop;
407: end if;
408: end if;
409: end rosetta_table_copy_in_p24;
410: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
411: ddindx binary_integer; indx binary_integer;
412: begin
413: if t is null then
414: a0 := null;

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 441: t := pv_terr_assign_pub.grouplist();

437: begin
438: if a0 is null then
439: t := null;
440: elsif a0.count = 0 then
441: t := pv_terr_assign_pub.grouplist();
442: else
443: if a0.count > 0 then
444: t := pv_terr_assign_pub.grouplist();
445: t.extend(a0.count);

Line 444: t := pv_terr_assign_pub.grouplist();

440: elsif a0.count = 0 then
441: t := pv_terr_assign_pub.grouplist();
442: else
443: if a0.count > 0 then
444: t := pv_terr_assign_pub.grouplist();
445: t.extend(a0.count);
446: indx := a0.first;
447: ddindx := 1;
448: while true loop

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 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 536: ddx_resource_rec pv_terr_assign_pub.resourcerec;

532: , p2_a3 out nocopy JTF_NUMBER_TABLE
533: )
534:
535: as
536: ddx_resource_rec pv_terr_assign_pub.resourcerec;
537: ddindx binary_integer; indx binary_integer;
538: begin
539:
540: -- copy data to the local IN or IN-OUT args, if any

Line 545: pv_terr_assign_pub.get_res_from_team_group(p_resource_id,

541:
542:
543:
544: -- here's the delegated call to the old PL/SQL routine
545: pv_terr_assign_pub.get_res_from_team_group(p_resource_id,
546: p_resource_type,
547: ddx_resource_rec);
548:
549: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 552: pv_terr_assign_pub_w.rosetta_table_copy_out_p22(ddx_resource_rec.resource_id, p2_a0);

548:
549: -- copy data back from the local variables to OUT or IN-OUT args, if any
550:
551:
552: pv_terr_assign_pub_w.rosetta_table_copy_out_p22(ddx_resource_rec.resource_id, p2_a0);
553: pv_terr_assign_pub_w.rosetta_table_copy_out_p23(ddx_resource_rec.person_id, p2_a1);
554: pv_terr_assign_pub_w.rosetta_table_copy_out_p24(ddx_resource_rec.resource_category, p2_a2);
555: pv_terr_assign_pub_w.rosetta_table_copy_out_p25(ddx_resource_rec.group_id, p2_a3);
556: end;

Line 553: pv_terr_assign_pub_w.rosetta_table_copy_out_p23(ddx_resource_rec.person_id, p2_a1);

549: -- copy data back from the local variables to OUT or IN-OUT args, if any
550:
551:
552: pv_terr_assign_pub_w.rosetta_table_copy_out_p22(ddx_resource_rec.resource_id, p2_a0);
553: pv_terr_assign_pub_w.rosetta_table_copy_out_p23(ddx_resource_rec.person_id, p2_a1);
554: pv_terr_assign_pub_w.rosetta_table_copy_out_p24(ddx_resource_rec.resource_category, p2_a2);
555: pv_terr_assign_pub_w.rosetta_table_copy_out_p25(ddx_resource_rec.group_id, p2_a3);
556: end;
557:

Line 554: pv_terr_assign_pub_w.rosetta_table_copy_out_p24(ddx_resource_rec.resource_category, p2_a2);

550:
551:
552: pv_terr_assign_pub_w.rosetta_table_copy_out_p22(ddx_resource_rec.resource_id, p2_a0);
553: pv_terr_assign_pub_w.rosetta_table_copy_out_p23(ddx_resource_rec.person_id, p2_a1);
554: pv_terr_assign_pub_w.rosetta_table_copy_out_p24(ddx_resource_rec.resource_category, p2_a2);
555: pv_terr_assign_pub_w.rosetta_table_copy_out_p25(ddx_resource_rec.group_id, p2_a3);
556: end;
557:
558: procedure get_partner_details(p_party_id NUMBER

Line 555: pv_terr_assign_pub_w.rosetta_table_copy_out_p25(ddx_resource_rec.group_id, p2_a3);

551:
552: pv_terr_assign_pub_w.rosetta_table_copy_out_p22(ddx_resource_rec.resource_id, p2_a0);
553: pv_terr_assign_pub_w.rosetta_table_copy_out_p23(ddx_resource_rec.person_id, p2_a1);
554: pv_terr_assign_pub_w.rosetta_table_copy_out_p24(ddx_resource_rec.resource_category, p2_a2);
555: pv_terr_assign_pub_w.rosetta_table_copy_out_p25(ddx_resource_rec.group_id, p2_a3);
556: end;
557:
558: procedure get_partner_details(p_party_id NUMBER
559: , x_return_status out nocopy VARCHAR2

Line 580: ddx_partner_qualifiers_tbl pv_terr_assign_pub.partner_qualifiers_tbl_type;

576: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100
577: )
578:
579: as
580: ddx_partner_qualifiers_tbl pv_terr_assign_pub.partner_qualifiers_tbl_type;
581: ddindx binary_integer; indx binary_integer;
582: begin
583:
584: -- copy data to the local IN or IN-OUT args, if any

Line 591: pv_terr_assign_pub.get_partner_details(p_party_id,

587:
588:
589:
590: -- here's the delegated call to the old PL/SQL routine
591: pv_terr_assign_pub.get_partner_details(p_party_id,
592: x_return_status,
593: x_msg_count,
594: x_msg_data,
595: ddx_partner_qualifiers_tbl);

Line 602: pv_terr_assign_pub_w.rosetta_table_copy_out_p15(ddx_partner_qualifiers_tbl, p4_a0

598:
599:
600:
601:
602: pv_terr_assign_pub_w.rosetta_table_copy_out_p15(ddx_partner_qualifiers_tbl, p4_a0
603: , p4_a1
604: , p4_a2
605: , p4_a3
606: , p4_a4

Line 635: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;

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;
636: ddindx binary_integer; indx binary_integer;
637: begin
638:
639: -- copy data to the local IN or IN-OUT args, if any

Line 653: pv_terr_assign_pub.create_channel_team(p_api_version_number,

649:
650:
651:
652: -- here's the delegated call to the old PL/SQL routine
653: pv_terr_assign_pub.create_channel_team(p_api_version_number,
654: p_init_msg_list,
655: p_commit,
656: p_validation_level,
657: p_partner_id,

Line 678: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p11_a0

674:
675:
676:
677:
678: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p11_a0
679: );
680: end;
681:
682: procedure do_create_channel_team(p_api_version_number NUMBER

Line 712: ddp_partner_qualifiers_tbl pv_terr_assign_pub.partner_qualifiers_tbl_type;

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;
713: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;
714: ddindx binary_integer; indx binary_integer;
715: begin
716:

Line 713: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;

709: )
710:
711: as
712: ddp_partner_qualifiers_tbl pv_terr_assign_pub.partner_qualifiers_tbl_type;
713: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;
714: ddindx binary_integer; indx binary_integer;
715: begin
716:
717: -- copy data to the local IN or IN-OUT args, if any

Line 726: pv_terr_assign_pub_w.rosetta_table_copy_in_p15(ddp_partner_qualifiers_tbl, p8_a0

722:
723:
724:
725:
726: pv_terr_assign_pub_w.rosetta_table_copy_in_p15(ddp_partner_qualifiers_tbl, p8_a0
727: , p8_a1
728: , p8_a2
729: , p8_a3
730: , p8_a4

Line 748: pv_terr_assign_pub.do_create_channel_team(p_api_version_number,

744:
745:
746:
747: -- here's the delegated call to the old PL/SQL routine
748: pv_terr_assign_pub.do_create_channel_team(p_api_version_number,
749: p_init_msg_list,
750: p_commit,
751: p_validation_level,
752: p_partner_id,

Line 775: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p12_a0

771:
772:
773:
774:
775: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p12_a0
776: );
777: end;
778:
779: procedure create_online_channel_team(p_api_version_number NUMBER

Line 794: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;

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;
795: ddindx binary_integer; indx binary_integer;
796: begin
797:
798: -- copy data to the local IN or IN-OUT args, if any

Line 812: pv_terr_assign_pub.create_online_channel_team(p_api_version_number,

808:
809:
810:
811: -- here's the delegated call to the old PL/SQL routine
812: pv_terr_assign_pub.create_online_channel_team(p_api_version_number,
813: p_init_msg_list,
814: p_commit,
815: p_validation_level,
816: x_return_status,

Line 837: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p11_a0

833:
834:
835:
836:
837: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p11_a0
838: );
839: end;
840:
841: procedure do_cr_online_chnl_team(p_api_version_number NUMBER

Line 871: ddp_partner_qualifiers_tbl pv_terr_assign_pub.partner_qualifiers_tbl_type;

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;
872: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;
873: ddindx binary_integer; indx binary_integer;
874: begin
875:

Line 872: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;

868: )
869:
870: as
871: ddp_partner_qualifiers_tbl pv_terr_assign_pub.partner_qualifiers_tbl_type;
872: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;
873: ddindx binary_integer; indx binary_integer;
874: begin
875:
876: -- copy data to the local IN or IN-OUT args, if any

Line 888: pv_terr_assign_pub_w.rosetta_table_copy_in_p15(ddp_partner_qualifiers_tbl, p11_a0

884:
885:
886:
887:
888: pv_terr_assign_pub_w.rosetta_table_copy_in_p15(ddp_partner_qualifiers_tbl, p11_a0
889: , p11_a1
890: , p11_a2
891: , p11_a3
892: , p11_a4

Line 907: pv_terr_assign_pub.do_cr_online_chnl_team(p_api_version_number,

903: );
904:
905:
906: -- here's the delegated call to the old PL/SQL routine
907: pv_terr_assign_pub.do_cr_online_chnl_team(p_api_version_number,
908: p_init_msg_list,
909: p_commit,
910: p_validation_level,
911: x_return_status,

Line 934: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p12_a0

930:
931:
932:
933:
934: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p12_a0
935: );
936: end;
937:
938: procedure create_vad_channel_team(p_api_version_number NUMBER

Line 951: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;

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;
952: ddindx binary_integer; indx binary_integer;
953: begin
954:
955: -- copy data to the local IN or IN-OUT args, if any

Line 967: pv_terr_assign_pub.create_vad_channel_team(p_api_version_number,

963:
964:
965:
966: -- here's the delegated call to the old PL/SQL routine
967: pv_terr_assign_pub.create_vad_channel_team(p_api_version_number,
968: p_init_msg_list,
969: p_commit,
970: p_validation_level,
971: x_return_status,

Line 988: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p9_a0

984:
985:
986:
987:
988: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p9_a0
989: );
990: end;
991:
992: procedure update_channel_team(p_api_version_number NUMBER

Line 1021: ddp_upd_prtnr_qflr_flg_rec pv_terr_assign_pub.prtnr_qflr_flg_rec_type;

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;
1022: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;
1023: ddindx binary_integer; indx binary_integer;
1024: begin
1025:

Line 1022: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;

1018: )
1019:
1020: as
1021: ddp_upd_prtnr_qflr_flg_rec pv_terr_assign_pub.prtnr_qflr_flg_rec_type;
1022: ddx_prtnr_access_id_tbl pv_terr_assign_pub.prtnr_aces_tbl_type;
1023: ddindx binary_integer; indx binary_integer;
1024: begin
1025:
1026: -- copy data to the local IN or IN-OUT args, if any

Line 1055: pv_terr_assign_pub.update_channel_team(p_api_version_number,

1051:
1052:
1053:
1054: -- here's the delegated call to the old PL/SQL routine
1055: pv_terr_assign_pub.update_channel_team(p_api_version_number,
1056: p_init_msg_list,
1057: p_commit,
1058: p_validation_level,
1059: p_partner_id,

Line 1082: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p12_a0

1078:
1079:
1080:
1081:
1082: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p12_a0
1083: );
1084: end;
1085:
1086: end pv_terr_assign_pub_w;

Line 1086: end pv_terr_assign_pub_w;

1082: pv_terr_assign_pub_w.rosetta_table_copy_out_p30(ddx_prtnr_access_id_tbl, p12_a0
1083: );
1084: end;
1085:
1086: end pv_terr_assign_pub_w;