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.CN_PLAN_ELEMENT_PUB_W dependencies on CN_PLAN_ELEMENT_PUB

Line 1: package body cn_plan_element_pub_w as

1: package body cn_plan_element_pub_w as
2: /* $Header: cnwppes.pls 120.1.12000000.2 2007/10/09 06:28:56 rnagired ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_plan_element_pub.plan_element_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_1900
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy cn_plan_element_pub.plan_element_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body cn_plan_element_pub_w as
2: /* $Header: cnwppes.pls 120.1.12000000.2 2007/10/09 06:28:56 rnagired ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy cn_plan_element_pub.plan_element_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_1900
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 106: procedure rosetta_table_copy_out_p2(t cn_plan_element_pub.plan_element_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

102: end loop;
103: end if;
104: end if;
105: end rosetta_table_copy_in_p2;
106: procedure rosetta_table_copy_out_p2(t cn_plan_element_pub.plan_element_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
107: , a1 out nocopy JTF_VARCHAR2_TABLE_1900
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE

Line 340: procedure rosetta_table_copy_in_p5(t out nocopy cn_plan_element_pub.period_quotas_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100

336: end if;
337: end if;
338: end rosetta_table_copy_out_p2;
339:
340: procedure rosetta_table_copy_in_p5(t out nocopy cn_plan_element_pub.period_quotas_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
341: , a1 JTF_NUMBER_TABLE
342: , a2 JTF_NUMBER_TABLE
343: , a3 JTF_NUMBER_TABLE
344: , a4 JTF_VARCHAR2_TABLE_200

Line 399: procedure rosetta_table_copy_out_p5(t cn_plan_element_pub.period_quotas_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

395: end loop;
396: end if;
397: end if;
398: end rosetta_table_copy_in_p5;
399: procedure rosetta_table_copy_out_p5(t cn_plan_element_pub.period_quotas_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
400: , a1 out nocopy JTF_NUMBER_TABLE
401: , a2 out nocopy JTF_NUMBER_TABLE
402: , a3 out nocopy JTF_NUMBER_TABLE
403: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 523: procedure rosetta_table_copy_in_p8(t out nocopy cn_plan_element_pub.revenue_class_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100

519: end if;
520: end if;
521: end rosetta_table_copy_out_p5;
522:
523: procedure rosetta_table_copy_in_p8(t out nocopy cn_plan_element_pub.revenue_class_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
524: , a1 JTF_NUMBER_TABLE
525: , a2 JTF_NUMBER_TABLE
526: , a3 JTF_NUMBER_TABLE
527: , a4 JTF_VARCHAR2_TABLE_1900

Line 586: procedure rosetta_table_copy_out_p8(t cn_plan_element_pub.revenue_class_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

582: end loop;
583: end if;
584: end if;
585: end rosetta_table_copy_in_p8;
586: procedure rosetta_table_copy_out_p8(t cn_plan_element_pub.revenue_class_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
587: , a1 out nocopy JTF_NUMBER_TABLE
588: , a2 out nocopy JTF_NUMBER_TABLE
589: , a3 out nocopy JTF_NUMBER_TABLE
590: , a4 out nocopy JTF_VARCHAR2_TABLE_1900

Line 720: procedure rosetta_table_copy_in_p11(t out nocopy cn_plan_element_pub.rev_uplift_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100

716: end if;
717: end if;
718: end rosetta_table_copy_out_p8;
719:
720: procedure rosetta_table_copy_in_p11(t out nocopy cn_plan_element_pub.rev_uplift_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
721: , a1 JTF_DATE_TABLE
722: , a2 JTF_DATE_TABLE
723: , a3 JTF_NUMBER_TABLE
724: , a4 JTF_NUMBER_TABLE

Line 789: procedure rosetta_table_copy_out_p11(t cn_plan_element_pub.rev_uplift_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

785: end loop;
786: end if;
787: end if;
788: end rosetta_table_copy_in_p11;
789: procedure rosetta_table_copy_out_p11(t cn_plan_element_pub.rev_uplift_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
790: , a1 out nocopy JTF_DATE_TABLE
791: , a2 out nocopy JTF_DATE_TABLE
792: , a3 out nocopy JTF_NUMBER_TABLE
793: , a4 out nocopy JTF_NUMBER_TABLE

Line 938: procedure rosetta_table_copy_in_p14(t out nocopy cn_plan_element_pub.trx_factor_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100

934: end if;
935: end if;
936: end rosetta_table_copy_out_p11;
937:
938: procedure rosetta_table_copy_in_p14(t out nocopy cn_plan_element_pub.trx_factor_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
939: , a1 JTF_NUMBER_TABLE
940: , a2 JTF_VARCHAR2_TABLE_100
941: , a3 JTF_NUMBER_TABLE
942: ) as

Line 963: procedure rosetta_table_copy_out_p14(t cn_plan_element_pub.trx_factor_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

959: end loop;
960: end if;
961: end if;
962: end rosetta_table_copy_in_p14;
963: procedure rosetta_table_copy_out_p14(t cn_plan_element_pub.trx_factor_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
964: , a1 out nocopy JTF_NUMBER_TABLE
965: , a2 out nocopy JTF_VARCHAR2_TABLE_100
966: , a3 out nocopy JTF_NUMBER_TABLE
967: ) as

Line 1002: procedure rosetta_table_copy_in_p18(t out nocopy cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100

998: end if;
999: end if;
1000: end rosetta_table_copy_out_p14;
1001:
1002: procedure rosetta_table_copy_in_p18(t out nocopy cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1003: , a1 JTF_VARCHAR2_TABLE_100
1004: , a2 JTF_DATE_TABLE
1005: , a3 JTF_DATE_TABLE
1006: , a4 JTF_VARCHAR2_TABLE_100

Line 1067: procedure rosetta_table_copy_out_p18(t cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

1063: end loop;
1064: end if;
1065: end if;
1066: end rosetta_table_copy_in_p18;
1067: procedure rosetta_table_copy_out_p18(t cn_plan_element_pub.rt_quota_asgns_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1068: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1069: , a2 out nocopy JTF_DATE_TABLE
1070: , a3 out nocopy JTF_DATE_TABLE
1071: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1359: ddp_plan_element_rec cn_plan_element_pub.plan_element_rec_type;

1355: , p_is_duplicate VARCHAR2
1356: )
1357:
1358: as
1359: ddp_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1360: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1361: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1362: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1363: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;

Line 1360: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;

1356: )
1357:
1358: as
1359: ddp_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1360: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1361: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1362: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1363: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1364: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;

Line 1361: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;

1357:
1358: as
1359: ddp_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1360: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1361: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1362: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1363: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1364: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
1365: ddindx binary_integer; indx binary_integer;

Line 1362: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;

1358: as
1359: ddp_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1360: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1361: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1362: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1363: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1364: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
1365: ddindx binary_integer; indx binary_integer;
1366: begin

Line 1363: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;

1359: ddp_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1360: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1361: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1362: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1363: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1364: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
1365: ddindx binary_integer; indx binary_integer;
1366: begin
1367:

Line 1364: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;

1360: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1361: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1362: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1363: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1364: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
1365: ddindx binary_integer; indx binary_integer;
1366: begin
1367:
1368: -- copy data to the local IN or IN-OUT args, if any

Line 1420: cn_plan_element_pub_w.rosetta_table_copy_in_p8(ddp_revenue_class_rec_tbl, p8_a0

1416: ddp_plan_element_rec.quota_id := p7_a40;
1417: ddp_plan_element_rec.indirect_credit := p7_a41;
1418: ddp_plan_element_rec.sreps_enddated_flag := p7_a42;
1419:
1420: cn_plan_element_pub_w.rosetta_table_copy_in_p8(ddp_revenue_class_rec_tbl, p8_a0
1421: , p8_a1
1422: , p8_a2
1423: , p8_a3
1424: , p8_a4

Line 1445: cn_plan_element_pub_w.rosetta_table_copy_in_p11(ddp_rev_uplift_rec_tbl, p9_a0

1441: , p8_a21
1442: , p8_a22
1443: );
1444:
1445: cn_plan_element_pub_w.rosetta_table_copy_in_p11(ddp_rev_uplift_rec_tbl, p9_a0
1446: , p9_a1
1447: , p9_a2
1448: , p9_a3
1449: , p9_a4

Line 1473: cn_plan_element_pub_w.rosetta_table_copy_in_p14(ddp_trx_factor_rec_tbl, p10_a0

1469: , p9_a24
1470: , p9_a25
1471: );
1472:
1473: cn_plan_element_pub_w.rosetta_table_copy_in_p14(ddp_trx_factor_rec_tbl, p10_a0
1474: , p10_a1
1475: , p10_a2
1476: , p10_a3
1477: );

Line 1479: cn_plan_element_pub_w.rosetta_table_copy_in_p5(ddp_period_quotas_rec_tbl, p11_a0

1475: , p10_a2
1476: , p10_a3
1477: );
1478:
1479: cn_plan_element_pub_w.rosetta_table_copy_in_p5(ddp_period_quotas_rec_tbl, p11_a0
1480: , p11_a1
1481: , p11_a2
1482: , p11_a3
1483: , p11_a4

Line 1502: cn_plan_element_pub_w.rosetta_table_copy_in_p18(ddp_rt_quota_asgns_rec_tbl, p12_a0

1498: , p11_a19
1499: , p11_a20
1500: );
1501:
1502: cn_plan_element_pub_w.rosetta_table_copy_in_p18(ddp_rt_quota_asgns_rec_tbl, p12_a0
1503: , p12_a1
1504: , p12_a2
1505: , p12_a3
1506: , p12_a4

Line 1531: cn_plan_element_pub.create_plan_element(p_api_version,

1527:
1528:
1529:
1530: -- here's the delegated call to the old PL/SQL routine
1531: cn_plan_element_pub.create_plan_element(p_api_version,
1532: p_init_msg_list,
1533: p_commit,
1534: p_validation_level,
1535: x_return_status,

Line 1717: ddp_new_plan_element_rec cn_plan_element_pub.plan_element_rec_type;

1713: , x_loading_status out nocopy VARCHAR2
1714: )
1715:
1716: as
1717: ddp_new_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1718: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1719: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1720: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1721: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;

Line 1718: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;

1714: )
1715:
1716: as
1717: ddp_new_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1718: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1719: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1720: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1721: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1722: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;

Line 1719: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;

1715:
1716: as
1717: ddp_new_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1718: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1719: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1720: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1721: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1722: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
1723: ddindx binary_integer; indx binary_integer;

Line 1720: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;

1716: as
1717: ddp_new_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1718: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1719: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1720: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1721: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1722: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
1723: ddindx binary_integer; indx binary_integer;
1724: begin

Line 1721: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;

1717: ddp_new_plan_element_rec cn_plan_element_pub.plan_element_rec_type;
1718: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1719: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1720: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1721: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1722: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
1723: ddindx binary_integer; indx binary_integer;
1724: begin
1725:

Line 1722: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;

1718: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
1719: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
1720: ddp_trx_factor_rec_tbl cn_plan_element_pub.trx_factor_rec_tbl_type;
1721: ddp_period_quotas_rec_tbl cn_plan_element_pub.period_quotas_rec_tbl_type;
1722: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
1723: ddindx binary_integer; indx binary_integer;
1724: begin
1725:
1726: -- copy data to the local IN or IN-OUT args, if any

Line 1779: cn_plan_element_pub_w.rosetta_table_copy_in_p8(ddp_revenue_class_rec_tbl, p9_a0

1775: ddp_new_plan_element_rec.indirect_credit := p7_a41;
1776: ddp_new_plan_element_rec.sreps_enddated_flag := p7_a42;
1777:
1778:
1779: cn_plan_element_pub_w.rosetta_table_copy_in_p8(ddp_revenue_class_rec_tbl, p9_a0
1780: , p9_a1
1781: , p9_a2
1782: , p9_a3
1783: , p9_a4

Line 1804: cn_plan_element_pub_w.rosetta_table_copy_in_p11(ddp_rev_uplift_rec_tbl, p10_a0

1800: , p9_a21
1801: , p9_a22
1802: );
1803:
1804: cn_plan_element_pub_w.rosetta_table_copy_in_p11(ddp_rev_uplift_rec_tbl, p10_a0
1805: , p10_a1
1806: , p10_a2
1807: , p10_a3
1808: , p10_a4

Line 1832: cn_plan_element_pub_w.rosetta_table_copy_in_p14(ddp_trx_factor_rec_tbl, p11_a0

1828: , p10_a24
1829: , p10_a25
1830: );
1831:
1832: cn_plan_element_pub_w.rosetta_table_copy_in_p14(ddp_trx_factor_rec_tbl, p11_a0
1833: , p11_a1
1834: , p11_a2
1835: , p11_a3
1836: );

Line 1838: cn_plan_element_pub_w.rosetta_table_copy_in_p5(ddp_period_quotas_rec_tbl, p12_a0

1834: , p11_a2
1835: , p11_a3
1836: );
1837:
1838: cn_plan_element_pub_w.rosetta_table_copy_in_p5(ddp_period_quotas_rec_tbl, p12_a0
1839: , p12_a1
1840: , p12_a2
1841: , p12_a3
1842: , p12_a4

Line 1861: cn_plan_element_pub_w.rosetta_table_copy_in_p18(ddp_rt_quota_asgns_rec_tbl, p13_a0

1857: , p12_a19
1858: , p12_a20
1859: );
1860:
1861: cn_plan_element_pub_w.rosetta_table_copy_in_p18(ddp_rt_quota_asgns_rec_tbl, p13_a0
1862: , p13_a1
1863: , p13_a2
1864: , p13_a3
1865: , p13_a4

Line 1889: cn_plan_element_pub.update_plan_element(p_api_version,

1885: );
1886:
1887:
1888: -- here's the delegated call to the old PL/SQL routine
1889: cn_plan_element_pub.update_plan_element(p_api_version,
1890: p_init_msg_list,
1891: p_commit,
1892: p_validation_level,
1893: x_return_status,

Line 2049: ddp_quota_rec cn_plan_element_pub.plan_element_rec_type;

2045: , x_loading_status out nocopy VARCHAR2
2046: )
2047:
2048: as
2049: ddp_quota_rec cn_plan_element_pub.plan_element_rec_type;
2050: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
2051: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
2052: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
2053: ddindx binary_integer; indx binary_integer;

Line 2050: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;

2046: )
2047:
2048: as
2049: ddp_quota_rec cn_plan_element_pub.plan_element_rec_type;
2050: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
2051: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
2052: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
2053: ddindx binary_integer; indx binary_integer;
2054: begin

Line 2051: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;

2047:
2048: as
2049: ddp_quota_rec cn_plan_element_pub.plan_element_rec_type;
2050: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
2051: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
2052: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
2053: ddindx binary_integer; indx binary_integer;
2054: begin
2055:

Line 2052: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;

2048: as
2049: ddp_quota_rec cn_plan_element_pub.plan_element_rec_type;
2050: ddp_revenue_class_rec_tbl cn_plan_element_pub.revenue_class_rec_tbl_type;
2051: ddp_rev_uplift_rec_tbl cn_plan_element_pub.rev_uplift_rec_tbl_type;
2052: ddp_rt_quota_asgns_rec_tbl cn_plan_element_pub.rt_quota_asgns_rec_tbl_type;
2053: ddindx binary_integer; indx binary_integer;
2054: begin
2055:
2056: -- copy data to the local IN or IN-OUT args, if any

Line 2108: cn_plan_element_pub_w.rosetta_table_copy_in_p8(ddp_revenue_class_rec_tbl, p8_a0

2104: ddp_quota_rec.quota_id := p7_a40;
2105: ddp_quota_rec.indirect_credit := p7_a41;
2106: ddp_quota_rec.sreps_enddated_flag := p7_a42;
2107:
2108: cn_plan_element_pub_w.rosetta_table_copy_in_p8(ddp_revenue_class_rec_tbl, p8_a0
2109: , p8_a1
2110: , p8_a2
2111: , p8_a3
2112: , p8_a4

Line 2133: cn_plan_element_pub_w.rosetta_table_copy_in_p11(ddp_rev_uplift_rec_tbl, p9_a0

2129: , p8_a21
2130: , p8_a22
2131: );
2132:
2133: cn_plan_element_pub_w.rosetta_table_copy_in_p11(ddp_rev_uplift_rec_tbl, p9_a0
2134: , p9_a1
2135: , p9_a2
2136: , p9_a3
2137: , p9_a4

Line 2161: cn_plan_element_pub_w.rosetta_table_copy_in_p18(ddp_rt_quota_asgns_rec_tbl, p10_a0

2157: , p9_a24
2158: , p9_a25
2159: );
2160:
2161: cn_plan_element_pub_w.rosetta_table_copy_in_p18(ddp_rt_quota_asgns_rec_tbl, p10_a0
2162: , p10_a1
2163: , p10_a2
2164: , p10_a3
2165: , p10_a4

Line 2189: cn_plan_element_pub.delete_plan_element(p_api_version,

2185: );
2186:
2187:
2188: -- here's the delegated call to the old PL/SQL routine
2189: cn_plan_element_pub.delete_plan_element(p_api_version,
2190: p_init_msg_list,
2191: p_commit,
2192: p_validation_level,
2193: x_return_status,

Line 2216: end cn_plan_element_pub_w;

2212:
2213:
2214: end;
2215:
2216: end cn_plan_element_pub_w;