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.AS_OSI_LEAD_PUB_W dependencies on AS_OSI_LEAD_PUB

Line 1: package body as_osi_lead_pub_w as

1: package body as_osi_lead_pub_w as
2: /* $Header: asxolpab.pls 115.2 2002/12/10 01:32:14 kichan 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 22: procedure rosetta_table_copy_in_p2(t out nocopy as_osi_lead_pub.osi_tbl_type, a0 JTF_DATE_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy as_osi_lead_pub.osi_tbl_type, a0 JTF_DATE_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 123: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE

119: end loop;
120: end if;
121: end if;
122: end rosetta_table_copy_in_p2;
123: procedure rosetta_table_copy_out_p2(t as_osi_lead_pub.osi_tbl_type, a0 out nocopy JTF_DATE_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_DATE_TABLE
126: , a3 out nocopy JTF_VARCHAR2_TABLE_100
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 352: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100

348: end if;
349: end if;
350: end rosetta_table_copy_out_p2;
351:
352: procedure rosetta_table_copy_in_p6(t out nocopy as_osi_lead_pub.osi_cvb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
353: , a1 JTF_VARCHAR2_TABLE_100
354: ) as
355: ddindx binary_integer; indx binary_integer;
356: begin

Line 373: procedure rosetta_table_copy_out_p6(t as_osi_lead_pub.osi_cvb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

369: end loop;
370: end if;
371: end if;
372: end rosetta_table_copy_in_p6;
373: procedure rosetta_table_copy_out_p6(t as_osi_lead_pub.osi_cvb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
374: , a1 out nocopy JTF_VARCHAR2_TABLE_100
375: ) as
376: ddindx binary_integer; indx binary_integer;
377: begin

Line 402: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100

398: end if;
399: end if;
400: end rosetta_table_copy_out_p6;
401:
402: procedure rosetta_table_copy_in_p10(t out nocopy as_osi_lead_pub.osi_cnb_tbl_type, a0 JTF_VARCHAR2_TABLE_100
403: , a1 JTF_VARCHAR2_TABLE_100
404: , a2 JTF_VARCHAR2_TABLE_100
405: ) as
406: ddindx binary_integer; indx binary_integer;

Line 425: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

421: end loop;
422: end if;
423: end if;
424: end rosetta_table_copy_in_p10;
425: procedure rosetta_table_copy_out_p10(t as_osi_lead_pub.osi_cnb_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
426: , a1 out nocopy JTF_VARCHAR2_TABLE_100
427: , a2 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as
429: ddindx binary_integer; indx binary_integer;

Line 459: procedure rosetta_table_copy_in_p14(t out nocopy as_osi_lead_pub.osi_lkp_tbl_type, a0 JTF_VARCHAR2_TABLE_100

455: end if;
456: end if;
457: end rosetta_table_copy_out_p10;
458:
459: procedure rosetta_table_copy_in_p14(t out nocopy as_osi_lead_pub.osi_lkp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
460: , a1 JTF_VARCHAR2_TABLE_100
461: , a2 JTF_VARCHAR2_TABLE_200
462: ) as
463: ddindx binary_integer; indx binary_integer;

Line 482: procedure rosetta_table_copy_out_p14(t as_osi_lead_pub.osi_lkp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

478: end loop;
479: end if;
480: end if;
481: end rosetta_table_copy_in_p14;
482: procedure rosetta_table_copy_out_p14(t as_osi_lead_pub.osi_lkp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
483: , a1 out nocopy JTF_VARCHAR2_TABLE_100
484: , a2 out nocopy JTF_VARCHAR2_TABLE_200
485: ) as
486: ddindx binary_integer; indx binary_integer;

Line 516: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100

512: end if;
513: end if;
514: end rosetta_table_copy_out_p14;
515:
516: procedure rosetta_table_copy_in_p18(t out nocopy as_osi_lead_pub.osi_nam_tbl_type, a0 JTF_VARCHAR2_TABLE_100
517: , a1 JTF_VARCHAR2_TABLE_100
518: , a2 JTF_VARCHAR2_TABLE_100
519: ) as
520: ddindx binary_integer; indx binary_integer;

Line 539: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

535: end loop;
536: end if;
537: end if;
538: end rosetta_table_copy_in_p18;
539: procedure rosetta_table_copy_out_p18(t as_osi_lead_pub.osi_nam_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
540: , a1 out nocopy JTF_VARCHAR2_TABLE_100
541: , a2 out nocopy JTF_VARCHAR2_TABLE_100
542: ) as
543: ddindx binary_integer; indx binary_integer;

Line 573: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100

569: end if;
570: end if;
571: end rosetta_table_copy_out_p18;
572:
573: procedure rosetta_table_copy_in_p22(t out nocopy as_osi_lead_pub.osi_ccs_tbl_type, a0 JTF_VARCHAR2_TABLE_100
574: , a1 JTF_VARCHAR2_TABLE_100
575: ) as
576: ddindx binary_integer; indx binary_integer;
577: begin

Line 594: procedure rosetta_table_copy_out_p22(t as_osi_lead_pub.osi_ccs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

590: end loop;
591: end if;
592: end if;
593: end rosetta_table_copy_in_p22;
594: procedure rosetta_table_copy_out_p22(t as_osi_lead_pub.osi_ccs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
595: , a1 out nocopy JTF_VARCHAR2_TABLE_100
596: ) as
597: ddindx binary_integer; indx binary_integer;
598: begin

Line 623: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100

619: end if;
620: end if;
621: end rosetta_table_copy_out_p22;
622:
623: procedure rosetta_table_copy_in_p26(t out nocopy as_osi_lead_pub.osi_ovm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
624: , a1 JTF_VARCHAR2_TABLE_100
625: ) as
626: ddindx binary_integer; indx binary_integer;
627: begin

Line 644: procedure rosetta_table_copy_out_p26(t as_osi_lead_pub.osi_ovm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

640: end loop;
641: end if;
642: end if;
643: end rosetta_table_copy_in_p26;
644: procedure rosetta_table_copy_out_p26(t as_osi_lead_pub.osi_ovm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
645: , a1 out nocopy JTF_VARCHAR2_TABLE_100
646: ) as
647: ddindx binary_integer; indx binary_integer;
648: begin

Line 673: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100

669: end if;
670: end if;
671: end rosetta_table_copy_out_p26;
672:
673: procedure rosetta_table_copy_in_p30(t out nocopy as_osi_lead_pub.osi_ovd_tbl_type, a0 JTF_VARCHAR2_TABLE_100
674: , a1 JTF_VARCHAR2_TABLE_100
675: ) as
676: ddindx binary_integer; indx binary_integer;
677: begin

Line 694: procedure rosetta_table_copy_out_p30(t as_osi_lead_pub.osi_ovd_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

690: end loop;
691: end if;
692: end if;
693: end rosetta_table_copy_in_p30;
694: procedure rosetta_table_copy_out_p30(t as_osi_lead_pub.osi_ovd_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
695: , a1 out nocopy JTF_VARCHAR2_TABLE_100
696: ) as
697: ddindx binary_integer; indx binary_integer;
698: begin

Line 772: ddp_osi_rec as_osi_lead_pub.osi_rec_type;

768: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
769: )
770:
771: as
772: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
773: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;
774: ddindx binary_integer; indx binary_integer;
775: begin
776:

Line 773: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;

769: )
770:
771: as
772: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
773: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;
774: ddindx binary_integer; indx binary_integer;
775: begin
776:
777: -- copy data to the local IN or IN-OUT args, if any

Line 783: as_osi_lead_pub.osi_lead_fetch(p_api_version_number,

779:
780:
781:
782: -- here's the delegated call to the old PL/SQL routine
783: as_osi_lead_pub.osi_lead_fetch(p_api_version_number,
784: p_lead_id,
785: ddp_osi_rec,
786: ddp_osi_ovd_tbl);
787:

Line 834: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p3_a0

830: p2_a39 := ddp_osi_rec.cust_name;
831: p2_a40 := ddp_osi_rec.site_name;
832: p2_a41 := ddp_osi_rec.oppy_name;
833:
834: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p3_a0
835: , p3_a1
836: );
837: end;
838:

Line 903: ddp_osi_rec as_osi_lead_pub.osi_rec_type;

899: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
900: )
901:
902: as
903: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
904: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
905: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
906: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
907: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;

Line 904: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;

900: )
901:
902: as
903: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
904: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
905: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
906: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
907: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
908: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;

Line 905: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;

901:
902: as
903: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
904: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
905: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
906: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
907: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
908: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
909: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;

Line 906: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;

902: as
903: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
904: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
905: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
906: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
907: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
908: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
909: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;
910: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;

Line 907: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;

903: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
904: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
905: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
906: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
907: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
908: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
909: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;
910: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;
911: ddindx binary_integer; indx binary_integer;

Line 908: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;

904: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
905: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
906: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
907: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
908: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
909: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;
910: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;
911: ddindx binary_integer; indx binary_integer;
912: begin

Line 909: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;

905: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
906: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
907: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
908: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
909: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;
910: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;
911: ddindx binary_integer; indx binary_integer;
912: begin
913:

Line 910: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;

906: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
907: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
908: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
909: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;
910: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;
911: ddindx binary_integer; indx binary_integer;
912: begin
913:
914: -- copy data to the local IN or IN-OUT args, if any

Line 926: as_osi_lead_pub.osi_lead_fetch_all(p_api_version_number,

922:
923:
924:
925: -- here's the delegated call to the old PL/SQL routine
926: as_osi_lead_pub.osi_lead_fetch_all(p_api_version_number,
927: p_lead_id,
928: ddp_osi_rec,
929: ddp_osi_cvb_tbl,
930: ddp_osi_cnb_tbl,

Line 983: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p3_a0

979: p2_a39 := ddp_osi_rec.cust_name;
980: p2_a40 := ddp_osi_rec.site_name;
981: p2_a41 := ddp_osi_rec.oppy_name;
982:
983: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p3_a0
984: , p3_a1
985: );
986:
987: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p4_a0

Line 987: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p4_a0

983: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p3_a0
984: , p3_a1
985: );
986:
987: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p4_a0
988: , p4_a1
989: , p4_a2
990: );
991:

Line 992: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p5_a0

988: , p4_a1
989: , p4_a2
990: );
991:
992: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p5_a0
993: , p5_a1
994: , p5_a2
995: );
996:

Line 997: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p6_a0

993: , p5_a1
994: , p5_a2
995: );
996:
997: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p6_a0
998: , p6_a1
999: , p6_a2
1000: );
1001:

Line 1002: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p7_a0

998: , p6_a1
999: , p6_a2
1000: );
1001:
1002: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p7_a0
1003: , p7_a1
1004: );
1005:
1006: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p8_a0

Line 1006: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p8_a0

1002: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p7_a0
1003: , p7_a1
1004: );
1005:
1006: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p8_a0
1007: , p8_a1
1008: );
1009:
1010: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p9_a0

Line 1010: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p9_a0

1006: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p8_a0
1007: , p8_a1
1008: );
1009:
1010: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p9_a0
1011: , p9_a1
1012: );
1013: end;
1014:

Line 1034: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;

1030: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1031: )
1032:
1033: as
1034: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
1035: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
1036: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
1037: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
1038: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;

Line 1035: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;

1031: )
1032:
1033: as
1034: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
1035: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
1036: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
1037: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
1038: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
1039: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;

Line 1036: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;

1032:
1033: as
1034: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
1035: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
1036: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
1037: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
1038: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
1039: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;
1040: ddindx binary_integer; indx binary_integer;

Line 1037: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;

1033: as
1034: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
1035: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
1036: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
1037: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
1038: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
1039: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;
1040: ddindx binary_integer; indx binary_integer;
1041: begin

Line 1038: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;

1034: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
1035: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
1036: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
1037: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
1038: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
1039: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;
1040: ddindx binary_integer; indx binary_integer;
1041: begin
1042:

Line 1039: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;

1035: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
1036: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
1037: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
1038: ddp_osi_ccs_tbl as_osi_lead_pub.osi_ccs_tbl_type;
1039: ddp_osi_ovm_tbl as_osi_lead_pub.osi_ovm_tbl_type;
1040: ddindx binary_integer; indx binary_integer;
1041: begin
1042:
1043: -- copy data to the local IN or IN-OUT args, if any

Line 1052: as_osi_lead_pub.osi_lookup_fetch_all(p_api_version_number,

1048:
1049:
1050:
1051: -- here's the delegated call to the old PL/SQL routine
1052: as_osi_lead_pub.osi_lookup_fetch_all(p_api_version_number,
1053: ddp_osi_cvb_tbl,
1054: ddp_osi_cnb_tbl,
1055: ddp_osi_lkp_tbl,
1056: ddp_osi_nam_tbl,

Line 1062: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0

1058: ddp_osi_ovm_tbl);
1059:
1060: -- copy data back from the local variables to OUT or IN-OUT args, if any
1061:
1062: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0
1063: , p1_a1
1064: );
1065:
1066: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p2_a0

Line 1066: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p2_a0

1062: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0
1063: , p1_a1
1064: );
1065:
1066: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p2_a0
1067: , p2_a1
1068: , p2_a2
1069: );
1070:

Line 1071: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p3_a0

1067: , p2_a1
1068: , p2_a2
1069: );
1070:
1071: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p3_a0
1072: , p3_a1
1073: , p3_a2
1074: );
1075:

Line 1076: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p4_a0

1072: , p3_a1
1073: , p3_a2
1074: );
1075:
1076: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p4_a0
1077: , p4_a1
1078: , p4_a2
1079: );
1080:

Line 1081: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p5_a0

1077: , p4_a1
1078: , p4_a2
1079: );
1080:
1081: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p5_a0
1082: , p5_a1
1083: );
1084:
1085: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p6_a0

Line 1085: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p6_a0

1081: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p5_a0
1082: , p5_a1
1083: );
1084:
1085: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p6_a0
1086: , p6_a1
1087: );
1088: end;
1089:

Line 1143: ddp_osi_rec as_osi_lead_pub.osi_rec_type;

1139: , p3_a41 VARCHAR2 := fnd_api.g_miss_char
1140: )
1141:
1142: as
1143: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
1144: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;
1145: ddindx binary_integer; indx binary_integer;
1146: begin
1147:

Line 1144: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;

1140: )
1141:
1142: as
1143: ddp_osi_rec as_osi_lead_pub.osi_rec_type;
1144: ddp_osi_ovd_tbl as_osi_lead_pub.osi_ovd_tbl_type;
1145: ddindx binary_integer; indx binary_integer;
1146: begin
1147:
1148: -- copy data to the local IN or IN-OUT args, if any

Line 1195: as_osi_lead_pub_w.rosetta_table_copy_in_p30(ddp_osi_ovd_tbl, p4_a0

1191: ddp_osi_rec.cust_name := p3_a39;
1192: ddp_osi_rec.site_name := p3_a40;
1193: ddp_osi_rec.oppy_name := p3_a41;
1194:
1195: as_osi_lead_pub_w.rosetta_table_copy_in_p30(ddp_osi_ovd_tbl, p4_a0
1196: , p4_a1
1197: );
1198:
1199:

Line 1203: as_osi_lead_pub.osi_lead_update(p_api_version_number,

1199:
1200:
1201:
1202: -- here's the delegated call to the old PL/SQL routine
1203: as_osi_lead_pub.osi_lead_update(p_api_version_number,
1204: p_init_msg_list,
1205: p_commit,
1206: ddp_osi_rec,
1207: ddp_osi_ovd_tbl,

Line 1228: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;

1224: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
1225: )
1226:
1227: as
1228: ddp_osi_cvb_tbl as_osi_lead_pub.osi_cvb_tbl_type;
1229: ddindx binary_integer; indx binary_integer;
1230: begin
1231:
1232: -- copy data to the local IN or IN-OUT args, if any

Line 1236: as_osi_lead_pub.osi_cvb_fetch(p_api_version_number,

1232: -- copy data to the local IN or IN-OUT args, if any
1233:
1234:
1235: -- here's the delegated call to the old PL/SQL routine
1236: as_osi_lead_pub.osi_cvb_fetch(p_api_version_number,
1237: ddp_osi_cvb_tbl);
1238:
1239: -- copy data back from the local variables to OUT or IN-OUT args, if any
1240:

Line 1241: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0

1237: ddp_osi_cvb_tbl);
1238:
1239: -- copy data back from the local variables to OUT or IN-OUT args, if any
1240:
1241: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0
1242: , p1_a1
1243: );
1244: end;
1245:

Line 1253: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;

1249: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
1250: )
1251:
1252: as
1253: ddp_osi_cnb_tbl as_osi_lead_pub.osi_cnb_tbl_type;
1254: ddindx binary_integer; indx binary_integer;
1255: begin
1256:
1257: -- copy data to the local IN or IN-OUT args, if any

Line 1261: as_osi_lead_pub.osi_cnb_fetch(p_api_version_number,

1257: -- copy data to the local IN or IN-OUT args, if any
1258:
1259:
1260: -- here's the delegated call to the old PL/SQL routine
1261: as_osi_lead_pub.osi_cnb_fetch(p_api_version_number,
1262: ddp_osi_cnb_tbl);
1263:
1264: -- copy data back from the local variables to OUT or IN-OUT args, if any
1265:

Line 1266: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p1_a0

1262: ddp_osi_cnb_tbl);
1263:
1264: -- copy data back from the local variables to OUT or IN-OUT args, if any
1265:
1266: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p1_a0
1267: , p1_a1
1268: , p1_a2
1269: );
1270: end;

Line 1280: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;

1276: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
1277: )
1278:
1279: as
1280: ddp_osi_lkp_tbl as_osi_lead_pub.osi_lkp_tbl_type;
1281: ddindx binary_integer; indx binary_integer;
1282: begin
1283:
1284: -- copy data to the local IN or IN-OUT args, if any

Line 1289: as_osi_lead_pub.osi_lkp_fetch(p_api_version_number,

1285:
1286:
1287:
1288: -- here's the delegated call to the old PL/SQL routine
1289: as_osi_lead_pub.osi_lkp_fetch(p_api_version_number,
1290: p_osi_lkp_type,
1291: ddp_osi_lkp_tbl);
1292:
1293: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1296: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p2_a0

1292:
1293: -- copy data back from the local variables to OUT or IN-OUT args, if any
1294:
1295:
1296: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p2_a0
1297: , p2_a1
1298: , p2_a2
1299: );
1300: end;

Line 1310: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;

1306: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
1307: )
1308:
1309: as
1310: ddp_osi_nam_tbl as_osi_lead_pub.osi_nam_tbl_type;
1311: ddindx binary_integer; indx binary_integer;
1312: begin
1313:
1314: -- copy data to the local IN or IN-OUT args, if any

Line 1319: as_osi_lead_pub.osi_nam_fetch(p_api_version_number,

1315:
1316:
1317:
1318: -- here's the delegated call to the old PL/SQL routine
1319: as_osi_lead_pub.osi_nam_fetch(p_api_version_number,
1320: p_osi_nam_type,
1321: ddp_osi_nam_tbl);
1322:
1323: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1326: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p2_a0

1322:
1323: -- copy data back from the local variables to OUT or IN-OUT args, if any
1324:
1325:
1326: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p2_a0
1327: , p2_a1
1328: , p2_a2
1329: );
1330: end;

Line 1332: end as_osi_lead_pub_w;

1328: , p2_a2
1329: );
1330: end;
1331:
1332: end as_osi_lead_pub_w;