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.3 2005/12/22 10:52 jvarghes noship $ */
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 3077: ddp_inp_rec oks_entitlements_pub.get_contin_rec;

3073: , p6_a27 out nocopy JTF_NUMBER_TABLE
3074: )
3075:
3076: as
3077: ddp_inp_rec oks_entitlements_pub.get_contin_rec;
3078: ddx_ent_contracts oks_entitlements_pub.get_contop_tbl;
3079: ddindx binary_integer; indx binary_integer;
3080: begin
3081:

Line 3078: ddx_ent_contracts oks_entitlements_pub.get_contop_tbl;

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

Line 3109: oks_entitlements_pub.get_contracts(p_api_version,

3105:
3106:
3107:
3108: -- here's the delegated call to the old PL/SQL routine
3109: oks_entitlements_pub.get_contracts(p_api_version,
3110: p_init_msg_list,
3111: ddp_inp_rec,
3112: x_return_status,
3113: x_msg_count,

Line 3124: oks_entitlements_pub_w.rosetta_table_copy_out_p30(ddx_ent_contracts, p6_a0

3120:
3121:
3122:
3123:
3124: oks_entitlements_pub_w.rosetta_table_copy_out_p30(ddx_ent_contracts, p6_a0
3125: , p6_a1
3126: , p6_a2
3127: , p6_a3
3128: , p6_a4

Line 3200: ddp_inp_rec oks_entitlements_pub.input_rec_ib;

3196: , p6_a21 out nocopy JTF_NUMBER_TABLE
3197: )
3198:
3199: as
3200: ddp_inp_rec oks_entitlements_pub.input_rec_ib;
3201: ddx_ent_contracts oks_entitlements_pub.output_tbl_ib;
3202: ddindx binary_integer; indx binary_integer;
3203: begin
3204:

Line 3201: ddx_ent_contracts oks_entitlements_pub.output_tbl_ib;

3197: )
3198:
3199: as
3200: ddp_inp_rec oks_entitlements_pub.input_rec_ib;
3201: ddx_ent_contracts oks_entitlements_pub.output_tbl_ib;
3202: ddindx binary_integer; indx binary_integer;
3203: begin
3204:
3205: -- copy data to the local IN or IN-OUT args, if any

Line 3229: oks_entitlements_pub.get_contracts(p_api_version,

3225:
3226:
3227:
3228: -- here's the delegated call to the old PL/SQL routine
3229: oks_entitlements_pub.get_contracts(p_api_version,
3230: p_init_msg_list,
3231: ddp_inp_rec,
3232: x_return_status,
3233: x_msg_count,

Line 3244: oks_entitlements_pub_w.rosetta_table_copy_out_p34(ddx_ent_contracts, p6_a0

3240:
3241:
3242:
3243:
3244: oks_entitlements_pub_w.rosetta_table_copy_out_p34(ddx_ent_contracts, p6_a0
3245: , p6_a1
3246: , p6_a2
3247: , p6_a3
3248: , p6_a4

Line 3298: ddp_inp_rec oks_entitlements_pub.input_rec_entfrm;

3294: , p6_a8 out nocopy JTF_DATE_TABLE
3295: )
3296:
3297: as
3298: ddp_inp_rec oks_entitlements_pub.input_rec_entfrm;
3299: ddx_ent_contracts oks_entitlements_pub.output_tbl_entfrm;
3300: ddindx binary_integer; indx binary_integer;
3301: begin
3302:

Line 3299: ddx_ent_contracts oks_entitlements_pub.output_tbl_entfrm;

3295: )
3296:
3297: as
3298: ddp_inp_rec oks_entitlements_pub.input_rec_entfrm;
3299: ddx_ent_contracts oks_entitlements_pub.output_tbl_entfrm;
3300: ddindx binary_integer; indx binary_integer;
3301: begin
3302:
3303: -- copy data to the local IN or IN-OUT args, if any

Line 3324: oks_entitlements_pub.get_contracts(p_api_version,

3320:
3321:
3322:
3323: -- here's the delegated call to the old PL/SQL routine
3324: oks_entitlements_pub.get_contracts(p_api_version,
3325: p_init_msg_list,
3326: ddp_inp_rec,
3327: x_return_status,
3328: x_msg_count,

Line 3339: oks_entitlements_pub_w.rosetta_table_copy_out_p38(ddx_ent_contracts, p6_a0

3335:
3336:
3337:
3338:
3339: oks_entitlements_pub_w.rosetta_table_copy_out_p38(ddx_ent_contracts, p6_a0
3340: , p6_a1
3341: , p6_a2
3342: , p6_a3
3343: , p6_a4

Line 3373: ddp_covlevel_tbl_in oks_entitlements_pub.covlevel_tbl_type;

3369: )
3370:
3371: as
3372: ddp_request_date date;
3373: ddp_covlevel_tbl_in oks_entitlements_pub.covlevel_tbl_type;
3374: ddx_covlevel_tbl_out oks_entitlements_pub.covlevel_tbl_type;
3375: ddindx binary_integer; indx binary_integer;
3376: begin
3377:

Line 3374: ddx_covlevel_tbl_out oks_entitlements_pub.covlevel_tbl_type;

3370:
3371: as
3372: ddp_request_date date;
3373: ddp_covlevel_tbl_in oks_entitlements_pub.covlevel_tbl_type;
3374: ddx_covlevel_tbl_out oks_entitlements_pub.covlevel_tbl_type;
3375: ddindx binary_integer; indx binary_integer;
3376: begin
3377:
3378: -- copy data to the local IN or IN-OUT args, if any

Line 3385: oks_entitlements_pub_w.rosetta_table_copy_in_p41(ddp_covlevel_tbl_in, p5_a0

3381:
3382:
3383: ddp_request_date := rosetta_g_miss_date_in_map(p_request_date);
3384:
3385: oks_entitlements_pub_w.rosetta_table_copy_in_p41(ddp_covlevel_tbl_in, p5_a0
3386: , p5_a1
3387: , p5_a2
3388: , p5_a3
3389: );

Line 3398: oks_entitlements_pub.validate_contract_line(p_api_version,

3394:
3395:
3396:
3397: -- here's the delegated call to the old PL/SQL routine
3398: oks_entitlements_pub.validate_contract_line(p_api_version,
3399: p_init_msg_list,
3400: p_contract_line_id,
3401: p_busiproc_id,
3402: ddp_request_date,

Line 3422: oks_entitlements_pub_w.rosetta_table_copy_out_p41(ddx_covlevel_tbl_out, p10_a0

3418:
3419:
3420:
3421:
3422: oks_entitlements_pub_w.rosetta_table_copy_out_p41(ddx_covlevel_tbl_out, p10_a0
3423: , p10_a1
3424: , p10_a2
3425: , p10_a3
3426: );

Line 3465: ddp_contract_rec oks_entitlements_pub.inp_cont_rec_type;

3461: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
3462: )
3463:
3464: as
3465: ddp_contract_rec oks_entitlements_pub.inp_cont_rec_type;
3466: ddp_clvl_id_tbl oks_entitlements_pub.covlvl_id_tbl;
3467: ddx_contract_tbl oks_entitlements_pub.output_tbl_contract;
3468: ddindx binary_integer; indx binary_integer;
3469: begin

Line 3466: ddp_clvl_id_tbl oks_entitlements_pub.covlvl_id_tbl;

3462: )
3463:
3464: as
3465: ddp_contract_rec oks_entitlements_pub.inp_cont_rec_type;
3466: ddp_clvl_id_tbl oks_entitlements_pub.covlvl_id_tbl;
3467: ddx_contract_tbl oks_entitlements_pub.output_tbl_contract;
3468: ddindx binary_integer; indx binary_integer;
3469: begin
3470:

Line 3467: ddx_contract_tbl oks_entitlements_pub.output_tbl_contract;

3463:
3464: as
3465: ddp_contract_rec oks_entitlements_pub.inp_cont_rec_type;
3466: ddp_clvl_id_tbl oks_entitlements_pub.covlvl_id_tbl;
3467: ddx_contract_tbl oks_entitlements_pub.output_tbl_contract;
3468: ddindx binary_integer; indx binary_integer;
3469: begin
3470:
3471: -- copy data to the local IN or IN-OUT args, if any

Line 3487: oks_entitlements_pub_w.rosetta_table_copy_in_p44(ddp_clvl_id_tbl, p3_a0

3483: ddp_contract_rec.contract_party_id := p2_a9;
3484: ddp_contract_rec.request_date := rosetta_g_miss_date_in_map(p2_a10);
3485: ddp_contract_rec.entitlement_check_yn := p2_a11;
3486:
3487: oks_entitlements_pub_w.rosetta_table_copy_in_p44(ddp_clvl_id_tbl, p3_a0
3488: , p3_a1
3489: );
3490:
3491:

Line 3496: oks_entitlements_pub.search_contracts(p_api_version,

3492:
3493:
3494:
3495: -- here's the delegated call to the old PL/SQL routine
3496: oks_entitlements_pub.search_contracts(p_api_version,
3497: p_init_msg_list,
3498: ddp_contract_rec,
3499: ddp_clvl_id_tbl,
3500: x_return_status,

Line 3513: oks_entitlements_pub_w.rosetta_table_copy_out_p47(ddx_contract_tbl, p7_a0

3509:
3510:
3511:
3512:
3513: oks_entitlements_pub_w.rosetta_table_copy_out_p47(ddx_contract_tbl, p7_a0
3514: , p7_a1
3515: , p7_a2
3516: , p7_a3
3517: , p7_a4

Line 3554: ddp_inp_rec oks_entitlements_pub.grt_inp_rec_type;

3550: , p7_a3 out nocopy DATE
3551: )
3552:
3553: as
3554: ddp_inp_rec oks_entitlements_pub.grt_inp_rec_type;
3555: ddx_react_rec oks_entitlements_pub.rcn_rsn_rec_type;
3556: ddx_resolve_rec oks_entitlements_pub.rcn_rsn_rec_type;
3557: ddindx binary_integer; indx binary_integer;
3558: begin

Line 3555: ddx_react_rec oks_entitlements_pub.rcn_rsn_rec_type;

3551: )
3552:
3553: as
3554: ddp_inp_rec oks_entitlements_pub.grt_inp_rec_type;
3555: ddx_react_rec oks_entitlements_pub.rcn_rsn_rec_type;
3556: ddx_resolve_rec oks_entitlements_pub.rcn_rsn_rec_type;
3557: ddindx binary_integer; indx binary_integer;
3558: begin
3559:

Line 3556: ddx_resolve_rec oks_entitlements_pub.rcn_rsn_rec_type;

3552:
3553: as
3554: ddp_inp_rec oks_entitlements_pub.grt_inp_rec_type;
3555: ddx_react_rec oks_entitlements_pub.rcn_rsn_rec_type;
3556: ddx_resolve_rec oks_entitlements_pub.rcn_rsn_rec_type;
3557: ddindx binary_integer; indx binary_integer;
3558: begin
3559:
3560: -- copy data to the local IN or IN-OUT args, if any

Line 3579: oks_entitlements_pub.get_react_resolve_by_time(p_api_version,

3575:
3576:
3577:
3578: -- here's the delegated call to the old PL/SQL routine
3579: oks_entitlements_pub.get_react_resolve_by_time(p_api_version,
3580: p_init_msg_list,
3581: ddp_inp_rec,
3582: x_return_status,
3583: x_msg_count,

Line 3618: ddx_coverage_type oks_entitlements_pub.covtype_rec_type;

3614: , p6_a2 out nocopy NUMBER
3615: )
3616:
3617: as
3618: ddx_coverage_type oks_entitlements_pub.covtype_rec_type;
3619: ddindx binary_integer; indx binary_integer;
3620: begin
3621:
3622: -- copy data to the local IN or IN-OUT args, if any

Line 3631: oks_entitlements_pub.get_coverage_type(p_api_version,

3627:
3628:
3629:
3630: -- here's the delegated call to the old PL/SQL routine
3631: oks_entitlements_pub.get_coverage_type(p_api_version,
3632: p_init_msg_list,
3633: p_contract_line_id,
3634: x_return_status,
3635: x_msg_count,

Line 3668: ddx_importance_lvl oks_entitlements_pub.high_imp_level_k_rec;

3664: , p6_a7 out nocopy NUMBER
3665: )
3666:
3667: as
3668: ddx_importance_lvl oks_entitlements_pub.high_imp_level_k_rec;
3669: ddindx binary_integer; indx binary_integer;
3670: begin
3671:
3672: -- copy data to the local IN or IN-OUT args, if any

Line 3681: oks_entitlements_pub.get_highimp_cp_contract(p_api_version,

3677:
3678:
3679:
3680: -- here's the delegated call to the old PL/SQL routine
3681: oks_entitlements_pub.get_highimp_cp_contract(p_api_version,
3682: p_init_msg_list,
3683: p_customer_product_id,
3684: x_return_status,
3685: x_msg_count,

Line 3738: oks_entitlements_pub.check_coverage_times(p_api_version,

3734:
3735:
3736:
3737: -- here's the delegated call to the old PL/SQL routine
3738: oks_entitlements_pub.check_coverage_times(p_api_version,
3739: p_init_msg_list,
3740: p_business_process_id,
3741: ddp_request_date,
3742: p_time_zone_id,

Line 3801: oks_entitlements_pub.check_reaction_times(p_api_version,

3797:
3798:
3799:
3800: -- here's the delegated call to the old PL/SQL routine
3801: oks_entitlements_pub.check_reaction_times(p_api_version,
3802: p_init_msg_list,
3803: p_business_process_id,
3804: ddp_request_date,
3805: p_sr_severity,

Line 3849: ddx_ent_contacts oks_entitlements_pub.ent_contact_tbl;

3845: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
3846: )
3847:
3848: as
3849: ddx_ent_contacts oks_entitlements_pub.ent_contact_tbl;
3850: ddindx binary_integer; indx binary_integer;
3851: begin
3852:
3853: -- copy data to the local IN or IN-OUT args, if any

Line 3863: oks_entitlements_pub.get_contacts(p_api_version,

3859:
3860:
3861:
3862: -- here's the delegated call to the old PL/SQL routine
3863: oks_entitlements_pub.get_contacts(p_api_version,
3864: p_init_msg_list,
3865: p_contract_id,
3866: p_contract_line_id,
3867: x_return_status,

Line 3880: oks_entitlements_pub_w.rosetta_table_copy_out_p60(ddx_ent_contacts, p7_a0

3876:
3877:
3878:
3879:
3880: oks_entitlements_pub_w.rosetta_table_copy_out_p60(ddx_ent_contacts, p7_a0
3881: , p7_a1
3882: , p7_a2
3883: , p7_a3
3884: , p7_a4

Line 3907: ddx_prf_engineers oks_entitlements_pub.prfeng_tbl_type;

3903: )
3904:
3905: as
3906: ddp_request_date date;
3907: ddx_prf_engineers oks_entitlements_pub.prfeng_tbl_type;
3908: ddindx binary_integer; indx binary_integer;
3909: begin
3910:
3911: -- copy data to the local IN or IN-OUT args, if any

Line 3923: oks_entitlements_pub.get_preferred_engineers(p_api_version,

3919:
3920:
3921:
3922: -- here's the delegated call to the old PL/SQL routine
3923: oks_entitlements_pub.get_preferred_engineers(p_api_version,
3924: p_init_msg_list,
3925: p_contract_line_id,
3926: p_business_process_id,
3927: ddp_request_date,

Line 3942: oks_entitlements_pub_w.rosetta_table_copy_out_p63(ddx_prf_engineers, p8_a0

3938:
3939:
3940:
3941:
3942: oks_entitlements_pub_w.rosetta_table_copy_out_p63(ddx_prf_engineers, p8_a0
3943: , p8_a1
3944: , p8_a2
3945: , p8_a3
3946: , p8_a4

Line 3978: oks_entitlements_pub.oks_validate_system(p_api_version,

3974:
3975:
3976:
3977: -- here's the delegated call to the old PL/SQL routine
3978: oks_entitlements_pub.oks_validate_system(p_api_version,
3979: p_init_msg_list,
3980: p_system_id,
3981: ddp_request_date,
3982: p_update_only_check,

Line 4038: ddx_ent_contracts oks_entitlements_pub.default_contline_system_rec;

4034: )
4035:
4036: as
4037: ddp_request_date date;
4038: ddx_ent_contracts oks_entitlements_pub.default_contline_system_rec;
4039: ddindx binary_integer; indx binary_integer;
4040: begin
4041:
4042: -- copy data to the local IN or IN-OUT args, if any

Line 4053: oks_entitlements_pub.default_contline_system(p_api_version,

4049:
4050:
4051:
4052: -- here's the delegated call to the old PL/SQL routine
4053: oks_entitlements_pub.default_contline_system(p_api_version,
4054: p_init_msg_list,
4055: p_system_id,
4056: ddp_request_date,
4057: x_return_status,

Line 4117: ddp_inp_rec_bp oks_entitlements_pub.inp_rec_bp;

4113: , p6_a3 out nocopy JTF_DATE_TABLE
4114: )
4115:
4116: as
4117: ddp_inp_rec_bp oks_entitlements_pub.inp_rec_bp;
4118: ddx_cov_txn_grp_lines oks_entitlements_pub.output_tbl_bp;
4119: ddindx binary_integer; indx binary_integer;
4120: begin
4121:

Line 4118: ddx_cov_txn_grp_lines oks_entitlements_pub.output_tbl_bp;

4114: )
4115:
4116: as
4117: ddp_inp_rec_bp oks_entitlements_pub.inp_rec_bp;
4118: ddx_cov_txn_grp_lines oks_entitlements_pub.output_tbl_bp;
4119: ddindx binary_integer; indx binary_integer;
4120: begin
4121:
4122: -- copy data to the local IN or IN-OUT args, if any

Line 4136: oks_entitlements_pub.get_cov_txn_groups(p_api_version,

4132:
4133:
4134:
4135: -- here's the delegated call to the old PL/SQL routine
4136: oks_entitlements_pub.get_cov_txn_groups(p_api_version,
4137: p_init_msg_list,
4138: ddp_inp_rec_bp,
4139: x_return_status,
4140: x_msg_count,

Line 4151: oks_entitlements_pub_w.rosetta_table_copy_out_p70(ddx_cov_txn_grp_lines, p6_a0

4147:
4148:
4149:
4150:
4151: oks_entitlements_pub_w.rosetta_table_copy_out_p70(ddx_cov_txn_grp_lines, p6_a0
4152: , p6_a1
4153: , p6_a2
4154: , p6_a3
4155: );

Line 4193: ddx_txn_bill_types oks_entitlements_pub.output_tbl_bt;

4189: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
4190: )
4191:
4192: as
4193: ddx_txn_bill_types oks_entitlements_pub.output_tbl_bt;
4194: ddx_txn_bill_rates oks_entitlements_pub.output_tbl_br;
4195: ddindx binary_integer; indx binary_integer;
4196: begin
4197:

Line 4194: ddx_txn_bill_rates oks_entitlements_pub.output_tbl_br;

4190: )
4191:
4192: as
4193: ddx_txn_bill_types oks_entitlements_pub.output_tbl_bt;
4194: ddx_txn_bill_rates oks_entitlements_pub.output_tbl_br;
4195: ddindx binary_integer; indx binary_integer;
4196: begin
4197:
4198: -- copy data to the local IN or IN-OUT args, if any

Line 4209: oks_entitlements_pub.get_txn_billing_types(p_api_version,

4205:
4206:
4207:
4208: -- here's the delegated call to the old PL/SQL routine
4209: oks_entitlements_pub.get_txn_billing_types(p_api_version,
4210: p_init_msg_list,
4211: p_cov_txngrp_line_id,
4212: p_return_bill_rates_yn,
4213: x_return_status,

Line 4227: oks_entitlements_pub_w.rosetta_table_copy_out_p73(ddx_txn_bill_types, p7_a0

4223:
4224:
4225:
4226:
4227: oks_entitlements_pub_w.rosetta_table_copy_out_p73(ddx_txn_bill_types, p7_a0
4228: , p7_a1
4229: , p7_a2
4230: , p7_a3
4231: );

Line 4233: oks_entitlements_pub_w.rosetta_table_copy_out_p75(ddx_txn_bill_rates, p8_a0

4229: , p7_a2
4230: , p7_a3
4231: );
4232:
4233: oks_entitlements_pub_w.rosetta_table_copy_out_p75(ddx_txn_bill_rates, p8_a0
4234: , p8_a1
4235: , p8_a2
4236: , p8_a3
4237: , p8_a4

Line 4312: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;

4308: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_300
4309: )
4310:
4311: as
4312: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;
4313: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;
4314: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;
4315: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;
4316: ddindx binary_integer; indx binary_integer;

Line 4313: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;

4309: )
4310:
4311: as
4312: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;
4313: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;
4314: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;
4315: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;
4316: ddindx binary_integer; indx binary_integer;
4317: begin

Line 4314: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;

4310:
4311: as
4312: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;
4313: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;
4314: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;
4315: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;
4316: ddindx binary_integer; indx binary_integer;
4317: begin
4318:

Line 4315: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;

4311: as
4312: ddp_contract_rec oks_entitlements_pub.srchline_inpcontrec_type;
4313: ddp_contract_line_rec oks_entitlements_pub.srchline_inpcontlinerec_type;
4314: ddp_clvl_id_tbl oks_entitlements_pub.srchline_covlvl_id_tbl;
4315: ddx_contract_tbl oks_entitlements_pub.output_tbl_contractline;
4316: ddindx binary_integer; indx binary_integer;
4317: begin
4318:
4319: -- copy data to the local IN or IN-OUT args, if any

Line 4350: oks_entitlements_pub_w.rosetta_table_copy_in_p81(ddp_clvl_id_tbl, p4_a0

4346: ddp_contract_line_rec.line_bill_to_site_id := p3_a7;
4347: ddp_contract_line_rec.line_ship_to_site_id := p3_a8;
4348: ddp_contract_line_rec.line_renewal_type_code := p3_a9;
4349:
4350: oks_entitlements_pub_w.rosetta_table_copy_in_p81(ddp_clvl_id_tbl, p4_a0
4351: , p4_a1
4352: , p4_a2
4353: );
4354:

Line 4360: oks_entitlements_pub.search_contract_lines(p_api_version,

4356:
4357:
4358:
4359: -- here's the delegated call to the old PL/SQL routine
4360: oks_entitlements_pub.search_contract_lines(p_api_version,
4361: p_init_msg_list,
4362: ddp_contract_rec,
4363: ddp_contract_line_rec,
4364: ddp_clvl_id_tbl,

Line 4379: oks_entitlements_pub_w.rosetta_table_copy_out_p83(ddx_contract_tbl, p8_a0

4375:
4376:
4377:
4378:
4379: oks_entitlements_pub_w.rosetta_table_copy_out_p83(ddx_contract_tbl, p8_a0
4380: , p8_a1
4381: , p8_a2
4382: , p8_a3
4383: , p8_a4

Line 4400: end oks_entitlements_pub_w;

4396: , p8_a17
4397: );
4398: end;
4399:
4400: end oks_entitlements_pub_w;