DBA Data[Home] [Help]

APPS.AS_OPPORTUNITY_PUB_W2 dependencies on AS_OPPORTUNITY_PUB

Line 1: package body as_opportunity_pub_w2 as

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:

Line 102: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;

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

Line 104: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;

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

Line 114: as_opportunity_pub_w.rosetta_table_copy_in_p12(ddp_sales_credit_tbl, p5_a0

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

Line 190: as_opportunity_pub.modify_sales_credits(p_api_version_number,

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,

Line 218: as_opportunity_pub_w.rosetta_table_copy_out_p15(ddx_sales_credit_out_tbl, p11_a0

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:

Line 306: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;

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

Line 308: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;

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

Line 318: as_opportunity_pub_w.rosetta_table_copy_in_p12(ddp_sales_credit_tbl, p5_a0

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

Line 394: as_opportunity_pub.delete_sales_credits(p_api_version_number,

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,

Line 422: as_opportunity_pub_w.rosetta_table_copy_out_p15(ddx_sales_credit_out_tbl, p11_a0

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:

Line 483: ddp_obstacle_tbl as_opportunity_pub.obstacle_tbl_type;

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

Line 485: ddx_obstacle_out_tbl as_opportunity_pub.obstacle_out_tbl_type;

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

Line 495: as_opportunity_pub_w.rosetta_table_copy_in_p20(ddp_obstacle_tbl, p5_a0

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

Line 544: as_opportunity_pub.create_obstacles(p_api_version_number,

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,

Line 572: as_opportunity_pub_w.rosetta_table_copy_out_p23(ddx_obstacle_out_tbl, p11_a0

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:

Line 633: ddp_obstacle_tbl as_opportunity_pub.obstacle_tbl_type;

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

Line 635: ddx_obstacle_out_tbl as_opportunity_pub.obstacle_out_tbl_type;

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

Line 645: as_opportunity_pub_w.rosetta_table_copy_in_p20(ddp_obstacle_tbl, p5_a0

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

Line 694: as_opportunity_pub.update_obstacles(p_api_version_number,

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,

Line 722: as_opportunity_pub_w.rosetta_table_copy_out_p23(ddx_obstacle_out_tbl, p11_a0

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:

Line 783: ddp_obstacle_tbl as_opportunity_pub.obstacle_tbl_type;

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

Line 785: ddx_obstacle_out_tbl as_opportunity_pub.obstacle_out_tbl_type;

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

Line 795: as_opportunity_pub_w.rosetta_table_copy_in_p20(ddp_obstacle_tbl, p5_a0

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

Line 844: as_opportunity_pub.delete_obstacles(p_api_version_number,

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,

Line 872: as_opportunity_pub_w.rosetta_table_copy_out_p23(ddx_obstacle_out_tbl, p11_a0

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:

Line 936: ddp_lead_order_tbl as_opportunity_pub.order_tbl_type;

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

Line 938: ddx_order_out_tbl as_opportunity_pub.order_out_tbl_type;

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

Line 948: as_opportunity_pub_w.rosetta_table_copy_in_p32(ddp_lead_order_tbl, p5_a0

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

Line 1000: as_opportunity_pub.update_orders(p_api_version_number,

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,

Line 1028: as_opportunity_pub_w.rosetta_table_copy_out_p35(ddx_order_out_tbl, p11_a0

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:

Line 1092: ddp_lead_order_tbl as_opportunity_pub.order_tbl_type;

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

Line 1094: ddx_order_out_tbl as_opportunity_pub.order_out_tbl_type;

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

Line 1104: as_opportunity_pub_w.rosetta_table_copy_in_p32(ddp_lead_order_tbl, p5_a0

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

Line 1156: as_opportunity_pub.delete_orders(p_api_version_number,

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,

Line 1184: as_opportunity_pub_w.rosetta_table_copy_out_p35(ddx_order_out_tbl, p11_a0

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:

Line 1250: ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;

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

Line 1252: ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;

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

Line 1262: as_opportunity_pub_w.rosetta_table_copy_in_p26(ddp_competitor_tbl, p5_a0

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

Line 1316: as_opportunity_pub.create_competitors(p_api_version_number,

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,

Line 1344: as_opportunity_pub_w.rosetta_table_copy_out_p29(ddx_competitor_out_tbl, p11_a0

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:

Line 1352: end as_opportunity_pub_w2;

1348:
1349:
1350: end;
1351:
1352: end as_opportunity_pub_w2;