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.OKS_ENTITLEMENTS_WEB_W dependencies on OKS_ENTITLEMENTS_WEB

Line 1: package body oks_entitlements_web_w as

1: package body oks_entitlements_web_w as
2: /* $Header: OKSWENWB.pls 120.0 2005/05/25 18:33:56 appldev 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_p19(t out nocopy oks_entitlements_web.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200

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_p19(t out nocopy oks_entitlements_web.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
14: , a1 JTF_VARCHAR2_TABLE_200
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100

Line 56: procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200

52: end loop;
53: end if;
54: end if;
55: end rosetta_table_copy_in_p19;
56: procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
57: , a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: procedure rosetta_table_copy_in_p21(t out nocopy oks_entitlements_web.account_all_id_tbl_type, a0 JTF_NUMBER_TABLE

136: end if;
137: end if;
138: end rosetta_table_copy_out_p19;
139:
140: procedure rosetta_table_copy_in_p21(t out nocopy oks_entitlements_web.account_all_id_tbl_type, a0 JTF_NUMBER_TABLE
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if a0 is not null and a0.count > 0 then

Line 159: procedure rosetta_table_copy_out_p21(t oks_entitlements_web.account_all_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

155: end loop;
156: end if;
157: end if;
158: end rosetta_table_copy_in_p21;
159: procedure rosetta_table_copy_out_p21(t oks_entitlements_web.account_all_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
160: ) as
161: ddindx binary_integer; indx binary_integer;
162: begin
163: if t is null or t.count = 0 then

Line 183: procedure rosetta_table_copy_in_p23(t out nocopy oks_entitlements_web.party_sites_tbl_type, a0 JTF_NUMBER_TABLE

179: end if;
180: end if;
181: end rosetta_table_copy_out_p21;
182:
183: procedure rosetta_table_copy_in_p23(t out nocopy oks_entitlements_web.party_sites_tbl_type, a0 JTF_NUMBER_TABLE
184: , a1 JTF_VARCHAR2_TABLE_100
185: , a2 JTF_VARCHAR2_TABLE_300
186: , a3 JTF_VARCHAR2_TABLE_300
187: ) as

Line 208: procedure rosetta_table_copy_out_p23(t oks_entitlements_web.party_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

204: end loop;
205: end if;
206: end if;
207: end rosetta_table_copy_in_p23;
208: procedure rosetta_table_copy_out_p23(t oks_entitlements_web.party_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
209: , a1 out nocopy JTF_VARCHAR2_TABLE_100
210: , a2 out nocopy JTF_VARCHAR2_TABLE_300
211: , a3 out nocopy JTF_VARCHAR2_TABLE_300
212: ) as

Line 247: procedure rosetta_table_copy_in_p25(t out nocopy oks_entitlements_web.party_items_tbl_type, a0 JTF_NUMBER_TABLE

243: end if;
244: end if;
245: end rosetta_table_copy_out_p23;
246:
247: procedure rosetta_table_copy_in_p25(t out nocopy oks_entitlements_web.party_items_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_VARCHAR2_TABLE_300
250: , a3 JTF_VARCHAR2_TABLE_300
251: ) as

Line 272: procedure rosetta_table_copy_out_p25(t oks_entitlements_web.party_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

268: end loop;
269: end if;
270: end if;
271: end rosetta_table_copy_in_p25;
272: procedure rosetta_table_copy_out_p25(t oks_entitlements_web.party_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
273: , a1 out nocopy JTF_NUMBER_TABLE
274: , a2 out nocopy JTF_VARCHAR2_TABLE_300
275: , a3 out nocopy JTF_VARCHAR2_TABLE_300
276: ) as

Line 311: procedure rosetta_table_copy_in_p27(t out nocopy oks_entitlements_web.party_systems_tbl_type, a0 JTF_NUMBER_TABLE

307: end if;
308: end if;
309: end rosetta_table_copy_out_p25;
310:
311: procedure rosetta_table_copy_in_p27(t out nocopy oks_entitlements_web.party_systems_tbl_type, a0 JTF_NUMBER_TABLE
312: , a1 JTF_VARCHAR2_TABLE_100
313: , a2 JTF_VARCHAR2_TABLE_300
314: , a3 JTF_VARCHAR2_TABLE_300
315: ) as

Line 336: procedure rosetta_table_copy_out_p27(t oks_entitlements_web.party_systems_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

332: end loop;
333: end if;
334: end if;
335: end rosetta_table_copy_in_p27;
336: procedure rosetta_table_copy_out_p27(t oks_entitlements_web.party_systems_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , a2 out nocopy JTF_VARCHAR2_TABLE_300
339: , a3 out nocopy JTF_VARCHAR2_TABLE_300
340: ) as

Line 375: procedure rosetta_table_copy_in_p29(t out nocopy oks_entitlements_web.party_products_tbl_type, a0 JTF_NUMBER_TABLE

371: end if;
372: end if;
373: end rosetta_table_copy_out_p27;
374:
375: procedure rosetta_table_copy_in_p29(t out nocopy oks_entitlements_web.party_products_tbl_type, a0 JTF_NUMBER_TABLE
376: , a1 JTF_VARCHAR2_TABLE_100
377: , a2 JTF_VARCHAR2_TABLE_300
378: , a3 JTF_VARCHAR2_TABLE_300
379: ) as

Line 400: procedure rosetta_table_copy_out_p29(t oks_entitlements_web.party_products_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

396: end loop;
397: end if;
398: end if;
399: end rosetta_table_copy_in_p29;
400: procedure rosetta_table_copy_out_p29(t oks_entitlements_web.party_products_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
401: , a1 out nocopy JTF_VARCHAR2_TABLE_100
402: , a2 out nocopy JTF_VARCHAR2_TABLE_300
403: , a3 out nocopy JTF_VARCHAR2_TABLE_300
404: ) as

Line 439: procedure rosetta_table_copy_in_p31(t out nocopy oks_entitlements_web.contract_cat_tbl_type, a0 JTF_VARCHAR2_TABLE_100

435: end if;
436: end if;
437: end rosetta_table_copy_out_p29;
438:
439: procedure rosetta_table_copy_in_p31(t out nocopy oks_entitlements_web.contract_cat_tbl_type, a0 JTF_VARCHAR2_TABLE_100
440: , a1 JTF_VARCHAR2_TABLE_100
441: ) as
442: ddindx binary_integer; indx binary_integer;
443: begin

Line 460: procedure rosetta_table_copy_out_p31(t oks_entitlements_web.contract_cat_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

456: end loop;
457: end if;
458: end if;
459: end rosetta_table_copy_in_p31;
460: procedure rosetta_table_copy_out_p31(t oks_entitlements_web.contract_cat_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
461: , a1 out nocopy JTF_VARCHAR2_TABLE_100
462: ) as
463: ddindx binary_integer; indx binary_integer;
464: begin

Line 489: procedure rosetta_table_copy_in_p33(t out nocopy oks_entitlements_web.contract_status_tbl_type, a0 JTF_VARCHAR2_TABLE_100

485: end if;
486: end if;
487: end rosetta_table_copy_out_p31;
488:
489: procedure rosetta_table_copy_in_p33(t out nocopy oks_entitlements_web.contract_status_tbl_type, a0 JTF_VARCHAR2_TABLE_100
490: , a1 JTF_VARCHAR2_TABLE_100
491: ) as
492: ddindx binary_integer; indx binary_integer;
493: begin

Line 510: procedure rosetta_table_copy_out_p33(t oks_entitlements_web.contract_status_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

506: end loop;
507: end if;
508: end if;
509: end rosetta_table_copy_in_p33;
510: procedure rosetta_table_copy_out_p33(t oks_entitlements_web.contract_status_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
511: , a1 out nocopy JTF_VARCHAR2_TABLE_100
512: ) as
513: ddindx binary_integer; indx binary_integer;
514: begin

Line 539: procedure rosetta_table_copy_in_p37(t out nocopy oks_entitlements_web.party_tbl_type, a0 JTF_NUMBER_TABLE

535: end if;
536: end if;
537: end rosetta_table_copy_out_p33;
538:
539: procedure rosetta_table_copy_in_p37(t out nocopy oks_entitlements_web.party_tbl_type, a0 JTF_NUMBER_TABLE
540: , a1 JTF_VARCHAR2_TABLE_100
541: , a2 JTF_VARCHAR2_TABLE_100
542: , a3 JTF_VARCHAR2_TABLE_400
543: , a4 JTF_VARCHAR2_TABLE_100

Line 570: procedure rosetta_table_copy_out_p37(t oks_entitlements_web.party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

566: end loop;
567: end if;
568: end if;
569: end rosetta_table_copy_in_p37;
570: procedure rosetta_table_copy_out_p37(t oks_entitlements_web.party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
571: , a1 out nocopy JTF_VARCHAR2_TABLE_100
572: , a2 out nocopy JTF_VARCHAR2_TABLE_100
573: , a3 out nocopy JTF_VARCHAR2_TABLE_400
574: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 624: procedure rosetta_table_copy_in_p39(t out nocopy oks_entitlements_web.line_tbl_type, a0 JTF_NUMBER_TABLE

620: end if;
621: end if;
622: end rosetta_table_copy_out_p37;
623:
624: procedure rosetta_table_copy_in_p39(t out nocopy oks_entitlements_web.line_tbl_type, a0 JTF_NUMBER_TABLE
625: , a1 JTF_NUMBER_TABLE
626: , a2 JTF_DATE_TABLE
627: , a3 JTF_DATE_TABLE
628: , a4 JTF_VARCHAR2_TABLE_100

Line 689: procedure rosetta_table_copy_out_p39(t oks_entitlements_web.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

685: end loop;
686: end if;
687: end if;
688: end rosetta_table_copy_in_p39;
689: procedure rosetta_table_copy_out_p39(t oks_entitlements_web.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
690: , a1 out nocopy JTF_NUMBER_TABLE
691: , a2 out nocopy JTF_DATE_TABLE
692: , a3 out nocopy JTF_DATE_TABLE
693: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 828: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_web.party_contact_tbl_type, a0 JTF_NUMBER_TABLE

824: end if;
825: end if;
826: end rosetta_table_copy_out_p39;
827:
828: procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_web.party_contact_tbl_type, a0 JTF_NUMBER_TABLE
829: , a1 JTF_VARCHAR2_TABLE_100
830: , a2 JTF_VARCHAR2_TABLE_100
831: , a3 JTF_VARCHAR2_TABLE_100
832: , a4 JTF_DATE_TABLE

Line 863: procedure rosetta_table_copy_out_p41(t oks_entitlements_web.party_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

859: end loop;
860: end if;
861: end if;
862: end rosetta_table_copy_in_p41;
863: procedure rosetta_table_copy_out_p41(t oks_entitlements_web.party_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
864: , a1 out nocopy JTF_VARCHAR2_TABLE_100
865: , a2 out nocopy JTF_VARCHAR2_TABLE_100
866: , a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , a4 out nocopy JTF_DATE_TABLE

Line 927: procedure rosetta_table_copy_in_p43(t out nocopy oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_100

923: end if;
924: end if;
925: end rosetta_table_copy_out_p41;
926:
927: procedure rosetta_table_copy_in_p43(t out nocopy oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_100
928: , a1 JTF_VARCHAR2_TABLE_100
929: , a2 JTF_VARCHAR2_TABLE_2000
930: , a3 JTF_VARCHAR2_TABLE_100
931: , a4 JTF_VARCHAR2_TABLE_100

Line 960: procedure rosetta_table_copy_out_p43(t oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

956: end loop;
957: end if;
958: end if;
959: end rosetta_table_copy_in_p43;
960: procedure rosetta_table_copy_out_p43(t oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
961: , a1 out nocopy JTF_VARCHAR2_TABLE_100
962: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
963: , a3 out nocopy JTF_VARCHAR2_TABLE_100
964: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1019: procedure rosetta_table_copy_in_p46(t out nocopy oks_entitlements_web.covered_level_tbl_type, a0 JTF_VARCHAR2_TABLE_500

1015: end if;
1016: end if;
1017: end rosetta_table_copy_out_p43;
1018:
1019: procedure rosetta_table_copy_in_p46(t out nocopy oks_entitlements_web.covered_level_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1020: , a1 JTF_VARCHAR2_TABLE_500
1021: , a2 JTF_VARCHAR2_TABLE_500
1022: , a3 JTF_DATE_TABLE
1023: , a4 JTF_DATE_TABLE

Line 1054: procedure rosetta_table_copy_out_p46(t oks_entitlements_web.covered_level_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500

1050: end loop;
1051: end if;
1052: end if;
1053: end rosetta_table_copy_in_p46;
1054: procedure rosetta_table_copy_out_p46(t oks_entitlements_web.covered_level_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1055: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1056: , a2 out nocopy JTF_VARCHAR2_TABLE_500
1057: , a3 out nocopy JTF_DATE_TABLE
1058: , a4 out nocopy JTF_DATE_TABLE

Line 1118: procedure rosetta_table_copy_in_p48(t out nocopy oks_entitlements_web.cust_contacts_tbl_type, a0 JTF_VARCHAR2_TABLE_500

1114: end if;
1115: end if;
1116: end rosetta_table_copy_out_p46;
1117:
1118: procedure rosetta_table_copy_in_p48(t out nocopy oks_entitlements_web.cust_contacts_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1119: , a1 JTF_VARCHAR2_TABLE_500
1120: , a2 JTF_VARCHAR2_TABLE_500
1121: , a3 JTF_DATE_TABLE
1122: , a4 JTF_DATE_TABLE

Line 1145: procedure rosetta_table_copy_out_p48(t oks_entitlements_web.cust_contacts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500

1141: end loop;
1142: end if;
1143: end if;
1144: end rosetta_table_copy_in_p48;
1145: procedure rosetta_table_copy_out_p48(t oks_entitlements_web.cust_contacts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1146: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1147: , a2 out nocopy JTF_VARCHAR2_TABLE_500
1148: , a3 out nocopy JTF_DATE_TABLE
1149: , a4 out nocopy JTF_DATE_TABLE

Line 1189: procedure rosetta_table_copy_in_p51(t out nocopy oks_entitlements_web.bus_proc_tbl_type, a0 JTF_NUMBER_TABLE

1185: end if;
1186: end if;
1187: end rosetta_table_copy_out_p48;
1188:
1189: procedure rosetta_table_copy_in_p51(t out nocopy oks_entitlements_web.bus_proc_tbl_type, a0 JTF_NUMBER_TABLE
1190: , a1 JTF_NUMBER_TABLE
1191: , a2 JTF_VARCHAR2_TABLE_500
1192: , a3 JTF_VARCHAR2_TABLE_500
1193: , a4 JTF_VARCHAR2_TABLE_500

Line 1218: procedure rosetta_table_copy_out_p51(t oks_entitlements_web.bus_proc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1214: end loop;
1215: end if;
1216: end if;
1217: end rosetta_table_copy_in_p51;
1218: procedure rosetta_table_copy_out_p51(t oks_entitlements_web.bus_proc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1219: , a1 out nocopy JTF_NUMBER_TABLE
1220: , a2 out nocopy JTF_VARCHAR2_TABLE_500
1221: , a3 out nocopy JTF_VARCHAR2_TABLE_500
1222: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 1267: procedure rosetta_table_copy_in_p54(t out nocopy oks_entitlements_web.coverage_times_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1263: end if;
1264: end if;
1265: end rosetta_table_copy_out_p51;
1266:
1267: procedure rosetta_table_copy_in_p54(t out nocopy oks_entitlements_web.coverage_times_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1268: , a1 JTF_VARCHAR2_TABLE_100
1269: , a2 JTF_VARCHAR2_TABLE_100
1270: ) as
1271: ddindx binary_integer; indx binary_integer;

Line 1290: procedure rosetta_table_copy_out_p54(t oks_entitlements_web.coverage_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

1286: end loop;
1287: end if;
1288: end if;
1289: end rosetta_table_copy_in_p54;
1290: procedure rosetta_table_copy_out_p54(t oks_entitlements_web.coverage_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1291: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1292: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1293: ) as
1294: ddindx binary_integer; indx binary_integer;

Line 1324: procedure rosetta_table_copy_in_p56(t out nocopy oks_entitlements_web.reaction_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500

1320: end if;
1321: end if;
1322: end rosetta_table_copy_out_p54;
1323:
1324: procedure rosetta_table_copy_in_p56(t out nocopy oks_entitlements_web.reaction_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1325: , a1 JTF_VARCHAR2_TABLE_500
1326: , a2 JTF_VARCHAR2_TABLE_100
1327: , a3 JTF_VARCHAR2_TABLE_100
1328: , a4 JTF_VARCHAR2_TABLE_100

Line 1363: procedure rosetta_table_copy_out_p56(t oks_entitlements_web.reaction_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500

1359: end loop;
1360: end if;
1361: end if;
1362: end rosetta_table_copy_in_p56;
1363: procedure rosetta_table_copy_out_p56(t oks_entitlements_web.reaction_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1364: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1365: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1367: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1437: procedure rosetta_table_copy_in_p58(t out nocopy oks_entitlements_web.resolution_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500

1433: end if;
1434: end if;
1435: end rosetta_table_copy_out_p56;
1436:
1437: procedure rosetta_table_copy_in_p58(t out nocopy oks_entitlements_web.resolution_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1438: , a1 JTF_VARCHAR2_TABLE_500
1439: , a2 JTF_VARCHAR2_TABLE_100
1440: , a3 JTF_VARCHAR2_TABLE_100
1441: , a4 JTF_VARCHAR2_TABLE_100

Line 1476: procedure rosetta_table_copy_out_p58(t oks_entitlements_web.resolution_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500

1472: end loop;
1473: end if;
1474: end if;
1475: end rosetta_table_copy_in_p58;
1476: procedure rosetta_table_copy_out_p58(t oks_entitlements_web.resolution_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1477: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1478: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1479: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1480: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1550: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_web.pref_resource_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1546: end if;
1547: end if;
1548: end rosetta_table_copy_out_p58;
1549:
1550: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_web.pref_resource_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1551: , a1 JTF_VARCHAR2_TABLE_400
1552: ) as
1553: ddindx binary_integer; indx binary_integer;
1554: begin

Line 1571: procedure rosetta_table_copy_out_p60(t oks_entitlements_web.pref_resource_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

1567: end loop;
1568: end if;
1569: end if;
1570: end rosetta_table_copy_in_p60;
1571: procedure rosetta_table_copy_out_p60(t oks_entitlements_web.pref_resource_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1572: , a1 out nocopy JTF_VARCHAR2_TABLE_400
1573: ) as
1574: ddindx binary_integer; indx binary_integer;
1575: begin

Line 1600: procedure rosetta_table_copy_in_p62(t out nocopy oks_entitlements_web.bus_proc_bil_typ_tbl_type, a0 JTF_VARCHAR2_TABLE_500

1596: end if;
1597: end if;
1598: end rosetta_table_copy_out_p60;
1599:
1600: procedure rosetta_table_copy_in_p62(t out nocopy oks_entitlements_web.bus_proc_bil_typ_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1601: , a1 JTF_VARCHAR2_TABLE_500
1602: , a2 JTF_VARCHAR2_TABLE_500
1603: , a3 JTF_VARCHAR2_TABLE_500
1604: , a4 JTF_VARCHAR2_TABLE_100

Line 1631: procedure rosetta_table_copy_out_p62(t oks_entitlements_web.bus_proc_bil_typ_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500

1627: end loop;
1628: end if;
1629: end if;
1630: end rosetta_table_copy_in_p62;
1631: procedure rosetta_table_copy_out_p62(t oks_entitlements_web.bus_proc_bil_typ_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1632: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1633: , a2 out nocopy JTF_VARCHAR2_TABLE_500
1634: , a3 out nocopy JTF_VARCHAR2_TABLE_500
1635: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1685: procedure rosetta_table_copy_in_p65(t out nocopy oks_entitlements_web.covered_prods_tbl_type, a0 JTF_VARCHAR2_TABLE_500

1681: end if;
1682: end if;
1683: end rosetta_table_copy_out_p62;
1684:
1685: procedure rosetta_table_copy_in_p65(t out nocopy oks_entitlements_web.covered_prods_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1686: , a1 JTF_VARCHAR2_TABLE_500
1687: , a2 JTF_VARCHAR2_TABLE_2000
1688: , a3 JTF_VARCHAR2_TABLE_500
1689: , a4 JTF_VARCHAR2_TABLE_500

Line 1736: procedure rosetta_table_copy_out_p65(t oks_entitlements_web.covered_prods_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500

1732: end loop;
1733: end if;
1734: end if;
1735: end rosetta_table_copy_in_p65;
1736: procedure rosetta_table_copy_out_p65(t oks_entitlements_web.covered_prods_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1737: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1738: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
1739: , a3 out nocopy JTF_VARCHAR2_TABLE_500
1740: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 1840: procedure rosetta_table_copy_in_p67(t out nocopy oks_entitlements_web.counter_tbl_type, a0 JTF_VARCHAR2_TABLE_500

1836: end if;
1837: end if;
1838: end rosetta_table_copy_out_p65;
1839:
1840: procedure rosetta_table_copy_in_p67(t out nocopy oks_entitlements_web.counter_tbl_type, a0 JTF_VARCHAR2_TABLE_500
1841: , a1 JTF_VARCHAR2_TABLE_500
1842: , a2 JTF_VARCHAR2_TABLE_500
1843: , a3 JTF_VARCHAR2_TABLE_500
1844: , a4 JTF_VARCHAR2_TABLE_500

Line 1867: procedure rosetta_table_copy_out_p67(t oks_entitlements_web.counter_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500

1863: end loop;
1864: end if;
1865: end if;
1866: end rosetta_table_copy_in_p67;
1867: procedure rosetta_table_copy_out_p67(t oks_entitlements_web.counter_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
1868: , a1 out nocopy JTF_VARCHAR2_TABLE_500
1869: , a2 out nocopy JTF_VARCHAR2_TABLE_500
1870: , a3 out nocopy JTF_VARCHAR2_TABLE_500
1871: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 1932: ddx_contract_tbl oks_entitlements_web.output_tbl_contract;

1928: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
1929: )
1930:
1931: as
1932: ddx_contract_tbl oks_entitlements_web.output_tbl_contract;
1933: ddindx binary_integer; indx binary_integer;
1934: begin
1935:
1936: -- copy data to the local IN or IN-OUT args, if any

Line 1944: oks_entitlements_web.simple_srch_rslts(p_contract_party_id,

1940:
1941:
1942:
1943: -- here's the delegated call to the old PL/SQL routine
1944: oks_entitlements_web.simple_srch_rslts(p_contract_party_id,
1945: p_account_id,
1946: x_return_status,
1947: x_msg_count,
1948: x_msg_data,

Line 1957: oks_entitlements_web_w.rosetta_table_copy_out_p19(ddx_contract_tbl, p5_a0

1953:
1954:
1955:
1956:
1957: oks_entitlements_web_w.rosetta_table_copy_out_p19(ddx_contract_tbl, p5_a0
1958: , p5_a1
1959: , p5_a2
1960: , p5_a3
1961: , p5_a4

Line 2020: ddp_account_all_id oks_entitlements_web.account_all_id_tbl_type;

2016: ddp_end_date_from date;
2017: ddp_end_date_to date;
2018: ddp_date_terminated_from date;
2019: ddp_date_terminated_to date;
2020: ddp_account_all_id oks_entitlements_web.account_all_id_tbl_type;
2021: ddx_contract_tbl oks_entitlements_web.output_tbl_contract;
2022: ddindx binary_integer; indx binary_integer;
2023: begin
2024:

Line 2021: ddx_contract_tbl oks_entitlements_web.output_tbl_contract;

2017: ddp_end_date_to date;
2018: ddp_date_terminated_from date;
2019: ddp_date_terminated_to date;
2020: ddp_account_all_id oks_entitlements_web.account_all_id_tbl_type;
2021: ddx_contract_tbl oks_entitlements_web.output_tbl_contract;
2022: ddindx binary_integer; indx binary_integer;
2023: begin
2024:
2025: -- copy data to the local IN or IN-OUT args, if any

Line 2053: oks_entitlements_web_w.rosetta_table_copy_in_p21(ddp_account_all_id, p21_a0

2049:
2050:
2051:
2052:
2053: oks_entitlements_web_w.rosetta_table_copy_in_p21(ddp_account_all_id, p21_a0
2054: );
2055:
2056:
2057:

Line 2061: oks_entitlements_web.cntrct_srch_rslts(p_contract_number,

2057:
2058:
2059:
2060: -- here's the delegated call to the old PL/SQL routine
2061: oks_entitlements_web.cntrct_srch_rslts(p_contract_number,
2062: p_contract_status_code,
2063: ddp_start_date_from,
2064: ddp_start_date_to,
2065: ddp_end_date_from,

Line 2114: oks_entitlements_web_w.rosetta_table_copy_out_p19(ddx_contract_tbl, p25_a0

2110:
2111:
2112:
2113:
2114: oks_entitlements_web_w.rosetta_table_copy_out_p19(ddx_contract_tbl, p25_a0
2115: , p25_a1
2116: , p25_a2
2117: , p25_a3
2118: , p25_a4

Line 2140: ddx_party_sites_tbl_type oks_entitlements_web.party_sites_tbl_type;

2136: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
2137: )
2138:
2139: as
2140: ddx_party_sites_tbl_type oks_entitlements_web.party_sites_tbl_type;
2141: ddindx binary_integer; indx binary_integer;
2142: begin
2143:
2144: -- copy data to the local IN or IN-OUT args, if any

Line 2150: oks_entitlements_web.party_sites(p_party_id_arg,

2146:
2147:
2148:
2149: -- here's the delegated call to the old PL/SQL routine
2150: oks_entitlements_web.party_sites(p_party_id_arg,
2151: p_site_name_arg,
2152: x_return_status,
2153: ddx_party_sites_tbl_type);
2154:

Line 2159: oks_entitlements_web_w.rosetta_table_copy_out_p23(ddx_party_sites_tbl_type, p3_a0

2155: -- copy data back from the local variables to OUT or IN-OUT args, if any
2156:
2157:
2158:
2159: oks_entitlements_web_w.rosetta_table_copy_out_p23(ddx_party_sites_tbl_type, p3_a0
2160: , p3_a1
2161: , p3_a2
2162: , p3_a3
2163: );

Line 2183: ddrosetta_retval := oks_entitlements_web.duration_period(ddp_start_date,

2179:
2180: ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
2181:
2182: -- here's the delegated call to the old PL/SQL routine
2183: ddrosetta_retval := oks_entitlements_web.duration_period(ddp_start_date,
2184: ddp_end_date);
2185:
2186: -- copy data back from the local variables to OUT or IN-OUT args, if any
2187:

Line 2209: ddrosetta_retval := oks_entitlements_web.duration_unit(ddp_start_date,

2205:
2206: ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
2207:
2208: -- here's the delegated call to the old PL/SQL routine
2209: ddrosetta_retval := oks_entitlements_web.duration_unit(ddp_start_date,
2210: ddp_end_date);
2211:
2212: -- copy data back from the local variables to OUT or IN-OUT args, if any
2213:

Line 2228: ddx_party_items_tbl_type oks_entitlements_web.party_items_tbl_type;

2224: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
2225: )
2226:
2227: as
2228: ddx_party_items_tbl_type oks_entitlements_web.party_items_tbl_type;
2229: ddindx binary_integer; indx binary_integer;
2230: begin
2231:
2232: -- copy data to the local IN or IN-OUT args, if any

Line 2238: oks_entitlements_web.party_items(p_party_id_arg,

2234:
2235:
2236:
2237: -- here's the delegated call to the old PL/SQL routine
2238: oks_entitlements_web.party_items(p_party_id_arg,
2239: p_item_name_arg,
2240: x_return_status,
2241: ddx_party_items_tbl_type);
2242:

Line 2247: oks_entitlements_web_w.rosetta_table_copy_out_p25(ddx_party_items_tbl_type, p3_a0

2243: -- copy data back from the local variables to OUT or IN-OUT args, if any
2244:
2245:
2246:
2247: oks_entitlements_web_w.rosetta_table_copy_out_p25(ddx_party_items_tbl_type, p3_a0
2248: , p3_a1
2249: , p3_a2
2250: , p3_a3
2251: );

Line 2265: ddp_account_id_all oks_entitlements_web.account_all_id_tbl_type;

2261: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
2262: )
2263:
2264: as
2265: ddp_account_id_all oks_entitlements_web.account_all_id_tbl_type;
2266: ddx_party_systems_tbl_type oks_entitlements_web.party_systems_tbl_type;
2267: ddindx binary_integer; indx binary_integer;
2268: begin
2269:

Line 2266: ddx_party_systems_tbl_type oks_entitlements_web.party_systems_tbl_type;

2262: )
2263:
2264: as
2265: ddp_account_id_all oks_entitlements_web.account_all_id_tbl_type;
2266: ddx_party_systems_tbl_type oks_entitlements_web.party_systems_tbl_type;
2267: ddindx binary_integer; indx binary_integer;
2268: begin
2269:
2270: -- copy data to the local IN or IN-OUT args, if any

Line 2272: oks_entitlements_web_w.rosetta_table_copy_in_p21(ddp_account_id_all, p1_a0

2268: begin
2269:
2270: -- copy data to the local IN or IN-OUT args, if any
2271:
2272: oks_entitlements_web_w.rosetta_table_copy_in_p21(ddp_account_id_all, p1_a0
2273: );
2274:
2275:
2276:

Line 2279: oks_entitlements_web.party_systems(p_party_id_arg,

2275:
2276:
2277:
2278: -- here's the delegated call to the old PL/SQL routine
2279: oks_entitlements_web.party_systems(p_party_id_arg,
2280: ddp_account_id_all,
2281: p_system_name_arg,
2282: x_return_status,
2283: ddx_party_systems_tbl_type);

Line 2290: oks_entitlements_web_w.rosetta_table_copy_out_p27(ddx_party_systems_tbl_type, p4_a0

2286:
2287:
2288:
2289:
2290: oks_entitlements_web_w.rosetta_table_copy_out_p27(ddx_party_systems_tbl_type, p4_a0
2291: , p4_a1
2292: , p4_a2
2293: , p4_a3
2294: );

Line 2308: ddp_account_id_all oks_entitlements_web.account_all_id_tbl_type;

2304: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
2305: )
2306:
2307: as
2308: ddp_account_id_all oks_entitlements_web.account_all_id_tbl_type;
2309: ddx_party_products_tbl_type oks_entitlements_web.party_products_tbl_type;
2310: ddindx binary_integer; indx binary_integer;
2311: begin
2312:

Line 2309: ddx_party_products_tbl_type oks_entitlements_web.party_products_tbl_type;

2305: )
2306:
2307: as
2308: ddp_account_id_all oks_entitlements_web.account_all_id_tbl_type;
2309: ddx_party_products_tbl_type oks_entitlements_web.party_products_tbl_type;
2310: ddindx binary_integer; indx binary_integer;
2311: begin
2312:
2313: -- copy data to the local IN or IN-OUT args, if any

Line 2315: oks_entitlements_web_w.rosetta_table_copy_in_p21(ddp_account_id_all, p1_a0

2311: begin
2312:
2313: -- copy data to the local IN or IN-OUT args, if any
2314:
2315: oks_entitlements_web_w.rosetta_table_copy_in_p21(ddp_account_id_all, p1_a0
2316: );
2317:
2318:
2319:

Line 2322: oks_entitlements_web.party_products(p_party_id_arg,

2318:
2319:
2320:
2321: -- here's the delegated call to the old PL/SQL routine
2322: oks_entitlements_web.party_products(p_party_id_arg,
2323: ddp_account_id_all,
2324: p_product_name_arg,
2325: x_return_status,
2326: ddx_party_products_tbl_type);

Line 2333: oks_entitlements_web_w.rosetta_table_copy_out_p29(ddx_party_products_tbl_type, p4_a0

2329:
2330:
2331:
2332:
2333: oks_entitlements_web_w.rosetta_table_copy_out_p29(ddx_party_products_tbl_type, p4_a0
2334: , p4_a1
2335: , p4_a2
2336: , p4_a3
2337: );

Line 2350: ddx_contract_cat_tbl_type oks_entitlements_web.contract_cat_tbl_type;

2346: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2347: )
2348:
2349: as
2350: ddx_contract_cat_tbl_type oks_entitlements_web.contract_cat_tbl_type;
2351: ddx_contract_status_tbl_type oks_entitlements_web.contract_status_tbl_type;
2352: ddindx binary_integer; indx binary_integer;
2353: begin
2354:

Line 2351: ddx_contract_status_tbl_type oks_entitlements_web.contract_status_tbl_type;

2347: )
2348:
2349: as
2350: ddx_contract_cat_tbl_type oks_entitlements_web.contract_cat_tbl_type;
2351: ddx_contract_status_tbl_type oks_entitlements_web.contract_status_tbl_type;
2352: ddindx binary_integer; indx binary_integer;
2353: begin
2354:
2355: -- copy data to the local IN or IN-OUT args, if any

Line 2362: oks_entitlements_web.adv_search_overview(p_party_id_arg,

2358:
2359:
2360:
2361: -- here's the delegated call to the old PL/SQL routine
2362: oks_entitlements_web.adv_search_overview(p_party_id_arg,
2363: x_return_status,
2364: x_party_name,
2365: ddx_contract_cat_tbl_type,
2366: ddx_contract_status_tbl_type);

Line 2372: oks_entitlements_web_w.rosetta_table_copy_out_p31(ddx_contract_cat_tbl_type, p3_a0

2368: -- copy data back from the local variables to OUT or IN-OUT args, if any
2369:
2370:
2371:
2372: oks_entitlements_web_w.rosetta_table_copy_out_p31(ddx_contract_cat_tbl_type, p3_a0
2373: , p3_a1
2374: );
2375:
2376: oks_entitlements_web_w.rosetta_table_copy_out_p33(ddx_contract_status_tbl_type, p4_a0

Line 2376: oks_entitlements_web_w.rosetta_table_copy_out_p33(ddx_contract_status_tbl_type, p4_a0

2372: oks_entitlements_web_w.rosetta_table_copy_out_p31(ddx_contract_cat_tbl_type, p3_a0
2373: , p3_a1
2374: );
2375:
2376: oks_entitlements_web_w.rosetta_table_copy_out_p33(ddx_contract_status_tbl_type, p4_a0
2377: , p4_a1
2378: );
2379: end;
2380:

Line 2446: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;

2442: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2443: )
2444:
2445: as
2446: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2447: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;
2448: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;
2449: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;
2450: ddindx binary_integer; indx binary_integer;

Line 2447: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;

2443: )
2444:
2445: as
2446: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2447: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;
2448: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;
2449: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;
2450: ddindx binary_integer; indx binary_integer;
2451: begin

Line 2448: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;

2444:
2445: as
2446: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2447: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;
2448: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;
2449: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;
2450: ddindx binary_integer; indx binary_integer;
2451: begin
2452:

Line 2449: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;

2445: as
2446: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2447: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;
2448: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;
2449: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;
2450: ddindx binary_integer; indx binary_integer;
2451: begin
2452:
2453: -- copy data to the local IN or IN-OUT args, if any

Line 2462: oks_entitlements_web.contract_number_overview(p_contract_number_arg,

2458:
2459:
2460:
2461: -- here's the delegated call to the old PL/SQL routine
2462: oks_entitlements_web.contract_number_overview(p_contract_number_arg,
2463: p_contract_modifier_arg,
2464: x_return_status,
2465: ddx_hdr_rec_type,
2466: ddx_hdr_addr_rec_type,

Line 2504: oks_entitlements_web_w.rosetta_table_copy_out_p37(ddx_party_tbl_type, p5_a0

2500: p4_a8 := ddx_hdr_addr_rec_type.ship_to_address;
2501: p4_a9 := ddx_hdr_addr_rec_type.ship_to_city_state_zip;
2502: p4_a10 := ddx_hdr_addr_rec_type.ship_to_country;
2503:
2504: oks_entitlements_web_w.rosetta_table_copy_out_p37(ddx_party_tbl_type, p5_a0
2505: , p5_a1
2506: , p5_a2
2507: , p5_a3
2508: , p5_a4

Line 2513: oks_entitlements_web_w.rosetta_table_copy_out_p39(ddx_line_tbl_type, p6_a0

2509: , p5_a5
2510: , p5_a6
2511: );
2512:
2513: oks_entitlements_web_w.rosetta_table_copy_out_p39(ddx_line_tbl_type, p6_a0
2514: , p6_a1
2515: , p6_a2
2516: , p6_a3
2517: , p6_a4

Line 2604: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;

2600: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2601: )
2602:
2603: as
2604: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2605: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;
2606: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;
2607: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;
2608: ddindx binary_integer; indx binary_integer;

Line 2605: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;

2601: )
2602:
2603: as
2604: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2605: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;
2606: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;
2607: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;
2608: ddindx binary_integer; indx binary_integer;
2609: begin

Line 2606: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;

2602:
2603: as
2604: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2605: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;
2606: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;
2607: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;
2608: ddindx binary_integer; indx binary_integer;
2609: begin
2610:

Line 2607: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;

2603: as
2604: ddx_hdr_rec_type oks_entitlements_web.hdr_rec_type;
2605: ddx_hdr_addr_rec_type oks_entitlements_web.hdr_addr_rec_type;
2606: ddx_party_tbl_type oks_entitlements_web.party_tbl_type;
2607: ddx_line_tbl_type oks_entitlements_web.line_tbl_type;
2608: ddindx binary_integer; indx binary_integer;
2609: begin
2610:
2611: -- copy data to the local IN or IN-OUT args, if any

Line 2619: oks_entitlements_web.contract_overview(p_contract_id_arg,

2615:
2616:
2617:
2618: -- here's the delegated call to the old PL/SQL routine
2619: oks_entitlements_web.contract_overview(p_contract_id_arg,
2620: x_return_status,
2621: ddx_hdr_rec_type,
2622: ddx_hdr_addr_rec_type,
2623: ddx_party_tbl_type,

Line 2659: oks_entitlements_web_w.rosetta_table_copy_out_p37(ddx_party_tbl_type, p4_a0

2655: p3_a8 := ddx_hdr_addr_rec_type.ship_to_address;
2656: p3_a9 := ddx_hdr_addr_rec_type.ship_to_city_state_zip;
2657: p3_a10 := ddx_hdr_addr_rec_type.ship_to_country;
2658:
2659: oks_entitlements_web_w.rosetta_table_copy_out_p37(ddx_party_tbl_type, p4_a0
2660: , p4_a1
2661: , p4_a2
2662: , p4_a3
2663: , p4_a4

Line 2668: oks_entitlements_web_w.rosetta_table_copy_out_p39(ddx_line_tbl_type, p5_a0

2664: , p4_a5
2665: , p4_a6
2666: );
2667:
2668: oks_entitlements_web_w.rosetta_table_copy_out_p39(ddx_line_tbl_type, p5_a0
2669: , p5_a1
2670: , p5_a2
2671: , p5_a3
2672: , p5_a4

Line 2710: ddx_party_contact_tbl_type oks_entitlements_web.party_contact_tbl_type;

2706: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
2707: )
2708:
2709: as
2710: ddx_party_contact_tbl_type oks_entitlements_web.party_contact_tbl_type;
2711: ddindx binary_integer; indx binary_integer;
2712: begin
2713:
2714: -- copy data to the local IN or IN-OUT args, if any

Line 2720: oks_entitlements_web.party_overview(p_contract_id_arg,

2716:
2717:
2718:
2719: -- here's the delegated call to the old PL/SQL routine
2720: oks_entitlements_web.party_overview(p_contract_id_arg,
2721: p_party_rle_code_arg,
2722: x_return_status,
2723: ddx_party_contact_tbl_type);
2724:

Line 2729: oks_entitlements_web_w.rosetta_table_copy_out_p41(ddx_party_contact_tbl_type, p3_a0

2725: -- copy data back from the local variables to OUT or IN-OUT args, if any
2726:
2727:
2728:
2729: oks_entitlements_web_w.rosetta_table_copy_out_p41(ddx_party_contact_tbl_type, p3_a0
2730: , p3_a1
2731: , p3_a2
2732: , p3_a3
2733: , p3_a4

Line 2754: ddx_pty_cntct_dtls_tbl_type oks_entitlements_web.pty_cntct_dtls_tbl_type;

2750: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
2751: )
2752:
2753: as
2754: ddx_pty_cntct_dtls_tbl_type oks_entitlements_web.pty_cntct_dtls_tbl_type;
2755: ddindx binary_integer; indx binary_integer;
2756: begin
2757:
2758: -- copy data to the local IN or IN-OUT args, if any

Line 2763: oks_entitlements_web.party_contacts_overview(p_contact_id_arg,

2759:
2760:
2761:
2762: -- here's the delegated call to the old PL/SQL routine
2763: oks_entitlements_web.party_contacts_overview(p_contact_id_arg,
2764: x_return_status,
2765: ddx_pty_cntct_dtls_tbl_type);
2766:
2767: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 2770: oks_entitlements_web_w.rosetta_table_copy_out_p43(ddx_pty_cntct_dtls_tbl_type, p2_a0

2766:
2767: -- copy data back from the local variables to OUT or IN-OUT args, if any
2768:
2769:
2770: oks_entitlements_web_w.rosetta_table_copy_out_p43(ddx_pty_cntct_dtls_tbl_type, p2_a0
2771: , p2_a1
2772: , p2_a2
2773: , p2_a3
2774: , p2_a4

Line 2824: ddx_line_hdr_rec_type oks_entitlements_web.line_hdr_rec_type;

2820: , p4_a4 out nocopy JTF_DATE_TABLE
2821: )
2822:
2823: as
2824: ddx_line_hdr_rec_type oks_entitlements_web.line_hdr_rec_type;
2825: ddx_covered_level_tbl_type oks_entitlements_web.covered_level_tbl_type;
2826: ddx_cust_contacts_tbl_type oks_entitlements_web.cust_contacts_tbl_type;
2827: ddindx binary_integer; indx binary_integer;
2828: begin

Line 2825: ddx_covered_level_tbl_type oks_entitlements_web.covered_level_tbl_type;

2821: )
2822:
2823: as
2824: ddx_line_hdr_rec_type oks_entitlements_web.line_hdr_rec_type;
2825: ddx_covered_level_tbl_type oks_entitlements_web.covered_level_tbl_type;
2826: ddx_cust_contacts_tbl_type oks_entitlements_web.cust_contacts_tbl_type;
2827: ddindx binary_integer; indx binary_integer;
2828: begin
2829:

Line 2826: ddx_cust_contacts_tbl_type oks_entitlements_web.cust_contacts_tbl_type;

2822:
2823: as
2824: ddx_line_hdr_rec_type oks_entitlements_web.line_hdr_rec_type;
2825: ddx_covered_level_tbl_type oks_entitlements_web.covered_level_tbl_type;
2826: ddx_cust_contacts_tbl_type oks_entitlements_web.cust_contacts_tbl_type;
2827: ddindx binary_integer; indx binary_integer;
2828: begin
2829:
2830: -- copy data to the local IN or IN-OUT args, if any

Line 2837: oks_entitlements_web.line_overview(p_line_id_arg,

2833:
2834:
2835:
2836: -- here's the delegated call to the old PL/SQL routine
2837: oks_entitlements_web.line_overview(p_line_id_arg,
2838: x_return_status,
2839: ddx_line_hdr_rec_type,
2840: ddx_covered_level_tbl_type,
2841: ddx_cust_contacts_tbl_type);

Line 2871: oks_entitlements_web_w.rosetta_table_copy_out_p46(ddx_covered_level_tbl_type, p3_a0

2867: p2_a21 := ddx_line_hdr_rec_type.exception_cov_end_date;
2868: p2_a22 := ddx_line_hdr_rec_type.exception_cov_warranty_yn;
2869: p2_a23 := ddx_line_hdr_rec_type.exception_cov_type;
2870:
2871: oks_entitlements_web_w.rosetta_table_copy_out_p46(ddx_covered_level_tbl_type, p3_a0
2872: , p3_a1
2873: , p3_a2
2874: , p3_a3
2875: , p3_a4

Line 2882: oks_entitlements_web_w.rosetta_table_copy_out_p48(ddx_cust_contacts_tbl_type, p4_a0

2878: , p3_a7
2879: , p3_a8
2880: );
2881:
2882: oks_entitlements_web_w.rosetta_table_copy_out_p48(ddx_cust_contacts_tbl_type, p4_a0
2883: , p4_a1
2884: , p4_a2
2885: , p4_a3
2886: , p4_a4

Line 2906: ddx_coverage_rec_type oks_entitlements_web.coverage_rec_type;

2902: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_500
2903: )
2904:
2905: as
2906: ddx_coverage_rec_type oks_entitlements_web.coverage_rec_type;
2907: ddx_bus_proc_tbl_type oks_entitlements_web.bus_proc_tbl_type;
2908: ddindx binary_integer; indx binary_integer;
2909: begin
2910:

Line 2907: ddx_bus_proc_tbl_type oks_entitlements_web.bus_proc_tbl_type;

2903: )
2904:
2905: as
2906: ddx_coverage_rec_type oks_entitlements_web.coverage_rec_type;
2907: ddx_bus_proc_tbl_type oks_entitlements_web.bus_proc_tbl_type;
2908: ddindx binary_integer; indx binary_integer;
2909: begin
2910:
2911: -- copy data to the local IN or IN-OUT args, if any

Line 2918: oks_entitlements_web.coverage_overview(p_coverage_id_arg,

2914:
2915:
2916:
2917: -- here's the delegated call to the old PL/SQL routine
2918: oks_entitlements_web.coverage_overview(p_coverage_id_arg,
2919: p_contract_id_arg,
2920: x_return_status,
2921: ddx_coverage_rec_type,
2922: ddx_bus_proc_tbl_type);

Line 2933: oks_entitlements_web_w.rosetta_table_copy_out_p51(ddx_bus_proc_tbl_type, p4_a0

2929: p3_a1 := ddx_coverage_rec_type.coverage_wrrnty_inheritance;
2930: p3_a2 := ddx_coverage_rec_type.transfer_allowed;
2931: p3_a3 := ddx_coverage_rec_type.free_upgrade;
2932:
2933: oks_entitlements_web_w.rosetta_table_copy_out_p51(ddx_bus_proc_tbl_type, p4_a0
2934: , p4_a1
2935: , p4_a2
2936: , p4_a3
2937: , p4_a4

Line 2983: ddx_bus_proc_hdr_rec_type oks_entitlements_web.bus_proc_hdr_rec_type;

2979: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_500
2980: )
2981:
2982: as
2983: ddx_bus_proc_hdr_rec_type oks_entitlements_web.bus_proc_hdr_rec_type;
2984: ddx_coverage_times_tbl_type oks_entitlements_web.coverage_times_tbl_type;
2985: ddx_reaction_times_tbl_type oks_entitlements_web.reaction_times_tbl_type;
2986: ddx_resolution_times_tbl_type oks_entitlements_web.resolution_times_tbl_type;
2987: ddx_pref_resource_tbl_type oks_entitlements_web.pref_resource_tbl_type;

Line 2984: ddx_coverage_times_tbl_type oks_entitlements_web.coverage_times_tbl_type;

2980: )
2981:
2982: as
2983: ddx_bus_proc_hdr_rec_type oks_entitlements_web.bus_proc_hdr_rec_type;
2984: ddx_coverage_times_tbl_type oks_entitlements_web.coverage_times_tbl_type;
2985: ddx_reaction_times_tbl_type oks_entitlements_web.reaction_times_tbl_type;
2986: ddx_resolution_times_tbl_type oks_entitlements_web.resolution_times_tbl_type;
2987: ddx_pref_resource_tbl_type oks_entitlements_web.pref_resource_tbl_type;
2988: ddx_bus_proc_bil_typ_tbl_type oks_entitlements_web.bus_proc_bil_typ_tbl_type;

Line 2985: ddx_reaction_times_tbl_type oks_entitlements_web.reaction_times_tbl_type;

2981:
2982: as
2983: ddx_bus_proc_hdr_rec_type oks_entitlements_web.bus_proc_hdr_rec_type;
2984: ddx_coverage_times_tbl_type oks_entitlements_web.coverage_times_tbl_type;
2985: ddx_reaction_times_tbl_type oks_entitlements_web.reaction_times_tbl_type;
2986: ddx_resolution_times_tbl_type oks_entitlements_web.resolution_times_tbl_type;
2987: ddx_pref_resource_tbl_type oks_entitlements_web.pref_resource_tbl_type;
2988: ddx_bus_proc_bil_typ_tbl_type oks_entitlements_web.bus_proc_bil_typ_tbl_type;
2989: ddindx binary_integer; indx binary_integer;

Line 2986: ddx_resolution_times_tbl_type oks_entitlements_web.resolution_times_tbl_type;

2982: as
2983: ddx_bus_proc_hdr_rec_type oks_entitlements_web.bus_proc_hdr_rec_type;
2984: ddx_coverage_times_tbl_type oks_entitlements_web.coverage_times_tbl_type;
2985: ddx_reaction_times_tbl_type oks_entitlements_web.reaction_times_tbl_type;
2986: ddx_resolution_times_tbl_type oks_entitlements_web.resolution_times_tbl_type;
2987: ddx_pref_resource_tbl_type oks_entitlements_web.pref_resource_tbl_type;
2988: ddx_bus_proc_bil_typ_tbl_type oks_entitlements_web.bus_proc_bil_typ_tbl_type;
2989: ddindx binary_integer; indx binary_integer;
2990: begin

Line 2987: ddx_pref_resource_tbl_type oks_entitlements_web.pref_resource_tbl_type;

2983: ddx_bus_proc_hdr_rec_type oks_entitlements_web.bus_proc_hdr_rec_type;
2984: ddx_coverage_times_tbl_type oks_entitlements_web.coverage_times_tbl_type;
2985: ddx_reaction_times_tbl_type oks_entitlements_web.reaction_times_tbl_type;
2986: ddx_resolution_times_tbl_type oks_entitlements_web.resolution_times_tbl_type;
2987: ddx_pref_resource_tbl_type oks_entitlements_web.pref_resource_tbl_type;
2988: ddx_bus_proc_bil_typ_tbl_type oks_entitlements_web.bus_proc_bil_typ_tbl_type;
2989: ddindx binary_integer; indx binary_integer;
2990: begin
2991:

Line 2988: ddx_bus_proc_bil_typ_tbl_type oks_entitlements_web.bus_proc_bil_typ_tbl_type;

2984: ddx_coverage_times_tbl_type oks_entitlements_web.coverage_times_tbl_type;
2985: ddx_reaction_times_tbl_type oks_entitlements_web.reaction_times_tbl_type;
2986: ddx_resolution_times_tbl_type oks_entitlements_web.resolution_times_tbl_type;
2987: ddx_pref_resource_tbl_type oks_entitlements_web.pref_resource_tbl_type;
2988: ddx_bus_proc_bil_typ_tbl_type oks_entitlements_web.bus_proc_bil_typ_tbl_type;
2989: ddindx binary_integer; indx binary_integer;
2990: begin
2991:
2992: -- copy data to the local IN or IN-OUT args, if any

Line 3003: oks_entitlements_web.bus_proc_overview(p_bus_proc_id_arg,

2999:
3000:
3001:
3002: -- here's the delegated call to the old PL/SQL routine
3003: oks_entitlements_web.bus_proc_overview(p_bus_proc_id_arg,
3004: p_contract_id_arg,
3005: x_return_status,
3006: ddx_bus_proc_hdr_rec_type,
3007: ddx_coverage_times_tbl_type,

Line 3019: oks_entitlements_web_w.rosetta_table_copy_out_p54(ddx_coverage_times_tbl_type, p4_a0

3015:
3016:
3017: p3_a0 := ddx_bus_proc_hdr_rec_type.bus_proc_hdr_time_zone;
3018:
3019: oks_entitlements_web_w.rosetta_table_copy_out_p54(ddx_coverage_times_tbl_type, p4_a0
3020: , p4_a1
3021: , p4_a2
3022: );
3023:

Line 3024: oks_entitlements_web_w.rosetta_table_copy_out_p56(ddx_reaction_times_tbl_type, p5_a0

3020: , p4_a1
3021: , p4_a2
3022: );
3023:
3024: oks_entitlements_web_w.rosetta_table_copy_out_p56(ddx_reaction_times_tbl_type, p5_a0
3025: , p5_a1
3026: , p5_a2
3027: , p5_a3
3028: , p5_a4

Line 3037: oks_entitlements_web_w.rosetta_table_copy_out_p58(ddx_resolution_times_tbl_type, p6_a0

3033: , p5_a9
3034: , p5_a10
3035: );
3036:
3037: oks_entitlements_web_w.rosetta_table_copy_out_p58(ddx_resolution_times_tbl_type, p6_a0
3038: , p6_a1
3039: , p6_a2
3040: , p6_a3
3041: , p6_a4

Line 3050: oks_entitlements_web_w.rosetta_table_copy_out_p60(ddx_pref_resource_tbl_type, p7_a0

3046: , p6_a9
3047: , p6_a10
3048: );
3049:
3050: oks_entitlements_web_w.rosetta_table_copy_out_p60(ddx_pref_resource_tbl_type, p7_a0
3051: , p7_a1
3052: );
3053:
3054: oks_entitlements_web_w.rosetta_table_copy_out_p62(ddx_bus_proc_bil_typ_tbl_type, p8_a0

Line 3054: oks_entitlements_web_w.rosetta_table_copy_out_p62(ddx_bus_proc_bil_typ_tbl_type, p8_a0

3050: oks_entitlements_web_w.rosetta_table_copy_out_p60(ddx_pref_resource_tbl_type, p7_a0
3051: , p7_a1
3052: );
3053:
3054: oks_entitlements_web_w.rosetta_table_copy_out_p62(ddx_bus_proc_bil_typ_tbl_type, p8_a0
3055: , p8_a1
3056: , p8_a2
3057: , p8_a3
3058: , p8_a4

Line 3095: ddx_usage_hdr_rec_type oks_entitlements_web.usage_hdr_rec_type;

3091: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_2000
3092: )
3093:
3094: as
3095: ddx_usage_hdr_rec_type oks_entitlements_web.usage_hdr_rec_type;
3096: ddx_covered_prods_tbl_type oks_entitlements_web.covered_prods_tbl_type;
3097: ddindx binary_integer; indx binary_integer;
3098: begin
3099:

Line 3096: ddx_covered_prods_tbl_type oks_entitlements_web.covered_prods_tbl_type;

3092: )
3093:
3094: as
3095: ddx_usage_hdr_rec_type oks_entitlements_web.usage_hdr_rec_type;
3096: ddx_covered_prods_tbl_type oks_entitlements_web.covered_prods_tbl_type;
3097: ddindx binary_integer; indx binary_integer;
3098: begin
3099:
3100: -- copy data to the local IN or IN-OUT args, if any

Line 3106: oks_entitlements_web.usage_overview(p_line_id_arg,

3102:
3103:
3104:
3105: -- here's the delegated call to the old PL/SQL routine
3106: oks_entitlements_web.usage_overview(p_line_id_arg,
3107: x_return_status,
3108: ddx_usage_hdr_rec_type,
3109: ddx_covered_prods_tbl_type);
3110:

Line 3124: oks_entitlements_web_w.rosetta_table_copy_out_p65(ddx_covered_prods_tbl_type, p3_a0

3120: p2_a6 := ddx_usage_hdr_rec_type.usage_tax_code;
3121: p2_a7 := ddx_usage_hdr_rec_type.usage_tax_status;
3122: p2_a8 := ddx_usage_hdr_rec_type.usage_amount;
3123:
3124: oks_entitlements_web_w.rosetta_table_copy_out_p65(ddx_covered_prods_tbl_type, p3_a0
3125: , p3_a1
3126: , p3_a2
3127: , p3_a3
3128: , p3_a4

Line 3154: ddx_counter_tbl_type oks_entitlements_web.counter_tbl_type;

3150: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_500
3151: )
3152:
3153: as
3154: ddx_counter_tbl_type oks_entitlements_web.counter_tbl_type;
3155: ddindx binary_integer; indx binary_integer;
3156: begin
3157:
3158: -- copy data to the local IN or IN-OUT args, if any

Line 3163: oks_entitlements_web.product_overview(p_covered_prod_id_arg,

3159:
3160:
3161:
3162: -- here's the delegated call to the old PL/SQL routine
3163: oks_entitlements_web.product_overview(p_covered_prod_id_arg,
3164: x_return_status,
3165: ddx_counter_tbl_type);
3166:
3167: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 3170: oks_entitlements_web_w.rosetta_table_copy_out_p67(ddx_counter_tbl_type, p2_a0

3166:
3167: -- copy data back from the local variables to OUT or IN-OUT args, if any
3168:
3169:
3170: oks_entitlements_web_w.rosetta_table_copy_out_p67(ddx_counter_tbl_type, p2_a0
3171: , p2_a1
3172: , p2_a2
3173: , p2_a3
3174: , p2_a4

Line 3178: end oks_entitlements_web_w;

3174: , p2_a4
3175: );
3176: end;
3177:
3178: end oks_entitlements_web_w;