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_OPPORTUNITY_PUB_W dependencies on AS_OPPORTUNITY_PUB

Line 1: package body as_opportunity_pub_w as

1: package body as_opportunity_pub_w as
2: /* $Header: asxwop1b.pls 120.1 2005/08/01 05:38 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 22: procedure rosetta_table_copy_in_p2(t out nocopy as_opportunity_pub.header_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_opportunity_pub.header_tbl_type, a0 JTF_DATE_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 239: procedure rosetta_table_copy_out_p2(t as_opportunity_pub.header_tbl_type, a0 out nocopy JTF_DATE_TABLE

235: end loop;
236: end if;
237: end if;
238: end rosetta_table_copy_in_p2;
239: procedure rosetta_table_copy_out_p2(t as_opportunity_pub.header_tbl_type, a0 out nocopy JTF_DATE_TABLE
240: , a1 out nocopy JTF_NUMBER_TABLE
241: , a2 out nocopy JTF_DATE_TABLE
242: , a3 out nocopy JTF_NUMBER_TABLE
243: , a4 out nocopy JTF_NUMBER_TABLE

Line 758: procedure rosetta_table_copy_in_p6(t out nocopy as_opportunity_pub.line_tbl_type, a0 JTF_DATE_TABLE

754: end if;
755: end if;
756: end rosetta_table_copy_out_p2;
757:
758: procedure rosetta_table_copy_in_p6(t out nocopy as_opportunity_pub.line_tbl_type, a0 JTF_DATE_TABLE
759: , a1 JTF_NUMBER_TABLE
760: , a2 JTF_DATE_TABLE
761: , a3 JTF_NUMBER_TABLE
762: , a4 JTF_NUMBER_TABLE

Line 913: procedure rosetta_table_copy_out_p6(t as_opportunity_pub.line_tbl_type, a0 out nocopy JTF_DATE_TABLE

909: end loop;
910: end if;
911: end if;
912: end rosetta_table_copy_in_p6;
913: procedure rosetta_table_copy_out_p6(t as_opportunity_pub.line_tbl_type, a0 out nocopy JTF_DATE_TABLE
914: , a1 out nocopy JTF_NUMBER_TABLE
915: , a2 out nocopy JTF_DATE_TABLE
916: , a3 out nocopy JTF_NUMBER_TABLE
917: , a4 out nocopy JTF_NUMBER_TABLE

Line 1277: procedure rosetta_table_copy_in_p9(t out nocopy as_opportunity_pub.line_out_tbl_type, a0 JTF_NUMBER_TABLE

1273: end if;
1274: end if;
1275: end rosetta_table_copy_out_p6;
1276:
1277: procedure rosetta_table_copy_in_p9(t out nocopy as_opportunity_pub.line_out_tbl_type, a0 JTF_NUMBER_TABLE
1278: , a1 JTF_VARCHAR2_TABLE_100
1279: ) as
1280: ddindx binary_integer; indx binary_integer;
1281: begin

Line 1298: procedure rosetta_table_copy_out_p9(t as_opportunity_pub.line_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1294: end loop;
1295: end if;
1296: end if;
1297: end rosetta_table_copy_in_p9;
1298: procedure rosetta_table_copy_out_p9(t as_opportunity_pub.line_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1299: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1300: ) as
1301: ddindx binary_integer; indx binary_integer;
1302: begin

Line 1327: procedure rosetta_table_copy_in_p12(t out nocopy as_opportunity_pub.sales_credit_tbl_type, a0 JTF_DATE_TABLE

1323: end if;
1324: end if;
1325: end rosetta_table_copy_out_p9;
1326:
1327: procedure rosetta_table_copy_in_p12(t out nocopy as_opportunity_pub.sales_credit_tbl_type, a0 JTF_DATE_TABLE
1328: , a1 JTF_NUMBER_TABLE
1329: , a2 JTF_DATE_TABLE
1330: , a3 JTF_NUMBER_TABLE
1331: , a4 JTF_NUMBER_TABLE

Line 1466: procedure rosetta_table_copy_out_p12(t as_opportunity_pub.sales_credit_tbl_type, a0 out nocopy JTF_DATE_TABLE

1462: end loop;
1463: end if;
1464: end if;
1465: end rosetta_table_copy_in_p12;
1466: procedure rosetta_table_copy_out_p12(t as_opportunity_pub.sales_credit_tbl_type, a0 out nocopy JTF_DATE_TABLE
1467: , a1 out nocopy JTF_NUMBER_TABLE
1468: , a2 out nocopy JTF_DATE_TABLE
1469: , a3 out nocopy JTF_NUMBER_TABLE
1470: , a4 out nocopy JTF_NUMBER_TABLE

Line 1790: procedure rosetta_table_copy_in_p15(t out nocopy as_opportunity_pub.sales_credit_out_tbl_type, a0 JTF_NUMBER_TABLE

1786: end if;
1787: end if;
1788: end rosetta_table_copy_out_p12;
1789:
1790: procedure rosetta_table_copy_in_p15(t out nocopy as_opportunity_pub.sales_credit_out_tbl_type, a0 JTF_NUMBER_TABLE
1791: , a1 JTF_VARCHAR2_TABLE_100
1792: ) as
1793: ddindx binary_integer; indx binary_integer;
1794: begin

Line 1811: procedure rosetta_table_copy_out_p15(t as_opportunity_pub.sales_credit_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1807: end loop;
1808: end if;
1809: end if;
1810: end rosetta_table_copy_in_p15;
1811: procedure rosetta_table_copy_out_p15(t as_opportunity_pub.sales_credit_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1812: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1813: ) as
1814: ddindx binary_integer; indx binary_integer;
1815: begin

Line 1840: procedure rosetta_table_copy_in_p20(t out nocopy as_opportunity_pub.obstacle_tbl_type, a0 JTF_DATE_TABLE

1836: end if;
1837: end if;
1838: end rosetta_table_copy_out_p15;
1839:
1840: procedure rosetta_table_copy_in_p20(t out nocopy as_opportunity_pub.obstacle_tbl_type, a0 JTF_DATE_TABLE
1841: , a1 JTF_NUMBER_TABLE
1842: , a2 JTF_DATE_TABLE
1843: , a3 JTF_NUMBER_TABLE
1844: , a4 JTF_NUMBER_TABLE

Line 1925: procedure rosetta_table_copy_out_p20(t as_opportunity_pub.obstacle_tbl_type, a0 out nocopy JTF_DATE_TABLE

1921: end loop;
1922: end if;
1923: end if;
1924: end rosetta_table_copy_in_p20;
1925: procedure rosetta_table_copy_out_p20(t as_opportunity_pub.obstacle_tbl_type, a0 out nocopy JTF_DATE_TABLE
1926: , a1 out nocopy JTF_NUMBER_TABLE
1927: , a2 out nocopy JTF_DATE_TABLE
1928: , a3 out nocopy JTF_NUMBER_TABLE
1929: , a4 out nocopy JTF_NUMBER_TABLE

Line 2114: procedure rosetta_table_copy_in_p23(t out nocopy as_opportunity_pub.obstacle_out_tbl_type, a0 JTF_NUMBER_TABLE

2110: end if;
2111: end if;
2112: end rosetta_table_copy_out_p20;
2113:
2114: procedure rosetta_table_copy_in_p23(t out nocopy as_opportunity_pub.obstacle_out_tbl_type, a0 JTF_NUMBER_TABLE
2115: , a1 JTF_VARCHAR2_TABLE_100
2116: ) as
2117: ddindx binary_integer; indx binary_integer;
2118: begin

Line 2135: procedure rosetta_table_copy_out_p23(t as_opportunity_pub.obstacle_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

2131: end loop;
2132: end if;
2133: end if;
2134: end rosetta_table_copy_in_p23;
2135: procedure rosetta_table_copy_out_p23(t as_opportunity_pub.obstacle_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2136: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2137: ) as
2138: ddindx binary_integer; indx binary_integer;
2139: begin

Line 2164: procedure rosetta_table_copy_in_p26(t out nocopy as_opportunity_pub.competitor_tbl_type, a0 JTF_DATE_TABLE

2160: end if;
2161: end if;
2162: end rosetta_table_copy_out_p23;
2163:
2164: procedure rosetta_table_copy_in_p26(t out nocopy as_opportunity_pub.competitor_tbl_type, a0 JTF_DATE_TABLE
2165: , a1 JTF_NUMBER_TABLE
2166: , a2 JTF_DATE_TABLE
2167: , a3 JTF_NUMBER_TABLE
2168: , a4 JTF_NUMBER_TABLE

Line 2259: procedure rosetta_table_copy_out_p26(t as_opportunity_pub.competitor_tbl_type, a0 out nocopy JTF_DATE_TABLE

2255: end loop;
2256: end if;
2257: end if;
2258: end rosetta_table_copy_in_p26;
2259: procedure rosetta_table_copy_out_p26(t as_opportunity_pub.competitor_tbl_type, a0 out nocopy JTF_DATE_TABLE
2260: , a1 out nocopy JTF_NUMBER_TABLE
2261: , a2 out nocopy JTF_DATE_TABLE
2262: , a3 out nocopy JTF_NUMBER_TABLE
2263: , a4 out nocopy JTF_NUMBER_TABLE

Line 2473: procedure rosetta_table_copy_in_p29(t out nocopy as_opportunity_pub.competitor_out_tbl_type, a0 JTF_NUMBER_TABLE

2469: end if;
2470: end if;
2471: end rosetta_table_copy_out_p26;
2472:
2473: procedure rosetta_table_copy_in_p29(t out nocopy as_opportunity_pub.competitor_out_tbl_type, a0 JTF_NUMBER_TABLE
2474: , a1 JTF_VARCHAR2_TABLE_100
2475: ) as
2476: ddindx binary_integer; indx binary_integer;
2477: begin

Line 2494: procedure rosetta_table_copy_out_p29(t as_opportunity_pub.competitor_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

2490: end loop;
2491: end if;
2492: end if;
2493: end rosetta_table_copy_in_p29;
2494: procedure rosetta_table_copy_out_p29(t as_opportunity_pub.competitor_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2495: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2496: ) as
2497: ddindx binary_integer; indx binary_integer;
2498: begin

Line 2523: procedure rosetta_table_copy_in_p32(t out nocopy as_opportunity_pub.order_tbl_type, a0 JTF_DATE_TABLE

2519: end if;
2520: end if;
2521: end rosetta_table_copy_out_p29;
2522:
2523: procedure rosetta_table_copy_in_p32(t out nocopy as_opportunity_pub.order_tbl_type, a0 JTF_DATE_TABLE
2524: , a1 JTF_NUMBER_TABLE
2525: , a2 JTF_DATE_TABLE
2526: , a3 JTF_NUMBER_TABLE
2527: , a4 JTF_NUMBER_TABLE

Line 2614: procedure rosetta_table_copy_out_p32(t as_opportunity_pub.order_tbl_type, a0 out nocopy JTF_DATE_TABLE

2610: end loop;
2611: end if;
2612: end if;
2613: end rosetta_table_copy_in_p32;
2614: procedure rosetta_table_copy_out_p32(t as_opportunity_pub.order_tbl_type, a0 out nocopy JTF_DATE_TABLE
2615: , a1 out nocopy JTF_NUMBER_TABLE
2616: , a2 out nocopy JTF_DATE_TABLE
2617: , a3 out nocopy JTF_NUMBER_TABLE
2618: , a4 out nocopy JTF_NUMBER_TABLE

Line 2818: procedure rosetta_table_copy_in_p35(t out nocopy as_opportunity_pub.order_out_tbl_type, a0 JTF_NUMBER_TABLE

2814: end if;
2815: end if;
2816: end rosetta_table_copy_out_p32;
2817:
2818: procedure rosetta_table_copy_in_p35(t out nocopy as_opportunity_pub.order_out_tbl_type, a0 JTF_NUMBER_TABLE
2819: , a1 JTF_VARCHAR2_TABLE_100
2820: ) as
2821: ddindx binary_integer; indx binary_integer;
2822: begin

Line 2839: procedure rosetta_table_copy_out_p35(t as_opportunity_pub.order_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

2835: end loop;
2836: end if;
2837: end if;
2838: end rosetta_table_copy_in_p35;
2839: procedure rosetta_table_copy_out_p35(t as_opportunity_pub.order_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2840: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2841: ) as
2842: ddindx binary_integer; indx binary_integer;
2843: begin

Line 2868: procedure rosetta_table_copy_in_p38(t out nocopy as_opportunity_pub.contact_tbl_type, a0 JTF_DATE_TABLE

2864: end if;
2865: end if;
2866: end rosetta_table_copy_out_p35;
2867:
2868: procedure rosetta_table_copy_in_p38(t out nocopy as_opportunity_pub.contact_tbl_type, a0 JTF_DATE_TABLE
2869: , a1 JTF_NUMBER_TABLE
2870: , a2 JTF_DATE_TABLE
2871: , a3 JTF_NUMBER_TABLE
2872: , a4 JTF_NUMBER_TABLE

Line 2973: procedure rosetta_table_copy_out_p38(t as_opportunity_pub.contact_tbl_type, a0 out nocopy JTF_DATE_TABLE

2969: end loop;
2970: end if;
2971: end if;
2972: end rosetta_table_copy_in_p38;
2973: procedure rosetta_table_copy_out_p38(t as_opportunity_pub.contact_tbl_type, a0 out nocopy JTF_DATE_TABLE
2974: , a1 out nocopy JTF_NUMBER_TABLE
2975: , a2 out nocopy JTF_DATE_TABLE
2976: , a3 out nocopy JTF_NUMBER_TABLE
2977: , a4 out nocopy JTF_NUMBER_TABLE

Line 3212: procedure rosetta_table_copy_in_p41(t out nocopy as_opportunity_pub.contact_out_tbl_type, a0 JTF_NUMBER_TABLE

3208: end if;
3209: end if;
3210: end rosetta_table_copy_out_p38;
3211:
3212: procedure rosetta_table_copy_in_p41(t out nocopy as_opportunity_pub.contact_out_tbl_type, a0 JTF_NUMBER_TABLE
3213: , a1 JTF_VARCHAR2_TABLE_100
3214: ) as
3215: ddindx binary_integer; indx binary_integer;
3216: begin

Line 3233: procedure rosetta_table_copy_out_p41(t as_opportunity_pub.contact_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

3229: end loop;
3230: end if;
3231: end if;
3232: end rosetta_table_copy_in_p41;
3233: procedure rosetta_table_copy_out_p41(t as_opportunity_pub.contact_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
3234: , a1 out nocopy JTF_VARCHAR2_TABLE_100
3235: ) as
3236: ddindx binary_integer; indx binary_integer;
3237: begin

Line 3262: procedure rosetta_table_copy_in_p44(t out nocopy as_opportunity_pub.competitor_prod_tbl_type, a0 JTF_VARCHAR2_TABLE_200

3258: end if;
3259: end if;
3260: end rosetta_table_copy_out_p41;
3261:
3262: procedure rosetta_table_copy_in_p44(t out nocopy as_opportunity_pub.competitor_prod_tbl_type, a0 JTF_VARCHAR2_TABLE_200
3263: , a1 JTF_VARCHAR2_TABLE_200
3264: , a2 JTF_VARCHAR2_TABLE_200
3265: , a3 JTF_VARCHAR2_TABLE_200
3266: , a4 JTF_VARCHAR2_TABLE_200

Line 3339: procedure rosetta_table_copy_out_p44(t as_opportunity_pub.competitor_prod_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200

3335: end loop;
3336: end if;
3337: end if;
3338: end rosetta_table_copy_in_p44;
3339: procedure rosetta_table_copy_out_p44(t as_opportunity_pub.competitor_prod_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
3340: , a1 out nocopy JTF_VARCHAR2_TABLE_200
3341: , a2 out nocopy JTF_VARCHAR2_TABLE_200
3342: , a3 out nocopy JTF_VARCHAR2_TABLE_200
3343: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 3508: procedure rosetta_table_copy_in_p47(t out nocopy as_opportunity_pub.competitor_prod_out_tbl_type, a0 JTF_NUMBER_TABLE

3504: end if;
3505: end if;
3506: end rosetta_table_copy_out_p44;
3507:
3508: procedure rosetta_table_copy_in_p47(t out nocopy as_opportunity_pub.competitor_prod_out_tbl_type, a0 JTF_NUMBER_TABLE
3509: , a1 JTF_VARCHAR2_TABLE_100
3510: ) as
3511: ddindx binary_integer; indx binary_integer;
3512: begin

Line 3529: procedure rosetta_table_copy_out_p47(t as_opportunity_pub.competitor_prod_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

3525: end loop;
3526: end if;
3527: end if;
3528: end rosetta_table_copy_in_p47;
3529: procedure rosetta_table_copy_out_p47(t as_opportunity_pub.competitor_prod_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
3530: , a1 out nocopy JTF_VARCHAR2_TABLE_100
3531: ) as
3532: ddindx binary_integer; indx binary_integer;
3533: begin

Line 3558: procedure rosetta_table_copy_in_p50(t out nocopy as_opportunity_pub.decision_factor_tbl_type, a0 JTF_VARCHAR2_TABLE_200

3554: end if;
3555: end if;
3556: end rosetta_table_copy_out_p47;
3557:
3558: procedure rosetta_table_copy_in_p50(t out nocopy as_opportunity_pub.decision_factor_tbl_type, a0 JTF_VARCHAR2_TABLE_200
3559: , a1 JTF_VARCHAR2_TABLE_200
3560: , a2 JTF_VARCHAR2_TABLE_200
3561: , a3 JTF_VARCHAR2_TABLE_200
3562: , a4 JTF_VARCHAR2_TABLE_200

Line 3635: procedure rosetta_table_copy_out_p50(t as_opportunity_pub.decision_factor_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200

3631: end loop;
3632: end if;
3633: end if;
3634: end rosetta_table_copy_in_p50;
3635: procedure rosetta_table_copy_out_p50(t as_opportunity_pub.decision_factor_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
3636: , a1 out nocopy JTF_VARCHAR2_TABLE_200
3637: , a2 out nocopy JTF_VARCHAR2_TABLE_200
3638: , a3 out nocopy JTF_VARCHAR2_TABLE_200
3639: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 3804: procedure rosetta_table_copy_in_p53(t out nocopy as_opportunity_pub.decision_factor_out_tbl_type, a0 JTF_NUMBER_TABLE

3800: end if;
3801: end if;
3802: end rosetta_table_copy_out_p50;
3803:
3804: procedure rosetta_table_copy_in_p53(t out nocopy as_opportunity_pub.decision_factor_out_tbl_type, a0 JTF_NUMBER_TABLE
3805: , a1 JTF_VARCHAR2_TABLE_100
3806: ) as
3807: ddindx binary_integer; indx binary_integer;
3808: begin

Line 3825: procedure rosetta_table_copy_out_p53(t as_opportunity_pub.decision_factor_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

3821: end loop;
3822: end if;
3823: end if;
3824: end rosetta_table_copy_in_p53;
3825: procedure rosetta_table_copy_out_p53(t as_opportunity_pub.decision_factor_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
3826: , a1 out nocopy JTF_VARCHAR2_TABLE_100
3827: ) as
3828: ddindx binary_integer; indx binary_integer;
3829: begin

Line 3973: ddp_header_rec as_opportunity_pub.header_rec_type;

3969: , p4_a99 NUMBER := 0-1962.0724
3970: )
3971:
3972: as
3973: ddp_header_rec as_opportunity_pub.header_rec_type;
3974: ddp_profile_tbl as_utility_pub.profile_tbl_type;
3975: ddindx binary_integer; indx binary_integer;
3976: begin
3977:

Line 4099: as_opportunity_pub.create_opp_header(p_api_version_number,

4095:
4096:
4097:
4098: -- here's the delegated call to the old PL/SQL routine
4099: as_opportunity_pub.create_opp_header(p_api_version_number,
4100: p_init_msg_list,
4101: p_commit,
4102: p_validation_level,
4103: ddp_header_rec,

Line 4252: ddp_header_rec as_opportunity_pub.header_rec_type;

4248: , p4_a99 NUMBER := 0-1962.0724
4249: )
4250:
4251: as
4252: ddp_header_rec as_opportunity_pub.header_rec_type;
4253: ddp_profile_tbl as_utility_pub.profile_tbl_type;
4254: ddindx binary_integer; indx binary_integer;
4255: begin
4256:

Line 4377: as_opportunity_pub.update_opp_header(p_api_version_number,

4373:
4374:
4375:
4376: -- here's the delegated call to the old PL/SQL routine
4377: as_opportunity_pub.update_opp_header(p_api_version_number,
4378: p_init_msg_list,
4379: p_commit,
4380: p_validation_level,
4381: ddp_header_rec,

Line 4528: ddp_header_rec as_opportunity_pub.header_rec_type;

4524: , p4_a99 NUMBER := 0-1962.0724
4525: )
4526:
4527: as
4528: ddp_header_rec as_opportunity_pub.header_rec_type;
4529: ddp_profile_tbl as_utility_pub.profile_tbl_type;
4530: ddindx binary_integer; indx binary_integer;
4531: begin
4532:

Line 4653: as_opportunity_pub.delete_opp_header(p_api_version_number,

4649:
4650:
4651:
4652: -- here's the delegated call to the old PL/SQL routine
4653: as_opportunity_pub.delete_opp_header(p_api_version_number,
4654: p_init_msg_list,
4655: p_commit,
4656: p_validation_level,
4657: ddp_header_rec,

Line 4875: ddp_line_tbl as_opportunity_pub.line_tbl_type;

4871: , p5_a99 NUMBER := 0-1962.0724
4872: )
4873:
4874: as
4875: ddp_line_tbl as_opportunity_pub.line_tbl_type;
4876: ddp_header_rec as_opportunity_pub.header_rec_type;
4877: ddp_profile_tbl as_utility_pub.profile_tbl_type;
4878: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;
4879: ddindx binary_integer; indx binary_integer;

Line 4876: ddp_header_rec as_opportunity_pub.header_rec_type;

4872: )
4873:
4874: as
4875: ddp_line_tbl as_opportunity_pub.line_tbl_type;
4876: ddp_header_rec as_opportunity_pub.header_rec_type;
4877: ddp_profile_tbl as_utility_pub.profile_tbl_type;
4878: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;
4879: ddindx binary_integer; indx binary_integer;
4880: begin

Line 4878: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;

4874: as
4875: ddp_line_tbl as_opportunity_pub.line_tbl_type;
4876: ddp_header_rec as_opportunity_pub.header_rec_type;
4877: ddp_profile_tbl as_utility_pub.profile_tbl_type;
4878: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;
4879: ddindx binary_integer; indx binary_integer;
4880: begin
4881:
4882: -- copy data to the local IN or IN-OUT args, if any

Line 4887: as_opportunity_pub_w.rosetta_table_copy_in_p6(ddp_line_tbl, p4_a0

4883:
4884:
4885:
4886:
4887: as_opportunity_pub_w.rosetta_table_copy_in_p6(ddp_line_tbl, p4_a0
4888: , p4_a1
4889: , p4_a2
4890: , p4_a3
4891: , p4_a4

Line 5074: as_opportunity_pub.create_opp_lines(p_api_version_number,

5070:
5071:
5072:
5073: -- here's the delegated call to the old PL/SQL routine
5074: as_opportunity_pub.create_opp_lines(p_api_version_number,
5075: p_init_msg_list,
5076: p_commit,
5077: p_validation_level,
5078: ddp_line_tbl,

Line 5106: as_opportunity_pub_w.rosetta_table_copy_out_p9(ddx_line_out_tbl, p13_a0

5102:
5103:
5104:
5105:
5106: as_opportunity_pub_w.rosetta_table_copy_out_p9(ddx_line_out_tbl, p13_a0
5107: , p13_a1
5108: );
5109:
5110:

Line 5302: ddp_line_tbl as_opportunity_pub.line_tbl_type;

5298: , p6_a99 NUMBER := 0-1962.0724
5299: )
5300:
5301: as
5302: ddp_line_tbl as_opportunity_pub.line_tbl_type;
5303: ddp_header_rec as_opportunity_pub.header_rec_type;
5304: ddp_profile_tbl as_utility_pub.profile_tbl_type;
5305: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;
5306: ddindx binary_integer; indx binary_integer;

Line 5303: ddp_header_rec as_opportunity_pub.header_rec_type;

5299: )
5300:
5301: as
5302: ddp_line_tbl as_opportunity_pub.line_tbl_type;
5303: ddp_header_rec as_opportunity_pub.header_rec_type;
5304: ddp_profile_tbl as_utility_pub.profile_tbl_type;
5305: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;
5306: ddindx binary_integer; indx binary_integer;
5307: begin

Line 5305: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;

5301: as
5302: ddp_line_tbl as_opportunity_pub.line_tbl_type;
5303: ddp_header_rec as_opportunity_pub.header_rec_type;
5304: ddp_profile_tbl as_utility_pub.profile_tbl_type;
5305: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;
5306: ddindx binary_integer; indx binary_integer;
5307: begin
5308:
5309: -- copy data to the local IN or IN-OUT args, if any

Line 5315: as_opportunity_pub_w.rosetta_table_copy_in_p6(ddp_line_tbl, p5_a0

5311:
5312:
5313:
5314:
5315: as_opportunity_pub_w.rosetta_table_copy_in_p6(ddp_line_tbl, p5_a0
5316: , p5_a1
5317: , p5_a2
5318: , p5_a3
5319: , p5_a4

Line 5500: as_opportunity_pub.update_opp_lines(p_api_version_number,

5496:
5497:
5498:
5499: -- here's the delegated call to the old PL/SQL routine
5500: as_opportunity_pub.update_opp_lines(p_api_version_number,
5501: p_init_msg_list,
5502: p_commit,
5503: p_validation_level,
5504: p_identity_salesforce_id,

Line 5530: as_opportunity_pub_w.rosetta_table_copy_out_p9(ddx_line_out_tbl, p12_a0

5526:
5527:
5528:
5529:
5530: as_opportunity_pub_w.rosetta_table_copy_out_p9(ddx_line_out_tbl, p12_a0
5531: , p12_a1
5532: );
5533:
5534:

Line 5726: ddp_line_tbl as_opportunity_pub.line_tbl_type;

5722: , p6_a99 NUMBER := 0-1962.0724
5723: )
5724:
5725: as
5726: ddp_line_tbl as_opportunity_pub.line_tbl_type;
5727: ddp_header_rec as_opportunity_pub.header_rec_type;
5728: ddp_profile_tbl as_utility_pub.profile_tbl_type;
5729: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;
5730: ddindx binary_integer; indx binary_integer;

Line 5727: ddp_header_rec as_opportunity_pub.header_rec_type;

5723: )
5724:
5725: as
5726: ddp_line_tbl as_opportunity_pub.line_tbl_type;
5727: ddp_header_rec as_opportunity_pub.header_rec_type;
5728: ddp_profile_tbl as_utility_pub.profile_tbl_type;
5729: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;
5730: ddindx binary_integer; indx binary_integer;
5731: begin

Line 5729: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;

5725: as
5726: ddp_line_tbl as_opportunity_pub.line_tbl_type;
5727: ddp_header_rec as_opportunity_pub.header_rec_type;
5728: ddp_profile_tbl as_utility_pub.profile_tbl_type;
5729: ddx_line_out_tbl as_opportunity_pub.line_out_tbl_type;
5730: ddindx binary_integer; indx binary_integer;
5731: begin
5732:
5733: -- copy data to the local IN or IN-OUT args, if any

Line 5739: as_opportunity_pub_w.rosetta_table_copy_in_p6(ddp_line_tbl, p5_a0

5735:
5736:
5737:
5738:
5739: as_opportunity_pub_w.rosetta_table_copy_in_p6(ddp_line_tbl, p5_a0
5740: , p5_a1
5741: , p5_a2
5742: , p5_a3
5743: , p5_a4

Line 5924: as_opportunity_pub.delete_opp_lines(p_api_version_number,

5920:
5921:
5922:
5923: -- here's the delegated call to the old PL/SQL routine
5924: as_opportunity_pub.delete_opp_lines(p_api_version_number,
5925: p_init_msg_list,
5926: p_commit,
5927: p_validation_level,
5928: p_identity_salesforce_id,

Line 5954: as_opportunity_pub_w.rosetta_table_copy_out_p9(ddx_line_out_tbl, p12_a0

5950:
5951:
5952:
5953:
5954: as_opportunity_pub_w.rosetta_table_copy_out_p9(ddx_line_out_tbl, p12_a0
5955: , p12_a1
5956: );
5957:
5958:

Line 6042: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;

6038: , x_msg_data out nocopy VARCHAR2
6039: )
6040:
6041: as
6042: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
6043: ddp_profile_tbl as_utility_pub.profile_tbl_type;
6044: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;
6045: ddindx binary_integer; indx binary_integer;
6046: begin

Line 6044: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;

6040:
6041: as
6042: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
6043: ddp_profile_tbl as_utility_pub.profile_tbl_type;
6044: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;
6045: ddindx binary_integer; indx binary_integer;
6046: begin
6047:
6048: -- copy data to the local IN or IN-OUT args, if any

Line 6054: as_opportunity_pub_w.rosetta_table_copy_in_p12(ddp_sales_credit_tbl, p5_a0

6050:
6051:
6052:
6053:
6054: as_opportunity_pub_w.rosetta_table_copy_in_p12(ddp_sales_credit_tbl, p5_a0
6055: , p5_a1
6056: , p5_a2
6057: , p5_a3
6058: , p5_a4

Line 6130: as_opportunity_pub.create_sales_credits(p_api_version_number,

6126:
6127:
6128:
6129: -- here's the delegated call to the old PL/SQL routine
6130: as_opportunity_pub.create_sales_credits(p_api_version_number,
6131: p_init_msg_list,
6132: p_commit,
6133: p_validation_level,
6134: p_identity_salesforce_id,

Line 6158: as_opportunity_pub_w.rosetta_table_copy_out_p15(ddx_sales_credit_out_tbl, p11_a0

6154:
6155:
6156:
6157:
6158: as_opportunity_pub_w.rosetta_table_copy_out_p15(ddx_sales_credit_out_tbl, p11_a0
6159: , p11_a1
6160: );
6161:
6162:

Line 6246: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;

6242: , x_msg_data out nocopy VARCHAR2
6243: )
6244:
6245: as
6246: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
6247: ddp_profile_tbl as_utility_pub.profile_tbl_type;
6248: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;
6249: ddindx binary_integer; indx binary_integer;
6250: begin

Line 6248: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;

6244:
6245: as
6246: ddp_sales_credit_tbl as_opportunity_pub.sales_credit_tbl_type;
6247: ddp_profile_tbl as_utility_pub.profile_tbl_type;
6248: ddx_sales_credit_out_tbl as_opportunity_pub.sales_credit_out_tbl_type;
6249: ddindx binary_integer; indx binary_integer;
6250: begin
6251:
6252: -- copy data to the local IN or IN-OUT args, if any

Line 6258: as_opportunity_pub_w.rosetta_table_copy_in_p12(ddp_sales_credit_tbl, p5_a0

6254:
6255:
6256:
6257:
6258: as_opportunity_pub_w.rosetta_table_copy_in_p12(ddp_sales_credit_tbl, p5_a0
6259: , p5_a1
6260: , p5_a2
6261: , p5_a3
6262: , p5_a4

Line 6334: as_opportunity_pub.update_sales_credits(p_api_version_number,

6330:
6331:
6332:
6333: -- here's the delegated call to the old PL/SQL routine
6334: as_opportunity_pub.update_sales_credits(p_api_version_number,
6335: p_init_msg_list,
6336: p_commit,
6337: p_validation_level,
6338: p_identity_salesforce_id,

Line 6362: as_opportunity_pub_w.rosetta_table_copy_out_p15(ddx_sales_credit_out_tbl, p11_a0

6358:
6359:
6360:
6361:
6362: as_opportunity_pub_w.rosetta_table_copy_out_p15(ddx_sales_credit_out_tbl, p11_a0
6363: , p11_a1
6364: );
6365:
6366:

Line 6370: end as_opportunity_pub_w;

6366:
6367:
6368: end;
6369:
6370: end as_opportunity_pub_w;