1: package body as_opportunity_pub_w4 as
2: /* $Header: asxwop4b.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:
181: , p6_a99 NUMBER := 0-1962.0724
182: )
183:
184: as
185: ddp_contact_tbl as_opportunity_pub.contact_tbl_type;
186: ddp_header_rec as_opportunity_pub.header_rec_type;
187: ddp_profile_tbl as_utility_pub.profile_tbl_type;
188: ddx_contact_out_tbl as_opportunity_pub.contact_out_tbl_type;
189: ddindx binary_integer; indx binary_integer;
182: )
183:
184: as
185: ddp_contact_tbl as_opportunity_pub.contact_tbl_type;
186: ddp_header_rec as_opportunity_pub.header_rec_type;
187: ddp_profile_tbl as_utility_pub.profile_tbl_type;
188: ddx_contact_out_tbl as_opportunity_pub.contact_out_tbl_type;
189: ddindx binary_integer; indx binary_integer;
190: begin
184: as
185: ddp_contact_tbl as_opportunity_pub.contact_tbl_type;
186: ddp_header_rec as_opportunity_pub.header_rec_type;
187: ddp_profile_tbl as_utility_pub.profile_tbl_type;
188: ddx_contact_out_tbl as_opportunity_pub.contact_out_tbl_type;
189: ddindx binary_integer; indx binary_integer;
190: begin
191:
192: -- copy data to the local IN or IN-OUT args, if any
194:
195:
196:
197:
198: as_opportunity_pub_w.rosetta_table_copy_in_p38(ddp_contact_tbl, p5_a0
199: , p5_a1
200: , p5_a2
201: , p5_a3
202: , p5_a4
354:
355:
356:
357: -- here's the delegated call to the old PL/SQL routine
358: as_opportunity_pub.create_contacts(p_api_version_number,
359: p_init_msg_list,
360: p_commit,
361: p_validation_level,
362: p_identity_salesforce_id,
384:
385:
386:
387:
388: as_opportunity_pub_w.rosetta_table_copy_out_p41(ddx_contact_out_tbl, p12_a0
389: , p12_a1
390: );
391:
392:
455: , x_msg_data out nocopy VARCHAR2
456: )
457:
458: as
459: ddp_contact_tbl as_opportunity_pub.contact_tbl_type;
460: ddp_profile_tbl as_utility_pub.profile_tbl_type;
461: ddx_contact_out_tbl as_opportunity_pub.contact_out_tbl_type;
462: ddindx binary_integer; indx binary_integer;
463: begin
457:
458: as
459: ddp_contact_tbl as_opportunity_pub.contact_tbl_type;
460: ddp_profile_tbl as_utility_pub.profile_tbl_type;
461: ddx_contact_out_tbl as_opportunity_pub.contact_out_tbl_type;
462: ddindx binary_integer; indx binary_integer;
463: begin
464:
465: -- copy data to the local IN or IN-OUT args, if any
467:
468:
469:
470:
471: as_opportunity_pub_w.rosetta_table_copy_in_p38(ddp_contact_tbl, p5_a0
472: , p5_a1
473: , p5_a2
474: , p5_a3
475: , p5_a4
526:
527:
528:
529: -- here's the delegated call to the old PL/SQL routine
530: as_opportunity_pub.update_contacts(p_api_version_number,
531: p_init_msg_list,
532: p_commit,
533: p_validation_level,
534: p_identity_salesforce_id,
554:
555:
556:
557:
558: as_opportunity_pub_w.rosetta_table_copy_out_p41(ddx_contact_out_tbl, p11_a0
559: , p11_a1
560: );
561:
562:
625: , x_msg_data out nocopy VARCHAR2
626: )
627:
628: as
629: ddp_contact_tbl as_opportunity_pub.contact_tbl_type;
630: ddp_profile_tbl as_utility_pub.profile_tbl_type;
631: ddx_contact_out_tbl as_opportunity_pub.contact_out_tbl_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
627:
628: as
629: ddp_contact_tbl as_opportunity_pub.contact_tbl_type;
630: ddp_profile_tbl as_utility_pub.profile_tbl_type;
631: ddx_contact_out_tbl as_opportunity_pub.contact_out_tbl_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:
635: -- copy data to the local IN or IN-OUT args, if any
637:
638:
639:
640:
641: as_opportunity_pub_w.rosetta_table_copy_in_p38(ddp_contact_tbl, p5_a0
642: , p5_a1
643: , p5_a2
644: , p5_a3
645: , p5_a4
696:
697:
698:
699: -- here's the delegated call to the old PL/SQL routine
700: as_opportunity_pub.delete_contacts(p_api_version_number,
701: p_init_msg_list,
702: p_commit,
703: p_validation_level,
704: p_identity_salesforce_id,
724:
725:
726:
727:
728: as_opportunity_pub_w.rosetta_table_copy_out_p41(ddx_contact_out_tbl, p11_a0
729: , p11_a1
730: );
731:
732:
894:
895:
896:
897: -- here's the delegated call to the old PL/SQL routine
898: as_opportunity_pub.delete_salesteams(p_api_version_number,
899: p_init_msg_list,
900: p_commit,
901: p_validation_level,
902: ddp_sales_team_tbl,
988:
989:
990:
991: -- here's the delegated call to the old PL/SQL routine
992: as_opportunity_pub.copy_opportunity(p_api_version_number,
993: p_init_msg_list,
994: p_commit,
995: p_validation_level,
996: p_lead_id,
1063: );
1064:
1065:
1066: -- here's the delegated call to the old PL/SQL routine
1067: as_opportunity_pub.get_access_profiles(ddp_profile_tbl,
1068: ddx_access_profile_rec);
1069:
1070: -- copy data back from the local variables to OUT or IN-OUT args, if any
1071:
1093: );
1094:
1095:
1096: -- here's the delegated call to the old PL/SQL routine
1097: ddrosetta_retval := as_opportunity_pub.get_profile(ddp_profile_tbl,
1098: p_profile_name);
1099:
1100: -- copy data back from the local variables to OUT or IN-OUT args, if any
1101:
1102:
1103: return ddrosetta_retval;
1104: end;
1105:
1106: end as_opportunity_pub_w4;