1: package body as_opportunity_pub_w2 as
2: /* $Header: asxwop2b.pls 120.2 2005/08/04 03:06 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:
98: , x_msg_data out nocopy VARCHAR2
99: )
100:
101: as
102: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
103: ddp_profile_tbl as_utility_pub.profile_tbl_type;
104: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;
105: ddindx binary_integer; indx binary_integer;
106: begin
100:
101: as
102: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
103: ddp_profile_tbl as_utility_pub.profile_tbl_type;
104: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;
105: ddindx binary_integer; indx binary_integer;
106: begin
107:
108: -- copy data to the local IN or IN-OUT args, if any
110:
111:
112:
113:
114: as_opportunity_pub_w.rosetta_table_copy_in_p12(ddp_sales_credit_tbl, p5_a0
115: , p5_a1
116: , p5_a2
117: , p5_a3
118: , p5_a4
186:
187:
188:
189: -- here's the delegated call to the old PL/SQL routine
190: as_opportunity_pub.modify_sales_credits(p_api_version_number,
191: p_init_msg_list,
192: p_commit,
193: p_validation_level,
194: p_identity_salesforce_id,
214:
215:
216:
217:
218: as_opportunity_pub_w.rosetta_table_copy_out_p15(ddx_sales_credit_out_tbl, p11_a0
219: , p11_a1
220: );
221:
222:
302: , x_msg_data out nocopy VARCHAR2
303: )
304:
305: as
306: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
307: ddp_profile_tbl as_utility_pub.profile_tbl_type;
308: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;
309: ddindx binary_integer; indx binary_integer;
310: begin
304:
305: as
306: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
307: ddp_profile_tbl as_utility_pub.profile_tbl_type;
308: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;
309: ddindx binary_integer; indx binary_integer;
310: begin
311:
312: -- copy data to the local IN or IN-OUT args, if any
314:
315:
316:
317:
318: as_opportunity_pub_w.rosetta_table_copy_in_p12(ddp_sales_credit_tbl, p5_a0
319: , p5_a1
320: , p5_a2
321: , p5_a3
322: , p5_a4
390:
391:
392:
393: -- here's the delegated call to the old PL/SQL routine
394: as_opportunity_pub.delete_sales_credits(p_api_version_number,
395: p_init_msg_list,
396: p_commit,
397: p_validation_level,
398: p_identity_salesforce_id,
418:
419:
420:
421:
422: as_opportunity_pub_w.rosetta_table_copy_out_p15(ddx_sales_credit_out_tbl, p11_a0
423: , p11_a1
424: );
425:
426:
479: , x_msg_data out nocopy VARCHAR2
480: )
481:
482: as
483: ddp_obstacle_tbl as_opportunity_pub.obstacle_tbl_type;
484: ddp_profile_tbl as_utility_pub.profile_tbl_type;
485: ddx_obstacle_out_tbl as_opportunity_pub.obstacle_out_tbl_type;
486: ddindx binary_integer; indx binary_integer;
487: begin
481:
482: as
483: ddp_obstacle_tbl as_opportunity_pub.obstacle_tbl_type;
484: ddp_profile_tbl as_utility_pub.profile_tbl_type;
485: ddx_obstacle_out_tbl as_opportunity_pub.obstacle_out_tbl_type;
486: ddindx binary_integer; indx binary_integer;
487: begin
488:
489: -- copy data to the local IN or IN-OUT args, if any
491:
492:
493:
494:
495: as_opportunity_pub_w.rosetta_table_copy_in_p20(ddp_obstacle_tbl, p5_a0
496: , p5_a1
497: , p5_a2
498: , p5_a3
499: , p5_a4
540:
541:
542:
543: -- here's the delegated call to the old PL/SQL routine
544: as_opportunity_pub.create_obstacles(p_api_version_number,
545: p_init_msg_list,
546: p_commit,
547: p_validation_level,
548: p_identity_salesforce_id,
568:
569:
570:
571:
572: as_opportunity_pub_w.rosetta_table_copy_out_p23(ddx_obstacle_out_tbl, p11_a0
573: , p11_a1
574: );
575:
576:
629: , x_msg_data out nocopy VARCHAR2
630: )
631:
632: as
633: ddp_obstacle_tbl as_opportunity_pub.obstacle_tbl_type;
634: ddp_profile_tbl as_utility_pub.profile_tbl_type;
635: ddx_obstacle_out_tbl as_opportunity_pub.obstacle_out_tbl_type;
636: ddindx binary_integer; indx binary_integer;
637: begin
631:
632: as
633: ddp_obstacle_tbl as_opportunity_pub.obstacle_tbl_type;
634: ddp_profile_tbl as_utility_pub.profile_tbl_type;
635: ddx_obstacle_out_tbl as_opportunity_pub.obstacle_out_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
641:
642:
643:
644:
645: as_opportunity_pub_w.rosetta_table_copy_in_p20(ddp_obstacle_tbl, p5_a0
646: , p5_a1
647: , p5_a2
648: , p5_a3
649: , p5_a4
690:
691:
692:
693: -- here's the delegated call to the old PL/SQL routine
694: as_opportunity_pub.update_obstacles(p_api_version_number,
695: p_init_msg_list,
696: p_commit,
697: p_validation_level,
698: p_identity_salesforce_id,
718:
719:
720:
721:
722: as_opportunity_pub_w.rosetta_table_copy_out_p23(ddx_obstacle_out_tbl, p11_a0
723: , p11_a1
724: );
725:
726:
779: , x_msg_data out nocopy VARCHAR2
780: )
781:
782: as
783: ddp_obstacle_tbl as_opportunity_pub.obstacle_tbl_type;
784: ddp_profile_tbl as_utility_pub.profile_tbl_type;
785: ddx_obstacle_out_tbl as_opportunity_pub.obstacle_out_tbl_type;
786: ddindx binary_integer; indx binary_integer;
787: begin
781:
782: as
783: ddp_obstacle_tbl as_opportunity_pub.obstacle_tbl_type;
784: ddp_profile_tbl as_utility_pub.profile_tbl_type;
785: ddx_obstacle_out_tbl as_opportunity_pub.obstacle_out_tbl_type;
786: ddindx binary_integer; indx binary_integer;
787: begin
788:
789: -- copy data to the local IN or IN-OUT args, if any
791:
792:
793:
794:
795: as_opportunity_pub_w.rosetta_table_copy_in_p20(ddp_obstacle_tbl, p5_a0
796: , p5_a1
797: , p5_a2
798: , p5_a3
799: , p5_a4
840:
841:
842:
843: -- here's the delegated call to the old PL/SQL routine
844: as_opportunity_pub.delete_obstacles(p_api_version_number,
845: p_init_msg_list,
846: p_commit,
847: p_validation_level,
848: p_identity_salesforce_id,
868:
869:
870:
871:
872: as_opportunity_pub_w.rosetta_table_copy_out_p23(ddx_obstacle_out_tbl, p11_a0
873: , p11_a1
874: );
875:
876:
932: , x_msg_data out nocopy VARCHAR2
933: )
934:
935: as
936: ddp_lead_order_tbl as_opportunity_pub.order_tbl_type;
937: ddp_profile_tbl as_utility_pub.profile_tbl_type;
938: ddx_order_out_tbl as_opportunity_pub.order_out_tbl_type;
939: ddindx binary_integer; indx binary_integer;
940: begin
934:
935: as
936: ddp_lead_order_tbl as_opportunity_pub.order_tbl_type;
937: ddp_profile_tbl as_utility_pub.profile_tbl_type;
938: ddx_order_out_tbl as_opportunity_pub.order_out_tbl_type;
939: ddindx binary_integer; indx binary_integer;
940: begin
941:
942: -- copy data to the local IN or IN-OUT args, if any
944:
945:
946:
947:
948: as_opportunity_pub_w.rosetta_table_copy_in_p32(ddp_lead_order_tbl, p5_a0
949: , p5_a1
950: , p5_a2
951: , p5_a3
952: , p5_a4
996:
997:
998:
999: -- here's the delegated call to the old PL/SQL routine
1000: as_opportunity_pub.update_orders(p_api_version_number,
1001: p_init_msg_list,
1002: p_commit,
1003: p_validation_level,
1004: p_identity_salesforce_id,
1024:
1025:
1026:
1027:
1028: as_opportunity_pub_w.rosetta_table_copy_out_p35(ddx_order_out_tbl, p11_a0
1029: , p11_a1
1030: );
1031:
1032:
1088: , x_msg_data out nocopy VARCHAR2
1089: )
1090:
1091: as
1092: ddp_lead_order_tbl as_opportunity_pub.order_tbl_type;
1093: ddp_profile_tbl as_utility_pub.profile_tbl_type;
1094: ddx_order_out_tbl as_opportunity_pub.order_out_tbl_type;
1095: ddindx binary_integer; indx binary_integer;
1096: begin
1090:
1091: as
1092: ddp_lead_order_tbl as_opportunity_pub.order_tbl_type;
1093: ddp_profile_tbl as_utility_pub.profile_tbl_type;
1094: ddx_order_out_tbl as_opportunity_pub.order_out_tbl_type;
1095: ddindx binary_integer; indx binary_integer;
1096: begin
1097:
1098: -- copy data to the local IN or IN-OUT args, if any
1100:
1101:
1102:
1103:
1104: as_opportunity_pub_w.rosetta_table_copy_in_p32(ddp_lead_order_tbl, p5_a0
1105: , p5_a1
1106: , p5_a2
1107: , p5_a3
1108: , p5_a4
1152:
1153:
1154:
1155: -- here's the delegated call to the old PL/SQL routine
1156: as_opportunity_pub.delete_orders(p_api_version_number,
1157: p_init_msg_list,
1158: p_commit,
1159: p_validation_level,
1160: p_identity_salesforce_id,
1180:
1181:
1182:
1183:
1184: as_opportunity_pub_w.rosetta_table_copy_out_p35(ddx_order_out_tbl, p11_a0
1185: , p11_a1
1186: );
1187:
1188:
1246: , x_msg_data out nocopy VARCHAR2
1247: )
1248:
1249: as
1250: ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;
1251: ddp_profile_tbl as_utility_pub.profile_tbl_type;
1252: ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;
1253: ddindx binary_integer; indx binary_integer;
1254: begin
1248:
1249: as
1250: ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;
1251: ddp_profile_tbl as_utility_pub.profile_tbl_type;
1252: ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;
1253: ddindx binary_integer; indx binary_integer;
1254: begin
1255:
1256: -- copy data to the local IN or IN-OUT args, if any
1258:
1259:
1260:
1261:
1262: as_opportunity_pub_w.rosetta_table_copy_in_p26(ddp_competitor_tbl, p5_a0
1263: , p5_a1
1264: , p5_a2
1265: , p5_a3
1266: , p5_a4
1312:
1313:
1314:
1315: -- here's the delegated call to the old PL/SQL routine
1316: as_opportunity_pub.create_competitors(p_api_version_number,
1317: p_init_msg_list,
1318: p_commit,
1319: p_validation_level,
1320: p_identity_salesforce_id,
1340:
1341:
1342:
1343:
1344: as_opportunity_pub_w.rosetta_table_copy_out_p29(ddx_competitor_out_tbl, p11_a0
1345: , p11_a1
1346: );
1347:
1348:
1348:
1349:
1350: end;
1351:
1352: end as_opportunity_pub_w2;