DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PUB_W dependencies on OKS_ENTITLEMENTS_PUB

Line 1: package body oks_entitlements_pub_w as

1: package body oks_entitlements_pub_w as
2: /* $Header: OKSWENTB.pls 120.4 2011/12/16 09:27:09 vgujarat 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 13: procedure rosetta_table_copy_in_p4(t out nocopy oks_entitlements_pub.apl_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p4(t out nocopy oks_entitlements_pub.apl_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE

Line 44: procedure rosetta_table_copy_out_p4(t oks_entitlements_pub.apl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p4;
44: procedure rosetta_table_copy_out_p4(t oks_entitlements_pub.apl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE

Line 98: procedure rosetta_table_copy_in_p16(t out nocopy oks_entitlements_pub.hdr_tbl_type, a0 JTF_NUMBER_TABLE

94: end if;
95: end if;
96: end rosetta_table_copy_out_p4;
97:
98: procedure rosetta_table_copy_in_p16(t out nocopy oks_entitlements_pub.hdr_tbl_type, a0 JTF_NUMBER_TABLE
99: , a1 JTF_NUMBER_TABLE
100: , a2 JTF_VARCHAR2_TABLE_200
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_600

Line 191: procedure rosetta_table_copy_out_p16(t oks_entitlements_pub.hdr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

187: end loop;
188: end if;
189: end if;
190: end rosetta_table_copy_in_p16;
191: procedure rosetta_table_copy_out_p16(t oks_entitlements_pub.hdr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
192: , a1 out nocopy JTF_NUMBER_TABLE
193: , a2 out nocopy JTF_VARCHAR2_TABLE_200
194: , a3 out nocopy JTF_VARCHAR2_TABLE_200
195: , a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 400: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_pub.line_tbl_type, a0 JTF_NUMBER_TABLE

396: end if;
397: end if;
398: end rosetta_table_copy_out_p16;
399:
400: procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_pub.line_tbl_type, a0 JTF_NUMBER_TABLE
401: , a1 JTF_NUMBER_TABLE
402: , a2 JTF_NUMBER_TABLE
403: , a3 JTF_VARCHAR2_TABLE_100
404: , a4 JTF_NUMBER_TABLE

Line 461: procedure rosetta_table_copy_out_p19(t oks_entitlements_pub.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

457: end loop;
458: end if;
459: end if;
460: end rosetta_table_copy_in_p19;
461: procedure rosetta_table_copy_out_p19(t oks_entitlements_pub.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
462: , a1 out nocopy JTF_NUMBER_TABLE
463: , a2 out nocopy JTF_NUMBER_TABLE
464: , a3 out nocopy JTF_VARCHAR2_TABLE_100
465: , a4 out nocopy JTF_NUMBER_TABLE

Line 590: procedure rosetta_table_copy_in_p22(t out nocopy oks_entitlements_pub.clvl_tbl_type, a0 JTF_VARCHAR2_TABLE_100

586: end if;
587: end if;
588: end rosetta_table_copy_out_p19;
589:
590: procedure rosetta_table_copy_in_p22(t out nocopy oks_entitlements_pub.clvl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_VARCHAR2_TABLE_200

Line 677: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

673: end loop;
674: end if;
675: end if;
676: end rosetta_table_copy_in_p22;
677: procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
678: , a1 out nocopy JTF_NUMBER_TABLE
679: , a2 out nocopy JTF_NUMBER_TABLE
680: , a3 out nocopy JTF_NUMBER_TABLE
681: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 871: procedure rosetta_table_copy_in_p26(t out nocopy oks_entitlements_pub.ent_cont_tbl, a0 JTF_NUMBER_TABLE

867: end if;
868: end if;
869: end rosetta_table_copy_out_p22;
870:
871: procedure rosetta_table_copy_in_p26(t out nocopy oks_entitlements_pub.ent_cont_tbl, a0 JTF_NUMBER_TABLE
872: , a1 JTF_VARCHAR2_TABLE_200
873: , a2 JTF_VARCHAR2_TABLE_200
874: , a3 JTF_NUMBER_TABLE
875: , a4 JTF_VARCHAR2_TABLE_300

Line 928: procedure rosetta_table_copy_out_p26(t oks_entitlements_pub.ent_cont_tbl, a0 out nocopy JTF_NUMBER_TABLE

924: end loop;
925: end if;
926: end if;
927: end rosetta_table_copy_in_p26;
928: procedure rosetta_table_copy_out_p26(t oks_entitlements_pub.ent_cont_tbl, a0 out nocopy JTF_NUMBER_TABLE
929: , a1 out nocopy JTF_VARCHAR2_TABLE_200
930: , a2 out nocopy JTF_VARCHAR2_TABLE_200
931: , a3 out nocopy JTF_NUMBER_TABLE
932: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 1047: procedure rosetta_table_copy_in_p30(t out nocopy oks_entitlements_pub.get_contop_tbl, a0 JTF_NUMBER_TABLE

1043: end if;
1044: end if;
1045: end rosetta_table_copy_out_p26;
1046:
1047: procedure rosetta_table_copy_in_p30(t out nocopy oks_entitlements_pub.get_contop_tbl, a0 JTF_NUMBER_TABLE
1048: , a1 JTF_VARCHAR2_TABLE_200
1049: , a2 JTF_VARCHAR2_TABLE_200
1050: , a3 JTF_VARCHAR2_TABLE_100
1051: , a4 JTF_NUMBER_TABLE

Line 1120: procedure rosetta_table_copy_out_p30(t oks_entitlements_pub.get_contop_tbl, a0 out nocopy JTF_NUMBER_TABLE

1116: end loop;
1117: end if;
1118: end if;
1119: end rosetta_table_copy_in_p30;
1120: procedure rosetta_table_copy_out_p30(t oks_entitlements_pub.get_contop_tbl, a0 out nocopy JTF_NUMBER_TABLE
1121: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1122: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1123: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1124: , a4 out nocopy JTF_NUMBER_TABLE

Line 1279: procedure rosetta_table_copy_in_p34(t out nocopy oks_entitlements_pub.output_tbl_ib, a0 JTF_NUMBER_TABLE

1275: end if;
1276: end if;
1277: end rosetta_table_copy_out_p30;
1278:
1279: procedure rosetta_table_copy_in_p34(t out nocopy oks_entitlements_pub.output_tbl_ib, a0 JTF_NUMBER_TABLE
1280: , a1 JTF_VARCHAR2_TABLE_200
1281: , a2 JTF_VARCHAR2_TABLE_200
1282: , a3 JTF_VARCHAR2_TABLE_100
1283: , a4 JTF_NUMBER_TABLE

Line 1340: procedure rosetta_table_copy_out_p34(t oks_entitlements_pub.output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE

1336: end loop;
1337: end if;
1338: end if;
1339: end rosetta_table_copy_in_p34;
1340: procedure rosetta_table_copy_out_p34(t oks_entitlements_pub.output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE
1341: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1342: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1343: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1344: , a4 out nocopy JTF_NUMBER_TABLE

Line 1469: procedure rosetta_table_copy_in_p38(t out nocopy oks_entitlements_pub.output_tbl_entfrm, a0 JTF_NUMBER_TABLE

1465: end if;
1466: end if;
1467: end rosetta_table_copy_out_p34;
1468:
1469: procedure rosetta_table_copy_in_p38(t out nocopy oks_entitlements_pub.output_tbl_entfrm, a0 JTF_NUMBER_TABLE
1470: , a1 JTF_VARCHAR2_TABLE_200
1471: , a2 JTF_VARCHAR2_TABLE_200
1472: , a3 JTF_VARCHAR2_TABLE_300
1473: , a4 JTF_VARCHAR2_TABLE_600

Line 1504: procedure rosetta_table_copy_out_p38(t oks_entitlements_pub.output_tbl_entfrm, a0 out nocopy JTF_NUMBER_TABLE

1500: end loop;
1501: end if;
1502: end if;
1503: end rosetta_table_copy_in_p38;
1504: procedure rosetta_table_copy_out_p38(t oks_entitlements_pub.output_tbl_entfrm, a0 out nocopy JTF_NUMBER_TABLE
1505: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1506: , a2 out nocopy JTF_VARCHAR2_TABLE_200
1507: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1508: , a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 1568: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1564: end if;
1565: end if;
1566: end rosetta_table_copy_out_p38;
1567:
1568: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1569: , a1 JTF_NUMBER_TABLE
1570: , a2 JTF_NUMBER_TABLE
1571: , a3 JTF_VARCHAR2_TABLE_100
1572: ) as

Line 1593: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

1589: end loop;
1590: end if;
1591: end if;
1592: end rosetta_table_copy_in_p41;
1593: procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1594: , a1 out nocopy JTF_NUMBER_TABLE
1595: , a2 out nocopy JTF_NUMBER_TABLE
1596: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1597: ) as

Line 1632: procedure rosetta_table_copy_in_p44(t out nocopy oks_entitlements_pub.covlvl_id_tbl, a0 JTF_NUMBER_TABLE

1628: end if;
1629: end if;
1630: end rosetta_table_copy_out_p41;
1631:
1632: procedure rosetta_table_copy_in_p44(t out nocopy oks_entitlements_pub.covlvl_id_tbl, a0 JTF_NUMBER_TABLE
1633: , a1 JTF_VARCHAR2_TABLE_100
1634: ) as
1635: ddindx binary_integer; indx binary_integer;
1636: begin

Line 1653: procedure rosetta_table_copy_out_p44(t oks_entitlements_pub.covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE

1649: end loop;
1650: end if;
1651: end if;
1652: end rosetta_table_copy_in_p44;
1653: procedure rosetta_table_copy_out_p44(t oks_entitlements_pub.covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
1654: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1655: ) as
1656: ddindx binary_integer; indx binary_integer;
1657: begin

Line 1682: procedure rosetta_table_copy_in_p47(t out nocopy oks_entitlements_pub.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200

1678: end if;
1679: end if;
1680: end rosetta_table_copy_out_p44;
1681:
1682: procedure rosetta_table_copy_in_p47(t out nocopy oks_entitlements_pub.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
1683: , a1 JTF_VARCHAR2_TABLE_200
1684: , a2 JTF_VARCHAR2_TABLE_100
1685: , a3 JTF_VARCHAR2_TABLE_100
1686: , a4 JTF_VARCHAR2_TABLE_300

Line 1725: procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200

1721: end loop;
1722: end if;
1723: end if;
1724: end rosetta_table_copy_in_p47;
1725: procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
1726: , a1 out nocopy JTF_VARCHAR2_TABLE_200
1727: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1728: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1729: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 1809: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE

1805: end if;
1806: end if;
1807: end rosetta_table_copy_out_p47;
1808:
1809: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
1810: , a1 JTF_NUMBER_TABLE
1811: , a2 JTF_NUMBER_TABLE
1812: , a3 JTF_VARCHAR2_TABLE_100
1813: , a4 JTF_NUMBER_TABLE

Line 1840: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE

1836: end loop;
1837: end if;
1838: end if;
1839: end rosetta_table_copy_in_p60;
1840: procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
1841: , a1 out nocopy JTF_NUMBER_TABLE
1842: , a2 out nocopy JTF_NUMBER_TABLE
1843: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1844: , a4 out nocopy JTF_NUMBER_TABLE

Line 1894: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE

1890: end if;
1891: end if;
1892: end rosetta_table_copy_out_p60;
1893:
1894: procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
1895: , a1 JTF_NUMBER_TABLE
1896: , a2 JTF_VARCHAR2_TABLE_100
1897: , a3 JTF_VARCHAR2_TABLE_100
1898: , a4 JTF_VARCHAR2_TABLE_100

Line 1921: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1917: end loop;
1918: end if;
1919: end if;
1920: end rosetta_table_copy_in_p63;
1921: procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1922: , a1 out nocopy JTF_NUMBER_TABLE
1923: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1924: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1925: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1965: procedure rosetta_table_copy_in_p70(t out nocopy oks_entitlements_pub.output_tbl_bp, a0 JTF_NUMBER_TABLE

1961: end if;
1962: end if;
1963: end rosetta_table_copy_out_p63;
1964:
1965: procedure rosetta_table_copy_in_p70(t out nocopy oks_entitlements_pub.output_tbl_bp, a0 JTF_NUMBER_TABLE
1966: , a1 JTF_NUMBER_TABLE
1967: , a2 JTF_DATE_TABLE
1968: , a3 JTF_DATE_TABLE
1969: ) as

Line 1990: procedure rosetta_table_copy_out_p70(t oks_entitlements_pub.output_tbl_bp, a0 out nocopy JTF_NUMBER_TABLE

1986: end loop;
1987: end if;
1988: end if;
1989: end rosetta_table_copy_in_p70;
1990: procedure rosetta_table_copy_out_p70(t oks_entitlements_pub.output_tbl_bp, a0 out nocopy JTF_NUMBER_TABLE
1991: , a1 out nocopy JTF_NUMBER_TABLE
1992: , a2 out nocopy JTF_DATE_TABLE
1993: , a3 out nocopy JTF_DATE_TABLE
1994: ) as

Line 2029: procedure rosetta_table_copy_in_p73(t out nocopy oks_entitlements_pub.output_tbl_bt, a0 JTF_NUMBER_TABLE

2025: end if;
2026: end if;
2027: end rosetta_table_copy_out_p70;
2028:
2029: procedure rosetta_table_copy_in_p73(t out nocopy oks_entitlements_pub.output_tbl_bt, a0 JTF_NUMBER_TABLE
2030: , a1 JTF_NUMBER_TABLE
2031: , a2 JTF_NUMBER_TABLE
2032: , a3 JTF_NUMBER_TABLE
2033: ) as

Line 2054: procedure rosetta_table_copy_out_p73(t oks_entitlements_pub.output_tbl_bt, a0 out nocopy JTF_NUMBER_TABLE

2050: end loop;
2051: end if;
2052: end if;
2053: end rosetta_table_copy_in_p73;
2054: procedure rosetta_table_copy_out_p73(t oks_entitlements_pub.output_tbl_bt, a0 out nocopy JTF_NUMBER_TABLE
2055: , a1 out nocopy JTF_NUMBER_TABLE
2056: , a2 out nocopy JTF_NUMBER_TABLE
2057: , a3 out nocopy JTF_NUMBER_TABLE
2058: ) as

Line 2093: procedure rosetta_table_copy_in_p75(t out nocopy oks_entitlements_pub.output_tbl_br, a0 JTF_NUMBER_TABLE

2089: end if;
2090: end if;
2091: end rosetta_table_copy_out_p73;
2092:
2093: procedure rosetta_table_copy_in_p75(t out nocopy oks_entitlements_pub.output_tbl_br, a0 JTF_NUMBER_TABLE
2094: , a1 JTF_NUMBER_TABLE
2095: , a2 JTF_NUMBER_TABLE
2096: , a3 JTF_VARCHAR2_TABLE_100
2097: , a4 JTF_NUMBER_TABLE

Line 2152: procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE

2148: end loop;
2149: end if;
2150: end if;
2151: end rosetta_table_copy_in_p75;
2152: procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE
2153: , a1 out nocopy JTF_NUMBER_TABLE
2154: , a2 out nocopy JTF_NUMBER_TABLE
2155: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2156: , a4 out nocopy JTF_NUMBER_TABLE

Line 2276: procedure rosetta_table_copy_in_p79(t out nocopy oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 JTF_NUMBER_TABLE

2272: end if;
2273: end if;
2274: end rosetta_table_copy_out_p75;
2275:
2276: procedure rosetta_table_copy_in_p79(t out nocopy oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 JTF_NUMBER_TABLE
2277: , a1 JTF_VARCHAR2_TABLE_100
2278: , a2 JTF_VARCHAR2_TABLE_100
2279: , a3 JTF_DATE_TABLE
2280: , a4 JTF_DATE_TABLE

Line 2313: procedure rosetta_table_copy_out_p79(t oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 out nocopy JTF_NUMBER_TABLE

2309: end loop;
2310: end if;
2311: end if;
2312: end rosetta_table_copy_in_p79;
2313: procedure rosetta_table_copy_out_p79(t oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 out nocopy JTF_NUMBER_TABLE
2314: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2315: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2316: , a3 out nocopy JTF_DATE_TABLE
2317: , a4 out nocopy JTF_DATE_TABLE

Line 2382: procedure rosetta_table_copy_in_p81(t out nocopy oks_entitlements_pub.srchline_covlvl_id_tbl, a0 JTF_NUMBER_TABLE

2378: end if;
2379: end if;
2380: end rosetta_table_copy_out_p79;
2381:
2382: procedure rosetta_table_copy_in_p81(t out nocopy oks_entitlements_pub.srchline_covlvl_id_tbl, a0 JTF_NUMBER_TABLE
2383: , a1 JTF_NUMBER_TABLE
2384: , a2 JTF_VARCHAR2_TABLE_100
2385: ) as
2386: ddindx binary_integer; indx binary_integer;

Line 2405: procedure rosetta_table_copy_out_p81(t oks_entitlements_pub.srchline_covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE

2401: end loop;
2402: end if;
2403: end if;
2404: end rosetta_table_copy_in_p81;
2405: procedure rosetta_table_copy_out_p81(t oks_entitlements_pub.srchline_covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
2406: , a1 out nocopy JTF_NUMBER_TABLE
2407: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2408: ) as
2409: ddindx binary_integer; indx binary_integer;

Line 2439: procedure rosetta_table_copy_in_p83(t out nocopy oks_entitlements_pub.output_tbl_contractline, a0 JTF_VARCHAR2_TABLE_200

2435: end if;
2436: end if;
2437: end rosetta_table_copy_out_p81;
2438:
2439: procedure rosetta_table_copy_in_p83(t out nocopy oks_entitlements_pub.output_tbl_contractline, a0 JTF_VARCHAR2_TABLE_200
2440: , a1 JTF_VARCHAR2_TABLE_200
2441: , a2 JTF_VARCHAR2_TABLE_200
2442: , a3 JTF_VARCHAR2_TABLE_200
2443: , a4 JTF_VARCHAR2_TABLE_2000

Line 2492: procedure rosetta_table_copy_out_p83(t oks_entitlements_pub.output_tbl_contractline, a0 out nocopy JTF_VARCHAR2_TABLE_200

2488: end loop;
2489: end if;
2490: end if;
2491: end rosetta_table_copy_in_p83;
2492: procedure rosetta_table_copy_out_p83(t oks_entitlements_pub.output_tbl_contractline, a0 out nocopy JTF_VARCHAR2_TABLE_200
2493: , a1 out nocopy JTF_VARCHAR2_TABLE_200
2494: , a2 out nocopy JTF_VARCHAR2_TABLE_200
2495: , a3 out nocopy JTF_VARCHAR2_TABLE_200
2496: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 2652: ddp_inp_rec oks_entitlements_pub.inp_rec_type;

2648: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
2649: )
2650:
2651: as
2652: ddp_inp_rec oks_entitlements_pub.inp_rec_type;
2653: ddx_all_contracts oks_entitlements_pub.hdr_tbl_type;
2654: ddindx binary_integer; indx binary_integer;
2655: begin
2656:

Line 2653: ddx_all_contracts oks_entitlements_pub.hdr_tbl_type;

2649: )
2650:
2651: as
2652: ddp_inp_rec oks_entitlements_pub.inp_rec_type;
2653: ddx_all_contracts oks_entitlements_pub.hdr_tbl_type;
2654: ddindx binary_integer; indx binary_integer;
2655: begin
2656:
2657: -- copy data to the local IN or IN-OUT args, if any

Line 2671: oks_entitlements_pub.get_all_contracts(p_api_version,

2667:
2668:
2669:
2670: -- here's the delegated call to the old PL/SQL routine
2671: oks_entitlements_pub.get_all_contracts(p_api_version,
2672: p_init_msg_list,
2673: ddp_inp_rec,
2674: x_return_status,
2675: x_msg_count,

Line 2686: oks_entitlements_pub_w.rosetta_table_copy_out_p16(ddx_all_contracts, p6_a0

2682:
2683:
2684:
2685:
2686: oks_entitlements_pub_w.rosetta_table_copy_out_p16(ddx_all_contracts, p6_a0
2687: , p6_a1
2688: , p6_a2
2689: , p6_a3
2690: , p6_a4

Line 2758: ddx_all_lines oks_entitlements_pub.line_tbl_type;

2754: , p6_a21 out nocopy JTF_DATE_TABLE
2755: )
2756:
2757: as
2758: ddx_all_lines oks_entitlements_pub.line_tbl_type;
2759: ddindx binary_integer; indx binary_integer;
2760: begin
2761:
2762: -- copy data to the local IN or IN-OUT args, if any

Line 2771: oks_entitlements_pub.get_contract_details(p_api_version,

2767:
2768:
2769:
2770: -- here's the delegated call to the old PL/SQL routine
2771: oks_entitlements_pub.get_contract_details(p_api_version,
2772: p_init_msg_list,
2773: p_contract_line_id,
2774: x_return_status,
2775: x_msg_count,

Line 2786: oks_entitlements_pub_w.rosetta_table_copy_out_p19(ddx_all_lines, p6_a0

2782:
2783:
2784:
2785:
2786: oks_entitlements_pub_w.rosetta_table_copy_out_p19(ddx_all_lines, p6_a0
2787: , p6_a1
2788: , p6_a2
2789: , p6_a3
2790: , p6_a4

Line 2855: ddx_covered_levels oks_entitlements_pub.clvl_tbl_type;

2851: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
2852: )
2853:
2854: as
2855: ddx_covered_levels oks_entitlements_pub.clvl_tbl_type;
2856: ddindx binary_integer; indx binary_integer;
2857: begin
2858:
2859: -- copy data to the local IN or IN-OUT args, if any

Line 2868: oks_entitlements_pub.get_coverage_levels(p_api_version,

2864:
2865:
2866:
2867: -- here's the delegated call to the old PL/SQL routine
2868: oks_entitlements_pub.get_coverage_levels(p_api_version,
2869: p_init_msg_list,
2870: p_contract_line_id,
2871: x_return_status,
2872: x_msg_count,

Line 2883: oks_entitlements_pub_w.rosetta_table_copy_out_p22(ddx_covered_levels, p6_a0

2879:
2880:
2881:
2882:
2883: oks_entitlements_pub_w.rosetta_table_copy_out_p22(ddx_covered_levels, p6_a0
2884: , p6_a1
2885: , p6_a2
2886: , p6_a3
2887: , p6_a4

Line 2960: ddp_inp_rec oks_entitlements_pub.inp_cont_rec;

2956: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2957: )
2958:
2959: as
2960: ddp_inp_rec oks_entitlements_pub.inp_cont_rec;
2961: ddx_ent_contracts oks_entitlements_pub.ent_cont_tbl;
2962: ddindx binary_integer; indx binary_integer;
2963: begin
2964:

Line 2961: ddx_ent_contracts oks_entitlements_pub.ent_cont_tbl;

2957: )
2958:
2959: as
2960: ddp_inp_rec oks_entitlements_pub.inp_cont_rec;
2961: ddx_ent_contracts oks_entitlements_pub.ent_cont_tbl;
2962: ddindx binary_integer; indx binary_integer;
2963: begin
2964:
2965: -- copy data to the local IN or IN-OUT args, if any

Line 2985: oks_entitlements_pub.get_contracts(p_api_version,

2981:
2982:
2983:
2984: -- here's the delegated call to the old PL/SQL routine
2985: oks_entitlements_pub.get_contracts(p_api_version,
2986: p_init_msg_list,
2987: ddp_inp_rec,
2988: x_return_status,
2989: x_msg_count,

Line 3000: oks_entitlements_pub_w.rosetta_table_copy_out_p26(ddx_ent_contracts, p6_a0

2996:
2997:
2998:
2999:
3000: oks_entitlements_pub_w.rosetta_table_copy_out_p26(ddx_ent_contracts, p6_a0
3001: , p6_a1
3002: , p6_a2
3003: , p6_a3
3004: , p6_a4

Line 3080: ddp_inp_rec oks_entitlements_pub.get_contin_rec;

3076: , p2_a20 NUMBER
3077: )
3078:
3079: as
3080: ddp_inp_rec oks_entitlements_pub.get_contin_rec;
3081: ddx_ent_contracts oks_entitlements_pub.get_contop_tbl;
3082: ddindx binary_integer; indx binary_integer;
3083: begin
3084:

Line 3081: ddx_ent_contracts oks_entitlements_pub.get_contop_tbl;

3077: )
3078:
3079: as
3080: ddp_inp_rec oks_entitlements_pub.get_contin_rec;
3081: ddx_ent_contracts oks_entitlements_pub.get_contop_tbl;
3082: ddindx binary_integer; indx binary_integer;
3083: begin
3084:
3085: -- copy data to the local IN or IN-OUT args, if any

Line 3116: oks_entitlements_pub.get_contracts(p_api_version,

3112:
3113:
3114:
3115: -- here's the delegated call to the old PL/SQL routine
3116: oks_entitlements_pub.get_contracts(p_api_version,
3117: p_init_msg_list,
3118: ddp_inp_rec,
3119: x_return_status,
3120: x_msg_count,

Line 3131: oks_entitlements_pub_w.rosetta_table_copy_out_p30(ddx_ent_contracts, p6_a0

3127:
3128:
3129:
3130:
3131: oks_entitlements_pub_w.rosetta_table_copy_out_p30(ddx_ent_contracts, p6_a0
3132: , p6_a1
3133: , p6_a2
3134: , p6_a3
3135: , p6_a4

Line 3207: ddp_inp_rec oks_entitlements_pub.input_rec_ib;

3203: , p6_a21 out nocopy JTF_NUMBER_TABLE
3204: )
3205:
3206: as
3207: ddp_inp_rec oks_entitlements_pub.input_rec_ib;
3208: ddx_ent_contracts oks_entitlements_pub.output_tbl_ib;
3209: ddindx binary_integer; indx binary_integer;
3210: begin
3211:

Line 3208: ddx_ent_contracts oks_entitlements_pub.output_tbl_ib;

3204: )
3205:
3206: as
3207: ddp_inp_rec oks_entitlements_pub.input_rec_ib;
3208: ddx_ent_contracts oks_entitlements_pub.output_tbl_ib;
3209: ddindx binary_integer; indx binary_integer;
3210: begin
3211:
3212: -- copy data to the local IN or IN-OUT args, if any

Line 3236: oks_entitlements_pub.get_contracts(p_api_version,

3232:
3233:
3234:
3235: -- here's the delegated call to the old PL/SQL routine
3236: oks_entitlements_pub.get_contracts(p_api_version,
3237: p_init_msg_list,
3238: ddp_inp_rec,
3239: x_return_status,
3240: x_msg_count,

Line 3251: oks_entitlements_pub_w.rosetta_table_copy_out_p34(ddx_ent_contracts, p6_a0

3247:
3248:
3249:
3250:
3251: oks_entitlements_pub_w.rosetta_table_copy_out_p34(ddx_ent_contracts, p6_a0
3252: , p6_a1
3253: , p6_a2
3254: , p6_a3
3255: , p6_a4

Line 3305: ddp_inp_rec oks_entitlements_pub.input_rec_entfrm;

3301: , p6_a8 out nocopy JTF_DATE_TABLE
3302: )
3303:
3304: as
3305: ddp_inp_rec oks_entitlements_pub.input_rec_entfrm;
3306: ddx_ent_contracts oks_entitlements_pub.output_tbl_entfrm;
3307: ddindx binary_integer; indx binary_integer;
3308: begin
3309:

Line 3306: ddx_ent_contracts oks_entitlements_pub.output_tbl_entfrm;

3302: )
3303:
3304: as
3305: ddp_inp_rec oks_entitlements_pub.input_rec_entfrm;
3306: ddx_ent_contracts oks_entitlements_pub.output_tbl_entfrm;
3307: ddindx binary_integer; indx binary_integer;
3308: begin
3309:
3310: -- copy data to the local IN or IN-OUT args, if any

Line 3331: oks_entitlements_pub.get_contracts(p_api_version,

3327:
3328:
3329:
3330: -- here's the delegated call to the old PL/SQL routine
3331: oks_entitlements_pub.get_contracts(p_api_version,
3332: p_init_msg_list,
3333: ddp_inp_rec,
3334: x_return_status,
3335: x_msg_count,

Line 3346: oks_entitlements_pub_w.rosetta_table_copy_out_p38(ddx_ent_contracts, p6_a0

3342:
3343:
3344:
3345:
3346: oks_entitlements_pub_w.rosetta_table_copy_out_p38(ddx_ent_contracts, p6_a0
3347: , p6_a1
3348: , p6_a2
3349: , p6_a3
3350: , p6_a4

Line 3380: ddp_covlevel_tbl_in oks_entitlements_pub.covlevel_tbl_type;

3376: )
3377:
3378: as
3379: ddp_request_date date;
3380: ddp_covlevel_tbl_in oks_entitlements_pub.covlevel_tbl_type;
3381: ddx_covlevel_tbl_out oks_entitlements_pub.covlevel_tbl_type;
3382: ddindx binary_integer; indx binary_integer;
3383: begin
3384:

Line 3381: ddx_covlevel_tbl_out oks_entitlements_pub.covlevel_tbl_type;

3377:
3378: as
3379: ddp_request_date date;
3380: ddp_covlevel_tbl_in oks_entitlements_pub.covlevel_tbl_type;
3381: ddx_covlevel_tbl_out oks_entitlements_pub.covlevel_tbl_type;
3382: ddindx binary_integer; indx binary_integer;
3383: begin
3384:
3385: -- copy data to the local IN or IN-OUT args, if any

Line 3392: oks_entitlements_pub_w.rosetta_table_copy_in_p41(ddp_covlevel_tbl_in, p5_a0

3388:
3389:
3390: ddp_request_date := rosetta_g_miss_date_in_map(p_request_date);
3391:
3392: oks_entitlements_pub_w.rosetta_table_copy_in_p41(ddp_covlevel_tbl_in, p5_a0
3393: , p5_a1
3394: , p5_a2
3395: , p5_a3
3396: );

Line 3405: oks_entitlements_pub.validate_contract_line(p_api_version,

3401:
3402:
3403:
3404: -- here's the delegated call to the old PL/SQL routine
3405: oks_entitlements_pub.validate_contract_line(p_api_version,
3406: p_init_msg_list,
3407: p_contract_line_id,
3408: p_busiproc_id,
3409: ddp_request_date,

Line 3429: oks_entitlements_pub_w.rosetta_table_copy_out_p41(ddx_covlevel_tbl_out, p10_a0

3425:
3426:
3427:
3428:
3429: oks_entitlements_pub_w.rosetta_table_copy_out_p41(ddx_covlevel_tbl_out, p10_a0
3430: , p10_a1
3431: , p10_a2
3432: , p10_a3
3433: );

Line 3472: ddp_contract_rec oks_entitlements_pub.inp_cont_rec_type;

3468: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
3469: )
3470:
3471: as
3472: ddp_contract_rec oks_entitlements_pub.inp_cont_rec_type;
3473: ddp_clvl_id_tbl oks_entitlements_pub.covlvl_id_tbl;
3474: ddx_contract_tbl oks_entitlements_pub.output_tbl_contract;
3475: ddindx binary_integer; indx binary_integer;
3476: begin

Line 3473: ddp_clvl_id_tbl oks_entitlements_pub.covlvl_id_tbl;

3469: )
3470:
3471: as
3472: ddp_contract_rec oks_entitlements_pub.inp_cont_rec_type;
3473: ddp_clvl_id_tbl oks_entitlements_pub.covlvl_id_tbl;
3474: ddx_contract_tbl oks_entitlements_pub.output_tbl_contract;
3475: ddindx binary_integer; indx binary_integer;
3476: begin
3477:

Line 3474: ddx_contract_tbl oks_entitlements_pub.output_tbl_contract;

3470:
3471: as
3472: ddp_contract_rec oks_entitlements_pub.inp_cont_rec_type;
3473: ddp_clvl_id_tbl oks_entitlements_pub.covlvl_id_tbl;
3474: ddx_contract_tbl oks_entitlements_pub.output_tbl_contract;
3475: ddindx binary_integer; indx binary_integer;
3476: begin
3477:
3478: -- copy data to the local IN or IN-OUT args, if any

Line 3494: oks_entitlements_pub_w.rosetta_table_copy_in_p44(ddp_clvl_id_tbl, p3_a0

3490: ddp_contract_rec.contract_party_id := p2_a9;
3491: ddp_contract_rec.request_date := rosetta_g_miss_date_in_map(p2_a10);
3492: ddp_contract_rec.entitlement_check_yn := p2_a11;
3493:
3494: oks_entitlements_pub_w.rosetta_table_copy_in_p44(ddp_clvl_id_tbl, p3_a0
3495: , p3_a1
3496: );
3497:
3498:

Line 3503: oks_entitlements_pub.search_contracts(p_api_version,

3499:
3500:
3501:
3502: -- here's the delegated call to the old PL/SQL routine
3503: oks_entitlements_pub.search_contracts(p_api_version,
3504: p_init_msg_list,
3505: ddp_contract_rec,
3506: ddp_clvl_id_tbl,
3507: x_return_status,

Line 3520: oks_entitlements_pub_w.rosetta_table_copy_out_p47(ddx_contract_tbl, p7_a0

3516:
3517:
3518:
3519:
3520: oks_entitlements_pub_w.rosetta_table_copy_out_p47(ddx_contract_tbl, p7_a0
3521: , p7_a1
3522: , p7_a2
3523: , p7_a3
3524: , p7_a4

Line 3564: ddp_inp_rec oks_entitlements_pub.grt_inp_rec_type;

3560: , p2_a11 NUMBER
3561: )
3562:
3563: as
3564: ddp_inp_rec oks_entitlements_pub.grt_inp_rec_type;
3565: ddx_react_rec oks_entitlements_pub.rcn_rsn_rec_type;
3566: ddx_resolve_rec oks_entitlements_pub.rcn_rsn_rec_type;
3567: ddindx binary_integer; indx binary_integer;
3568: begin

Line 3565: ddx_react_rec oks_entitlements_pub.rcn_rsn_rec_type;

3561: )
3562:
3563: as
3564: ddp_inp_rec oks_entitlements_pub.grt_inp_rec_type;
3565: ddx_react_rec oks_entitlements_pub.rcn_rsn_rec_type;
3566: ddx_resolve_rec oks_entitlements_pub.rcn_rsn_rec_type;
3567: ddindx binary_integer; indx binary_integer;
3568: begin
3569:

Line 3566: ddx_resolve_rec oks_entitlements_pub.rcn_rsn_rec_type;

3562:
3563: as
3564: ddp_inp_rec oks_entitlements_pub.grt_inp_rec_type;
3565: ddx_react_rec oks_entitlements_pub.rcn_rsn_rec_type;
3566: ddx_resolve_rec oks_entitlements_pub.rcn_rsn_rec_type;
3567: ddindx binary_integer; indx binary_integer;
3568: begin
3569:
3570: -- copy data to the local IN or IN-OUT args, if any

Line 3593: oks_entitlements_pub.get_react_resolve_by_time(p_api_version,

3589:
3590:
3591:
3592: -- here's the delegated call to the old PL/SQL routine
3593: oks_entitlements_pub.get_react_resolve_by_time(p_api_version,
3594: p_init_msg_list,
3595: ddp_inp_rec,
3596: x_return_status,
3597: x_msg_count,

Line 3632: ddx_coverage_type oks_entitlements_pub.covtype_rec_type;

3628: , p6_a2 out nocopy NUMBER
3629: )
3630:
3631: as
3632: ddx_coverage_type oks_entitlements_pub.covtype_rec_type;
3633: ddindx binary_integer; indx binary_integer;
3634: begin
3635:
3636: -- copy data to the local IN or IN-OUT args, if any

Line 3645: oks_entitlements_pub.get_coverage_type(p_api_version,

3641:
3642:
3643:
3644: -- here's the delegated call to the old PL/SQL routine
3645: oks_entitlements_pub.get_coverage_type(p_api_version,
3646: p_init_msg_list,
3647: p_contract_line_id,
3648: x_return_status,
3649: x_msg_count,

Line 3682: ddx_importance_lvl oks_entitlements_pub.high_imp_level_k_rec;

3678: , p6_a7 out nocopy NUMBER
3679: )
3680:
3681: as
3682: ddx_importance_lvl oks_entitlements_pub.high_imp_level_k_rec;
3683: ddindx binary_integer; indx binary_integer;
3684: begin
3685:
3686: -- copy data to the local IN or IN-OUT args, if any

Line 3695: oks_entitlements_pub.get_highimp_cp_contract(p_api_version,

3691:
3692:
3693:
3694: -- here's the delegated call to the old PL/SQL routine
3695: oks_entitlements_pub.get_highimp_cp_contract(p_api_version,
3696: p_init_msg_list,
3697: p_customer_product_id,
3698: x_return_status,
3699: x_msg_count,

Line 3752: oks_entitlements_pub.check_coverage_times(p_api_version,

3748:
3749:
3750:
3751: -- here's the delegated call to the old PL/SQL routine
3752: oks_entitlements_pub.check_coverage_times(p_api_version,
3753: p_init_msg_list,
3754: p_business_process_id,
3755: ddp_request_date,
3756: p_time_zone_id,

Line 3818: oks_entitlements_pub.check_reaction_times(p_api_version,

3814:
3815:
3816:
3817: -- here's the delegated call to the old PL/SQL routine
3818: oks_entitlements_pub.check_reaction_times(p_api_version,
3819: p_init_msg_list,
3820: p_business_process_id,
3821: ddp_request_date,
3822: p_sr_severity,

Line 3869: ddx_ent_contacts oks_entitlements_pub.ent_contact_tbl;

3865: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
3866: )
3867:
3868: as
3869: ddx_ent_contacts oks_entitlements_pub.ent_contact_tbl;
3870: ddindx binary_integer; indx binary_integer;
3871: begin
3872:
3873: -- copy data to the local IN or IN-OUT args, if any

Line 3883: oks_entitlements_pub.get_contacts(p_api_version,

3879:
3880:
3881:
3882: -- here's the delegated call to the old PL/SQL routine
3883: oks_entitlements_pub.get_contacts(p_api_version,
3884: p_init_msg_list,
3885: p_contract_id,
3886: p_contract_line_id,
3887: x_return_status,

Line 3900: oks_entitlements_pub_w.rosetta_table_copy_out_p60(ddx_ent_contacts, p7_a0

3896:
3897:
3898:
3899:
3900: oks_entitlements_pub_w.rosetta_table_copy_out_p60(ddx_ent_contacts, p7_a0
3901: , p7_a1
3902: , p7_a2
3903: , p7_a3
3904: , p7_a4

Line 3927: ddx_prf_engineers oks_entitlements_pub.prfeng_tbl_type;

3923: )
3924:
3925: as
3926: ddp_request_date date;
3927: ddx_prf_engineers oks_entitlements_pub.prfeng_tbl_type;
3928: ddindx binary_integer; indx binary_integer;
3929: begin
3930:
3931: -- copy data to the local IN or IN-OUT args, if any

Line 3943: oks_entitlements_pub.get_preferred_engineers(p_api_version,

3939:
3940:
3941:
3942: -- here's the delegated call to the old PL/SQL routine
3943: oks_entitlements_pub.get_preferred_engineers(p_api_version,
3944: p_init_msg_list,
3945: p_contract_line_id,
3946: p_business_process_id,
3947: ddp_request_date,

Line 3962: oks_entitlements_pub_w.rosetta_table_copy_out_p63(ddx_prf_engineers, p8_a0

3958:
3959:
3960:
3961:
3962: oks_entitlements_pub_w.rosetta_table_copy_out_p63(ddx_prf_engineers, p8_a0
3963: , p8_a1
3964: , p8_a2
3965: , p8_a3
3966: , p8_a4

Line 3998: oks_entitlements_pub.oks_validate_system(p_api_version,

3994:
3995:
3996:
3997: -- here's the delegated call to the old PL/SQL routine
3998: oks_entitlements_pub.oks_validate_system(p_api_version,
3999: p_init_msg_list,
4000: p_system_id,
4001: ddp_request_date,
4002: p_update_only_check,

Line 4058: ddx_ent_contracts oks_entitlements_pub.default_contline_system_rec;

4054: )
4055:
4056: as
4057: ddp_request_date date;
4058: ddx_ent_contracts oks_entitlements_pub.default_contline_system_rec;
4059: ddindx binary_integer; indx binary_integer;
4060: begin
4061:
4062: -- copy data to the local IN or IN-OUT args, if any

Line 4073: oks_entitlements_pub.default_contline_system(p_api_version,

4069:
4070:
4071:
4072: -- here's the delegated call to the old PL/SQL routine
4073: oks_entitlements_pub.default_contline_system(p_api_version,
4074: p_init_msg_list,
4075: p_system_id,
4076: ddp_request_date,
4077: x_return_status,

Line 4137: ddp_inp_rec_bp oks_entitlements_pub.inp_rec_bp;

4133: , p6_a3 out nocopy JTF_DATE_TABLE
4134: )
4135:
4136: as
4137: ddp_inp_rec_bp oks_entitlements_pub.inp_rec_bp;
4138: ddx_cov_txn_grp_lines oks_entitlements_pub.output_tbl_bp;
4139: ddindx binary_integer; indx binary_integer;
4140: begin
4141:

Line 4138: ddx_cov_txn_grp_lines oks_entitlements_pub.output_tbl_bp;

4134: )
4135:
4136: as
4137: ddp_inp_rec_bp oks_entitlements_pub.inp_rec_bp;
4138: ddx_cov_txn_grp_lines oks_entitlements_pub.output_tbl_bp;
4139: ddindx binary_integer; indx binary_integer;
4140: begin
4141:
4142: -- copy data to the local IN or IN-OUT args, if any

Line 4156: oks_entitlements_pub.get_cov_txn_groups(p_api_version,

4152:
4153:
4154:
4155: -- here's the delegated call to the old PL/SQL routine
4156: oks_entitlements_pub.get_cov_txn_groups(p_api_version,
4157: p_init_msg_list,
4158: ddp_inp_rec_bp,
4159: x_return_status,
4160: x_msg_count,

Line 4171: oks_entitlements_pub_w.rosetta_table_copy_out_p70(ddx_cov_txn_grp_lines, p6_a0

4167:
4168:
4169:
4170:
4171: oks_entitlements_pub_w.rosetta_table_copy_out_p70(ddx_cov_txn_grp_lines, p6_a0
4172: , p6_a1
4173: , p6_a2
4174: , p6_a3
4175: );

Line 4213: ddx_txn_bill_types oks_entitlements_pub.output_tbl_bt;

4209: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
4210: )
4211:
4212: as
4213: ddx_txn_bill_types oks_entitlements_pub.output_tbl_bt;
4214: ddx_txn_bill_rates oks_entitlements_pub.output_tbl_br;
4215: ddindx binary_integer; indx binary_integer;
4216: begin
4217:

Line 4214: ddx_txn_bill_rates oks_entitlements_pub.output_tbl_br;

4210: )
4211:
4212: as
4213: ddx_txn_bill_types oks_entitlements_pub.output_tbl_bt;
4214: ddx_txn_bill_rates oks_entitlements_pub.output_tbl_br;
4215: ddindx binary_integer; indx binary_integer;
4216: begin
4217:
4218: -- copy data to the local IN or IN-OUT args, if any

Line 4229: oks_entitlements_pub.get_txn_billing_types(p_api_version,

4225:
4226:
4227:
4228: -- here's the delegated call to the old PL/SQL routine
4229: oks_entitlements_pub.get_txn_billing_types(p_api_version,
4230: p_init_msg_list,
4231: p_cov_txngrp_line_id,
4232: p_return_bill_rates_yn,
4233: x_return_status,

Line 4247: oks_entitlements_pub_w.rosetta_table_copy_out_p73(ddx_txn_bill_types, p7_a0

4243:
4244:
4245:
4246:
4247: oks_entitlements_pub_w.rosetta_table_copy_out_p73(ddx_txn_bill_types, p7_a0
4248: , p7_a1
4249: , p7_a2
4250: , p7_a3
4251: );

Line 4253: oks_entitlements_pub_w.rosetta_table_copy_out_p75(ddx_txn_bill_rates, p8_a0

4249: , p7_a2
4250: , p7_a3
4251: );
4252:
4253: oks_entitlements_pub_w.rosetta_table_copy_out_p75(ddx_txn_bill_rates, p8_a0
4254: , p8_a1
4255: , p8_a2
4256: , p8_a3
4257: , p8_a4

Line 4332: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;

4328: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_300
4329: )
4330:
4331: as
4332: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;
4333: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;
4334: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;
4335: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;
4336: ddindx binary_integer; indx binary_integer;

Line 4333: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;

4329: )
4330:
4331: as
4332: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;
4333: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;
4334: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;
4335: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;
4336: ddindx binary_integer; indx binary_integer;
4337: begin

Line 4334: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;

4330:
4331: as
4332: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;
4333: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;
4334: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;
4335: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;
4336: ddindx binary_integer; indx binary_integer;
4337: begin
4338:

Line 4335: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;

4331: as
4332: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;
4333: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;
4334: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;
4335: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;
4336: ddindx binary_integer; indx binary_integer;
4337: begin
4338:
4339: -- copy data to the local IN or IN-OUT args, if any

Line 4370: oks_entitlements_pub_w.rosetta_table_copy_in_p81(ddp_clvl_id_tbl, p4_a0

4366: ddp_contract_line_rec.line_bill_to_site_id := p3_a7;
4367: ddp_contract_line_rec.line_ship_to_site_id := p3_a8;
4368: ddp_contract_line_rec.line_renewal_type_code := p3_a9;
4369:
4370: oks_entitlements_pub_w.rosetta_table_copy_in_p81(ddp_clvl_id_tbl, p4_a0
4371: , p4_a1
4372: , p4_a2
4373: );
4374:

Line 4380: oks_entitlements_pub.search_contract_lines(p_api_version,

4376:
4377:
4378:
4379: -- here's the delegated call to the old PL/SQL routine
4380: oks_entitlements_pub.search_contract_lines(p_api_version,
4381: p_init_msg_list,
4382: ddp_contract_rec,
4383: ddp_contract_line_rec,
4384: ddp_clvl_id_tbl,

Line 4399: oks_entitlements_pub_w.rosetta_table_copy_out_p83(ddx_contract_tbl, p8_a0

4395:
4396:
4397:
4398:
4399: oks_entitlements_pub_w.rosetta_table_copy_out_p83(ddx_contract_tbl, p8_a0
4400: , p8_a1
4401: , p8_a2
4402: , p8_a3
4403: , p8_a4

Line 4420: end oks_entitlements_pub_w;

4416: , p8_a17
4417: );
4418: end;
4419:
4420: end oks_entitlements_pub_w;