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
191:
345:
346:
347:
348:
349: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p11_a0
350: , p11_a1
351: );
352:
353:
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
464:
517:
518:
519:
520:
521: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
522: , p10_a1
523: );
524:
525:
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
634:
687:
688:
689:
690:
691: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
692: , p10_a1
693: );
694:
695:
810: )
811:
812: as
813: ddp_sales_team_tbl as_access_pub.sales_team_tbl_type;
814: ddp_profile_tbl as_utility_pub.profile_tbl_type;
815: ddindx binary_integer; indx binary_integer;
816: begin
817:
818: -- copy data to the local IN or IN-OUT args, if any
886:
887:
888:
889:
890: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
891: , p10_a1
892: );
893:
894:
954: , x_lead_id out nocopy NUMBER
955: )
956:
957: as
958: ddp_profile_tbl as_utility_pub.profile_tbl_type;
959: ddindx binary_integer; indx binary_integer;
960: begin
961:
962: -- copy data to the local IN or IN-OUT args, if any
979:
980:
981:
982:
983: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p20_a0
984: , p20_a1
985: );
986:
987:
1051: , p1_a4 out nocopy VARCHAR2
1052: )
1053:
1054: as
1055: ddp_profile_tbl as_utility_pub.profile_tbl_type;
1056: ddx_access_profile_rec as_access_pub.access_profile_rec_type;
1057: ddindx binary_integer; indx binary_integer;
1058: begin
1059:
1057: ddindx binary_integer; indx binary_integer;
1058: begin
1059:
1060: -- copy data to the local IN or IN-OUT args, if any
1061: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p0_a0
1062: , p0_a1
1063: );
1064:
1065:
1081: , p_profile_name VARCHAR2
1082: ) return varchar2
1083:
1084: as
1085: ddp_profile_tbl as_utility_pub.profile_tbl_type;
1086: ddindx binary_integer; indx binary_integer;
1087: ddrosetta_retval varchar2(4000);
1088: begin
1089:
1087: ddrosetta_retval varchar2(4000);
1088: begin
1089:
1090: -- copy data to the local IN or IN-OUT args, if any
1091: as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p0_a0
1092: , p0_a1
1093: );
1094:
1095: