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.CSP_SCH_INT_PVT_W dependencies on CSP_SCH_INT_PVT

Line 1: package body csp_sch_int_pvt_w as

1: package body csp_sch_int_pvt_w as
2: /* $Header: cspvscib.pls 115.12 2004/02/25 01:32:48 jjalla noship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as

Line 3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE

1: package body csp_sch_int_pvt_w as
2: /* $Header: cspvscib.pls 115.12 2004/02/25 01:32:48 jjalla noship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin

Line 9: t := csp_sch_int_pvt.csp_sch_resource_tbl_typ();

5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin
8: if a0 is not null and a0.count=0 then
9: t := csp_sch_int_pvt.csp_sch_resource_tbl_typ();
10: elsif a0 is not null and a0.count > 0 then
11: if a0.count > 0 then
12: t := csp_sch_int_pvt.csp_sch_resource_tbl_typ();
13: t.extend(a0.count);

Line 12: t := csp_sch_int_pvt.csp_sch_resource_tbl_typ();

8: if a0 is not null and a0.count=0 then
9: t := csp_sch_int_pvt.csp_sch_resource_tbl_typ();
10: elsif a0 is not null and a0.count > 0 then
11: if a0.count > 0 then
12: t := csp_sch_int_pvt.csp_sch_resource_tbl_typ();
13: t.extend(a0.count);
14: indx := a0.first;
15: ddindx := 1;
16: while true loop

Line 28: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

24: end loop;
25: end if;
26: end if;
27: end rosetta_table_copy_in_p13;
28: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin

Line 60: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE

56: end if;
57: end if;
58: end rosetta_table_copy_out_p13;
59:
60: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
61: , a1 JTF_VARCHAR2_TABLE_100
62: , a2 JTF_DATE_TABLE
63: , a3 JTF_NUMBER_TABLE
64: ) as

Line 68: t := csp_sch_int_pvt.csp_sch_options_tbl_typ();

64: ) as
65: ddindx binary_integer; indx binary_integer;
66: begin
67: if a0 is not null and a0.count=0 then
68: t := csp_sch_int_pvt.csp_sch_options_tbl_typ();
69: elsif a0 is not null and a0.count > 0 then
70: if a0.count > 0 then
71: t := csp_sch_int_pvt.csp_sch_options_tbl_typ();
72: t.extend(a0.count);

Line 71: t := csp_sch_int_pvt.csp_sch_options_tbl_typ();

67: if a0 is not null and a0.count=0 then
68: t := csp_sch_int_pvt.csp_sch_options_tbl_typ();
69: elsif a0 is not null and a0.count > 0 then
70: if a0.count > 0 then
71: t := csp_sch_int_pvt.csp_sch_options_tbl_typ();
72: t.extend(a0.count);
73: indx := a0.first;
74: ddindx := 1;
75: while true loop

Line 89: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

85: end loop;
86: end if;
87: end if;
88: end rosetta_table_copy_in_p14;
89: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_VARCHAR2_TABLE_100
91: , a2 out nocopy JTF_DATE_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: ) as

Line 133: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE

129: end if;
130: end if;
131: end rosetta_table_copy_out_p14;
132:
133: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_VARCHAR2_TABLE_100
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_VARCHAR2_TABLE_100

Line 147: t := csp_sch_int_pvt.csp_unavailability_tbl_type();

143: ) as
144: ddindx binary_integer; indx binary_integer;
145: begin
146: if a0 is not null and a0.count=0 then
147: t := csp_sch_int_pvt.csp_unavailability_tbl_type();
148: elsif a0 is not null and a0.count > 0 then
149: if a0.count > 0 then
150: t := csp_sch_int_pvt.csp_unavailability_tbl_type();
151: t.extend(a0.count);

Line 150: t := csp_sch_int_pvt.csp_unavailability_tbl_type();

146: if a0 is not null and a0.count=0 then
147: t := csp_sch_int_pvt.csp_unavailability_tbl_type();
148: elsif a0 is not null and a0.count > 0 then
149: if a0.count > 0 then
150: t := csp_sch_int_pvt.csp_unavailability_tbl_type();
151: t.extend(a0.count);
152: indx := a0.first;
153: ddindx := 1;
154: while true loop

Line 174: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

170: end loop;
171: end if;
172: end if;
173: end rosetta_table_copy_in_p15;
174: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 254: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE

250: end if;
251: end if;
252: end rosetta_table_copy_out_p15;
253:
254: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_VARCHAR2_TABLE_100
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_NUMBER_TABLE
258: , a4 JTF_NUMBER_TABLE

Line 274: t := csp_sch_int_pvt.csp_availability_tbl_type();

270: ) as
271: ddindx binary_integer; indx binary_integer;
272: begin
273: if a0 is not null and a0.count=0 then
274: t := csp_sch_int_pvt.csp_availability_tbl_type();
275: elsif a0 is not null and a0.count > 0 then
276: if a0.count > 0 then
277: t := csp_sch_int_pvt.csp_availability_tbl_type();
278: t.extend(a0.count);

Line 277: t := csp_sch_int_pvt.csp_availability_tbl_type();

273: if a0 is not null and a0.count=0 then
274: t := csp_sch_int_pvt.csp_availability_tbl_type();
275: elsif a0 is not null and a0.count > 0 then
276: if a0.count > 0 then
277: t := csp_sch_int_pvt.csp_availability_tbl_type();
278: t.extend(a0.count);
279: indx := a0.first;
280: ddindx := 1;
281: while true loop

Line 307: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

303: end loop;
304: end if;
305: end if;
306: end rosetta_table_copy_in_p16;
307: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
308: , a1 out nocopy JTF_VARCHAR2_TABLE_100
309: , a2 out nocopy JTF_NUMBER_TABLE
310: , a3 out nocopy JTF_NUMBER_TABLE
311: , a4 out nocopy JTF_NUMBER_TABLE

Line 423: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE

419: end if;
420: end if;
421: end rosetta_table_copy_out_p16;
422:
423: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_VARCHAR2_TABLE_100
425: , a2 JTF_VARCHAR2_TABLE_100
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_VARCHAR2_TABLE_100

Line 433: t := csp_sch_int_pvt.csp_parts_tbl_type();

429: ) as
430: ddindx binary_integer; indx binary_integer;
431: begin
432: if a0 is not null and a0.count=0 then
433: t := csp_sch_int_pvt.csp_parts_tbl_type();
434: elsif a0 is not null and a0.count > 0 then
435: if a0.count > 0 then
436: t := csp_sch_int_pvt.csp_parts_tbl_type();
437: t.extend(a0.count);

Line 436: t := csp_sch_int_pvt.csp_parts_tbl_type();

432: if a0 is not null and a0.count=0 then
433: t := csp_sch_int_pvt.csp_parts_tbl_type();
434: elsif a0 is not null and a0.count > 0 then
435: if a0.count > 0 then
436: t := csp_sch_int_pvt.csp_parts_tbl_type();
437: t.extend(a0.count);
438: indx := a0.first;
439: ddindx := 1;
440: while true loop

Line 456: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

452: end loop;
453: end if;
454: end if;
455: end rosetta_table_copy_in_p17;
456: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
457: , a1 out nocopy JTF_VARCHAR2_TABLE_100
458: , a2 out nocopy JTF_VARCHAR2_TABLE_100
459: , a3 out nocopy JTF_NUMBER_TABLE
460: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 512: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

508: end if;
509: end if;
510: end rosetta_table_copy_out_p17;
511:
512: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
513: , a1 JTF_VARCHAR2_TABLE_100
514: , a2 JTF_NUMBER_TABLE
515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_VARCHAR2_TABLE_100

Line 532: t := csp_sch_int_pvt.available_parts_tbl_typ();

528: ) as
529: ddindx binary_integer; indx binary_integer;
530: begin
531: if a0 is not null and a0.count=0 then
532: t := csp_sch_int_pvt.available_parts_tbl_typ();
533: elsif a0 is not null and a0.count > 0 then
534: if a0.count > 0 then
535: t := csp_sch_int_pvt.available_parts_tbl_typ();
536: t.extend(a0.count);

Line 535: t := csp_sch_int_pvt.available_parts_tbl_typ();

531: if a0 is not null and a0.count=0 then
532: t := csp_sch_int_pvt.available_parts_tbl_typ();
533: elsif a0 is not null and a0.count > 0 then
534: if a0.count > 0 then
535: t := csp_sch_int_pvt.available_parts_tbl_typ();
536: t.extend(a0.count);
537: indx := a0.first;
538: ddindx := 1;
539: while true loop

Line 565: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

561: end loop;
562: end if;
563: end if;
564: end rosetta_table_copy_in_p18;
565: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
566: , a1 out nocopy JTF_VARCHAR2_TABLE_100
567: , a2 out nocopy JTF_NUMBER_TABLE
568: , a3 out nocopy JTF_NUMBER_TABLE
569: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 681: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

677: end if;
678: end if;
679: end rosetta_table_copy_out_p18;
680:
681: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
682: , a1 JTF_VARCHAR2_TABLE_100
683: , a2 JTF_NUMBER_TABLE
684: , a3 JTF_NUMBER_TABLE
685: , a4 JTF_VARCHAR2_TABLE_100

Line 730: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE

726: end loop;
727: end if;
728: end if;
729: end rosetta_table_copy_in_p19;
730: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
731: , a1 out nocopy JTF_VARCHAR2_TABLE_100
732: , a2 out nocopy JTF_NUMBER_TABLE
733: , a3 out nocopy JTF_NUMBER_TABLE
734: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 829: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

825: end if;
826: end if;
827: end rosetta_table_copy_out_p19;
828:
829: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
830: , a1 JTF_VARCHAR2_TABLE_100
831: , a2 JTF_VARCHAR2_TABLE_100
832: , a3 JTF_NUMBER_TABLE
833: , a4 JTF_VARCHAR2_TABLE_100

Line 858: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE

854: end loop;
855: end if;
856: end if;
857: end rosetta_table_copy_in_p20;
858: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
859: , a1 out nocopy JTF_VARCHAR2_TABLE_100
860: , a2 out nocopy JTF_VARCHAR2_TABLE_100
861: , a3 out nocopy JTF_NUMBER_TABLE
862: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 907: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

903: end if;
904: end if;
905: end rosetta_table_copy_out_p20;
906:
907: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
908: , a1 JTF_VARCHAR2_TABLE_100
909: , a2 JTF_NUMBER_TABLE
910: , a3 JTF_VARCHAR2_TABLE_100
911: , a4 JTF_VARCHAR2_TABLE_100

Line 932: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();

928: ) as
929: ddindx binary_integer; indx binary_integer;
930: begin
931: if a0 is not null and a0.count=0 then
932: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();
933: elsif a0 is not null and a0.count > 0 then
934: if a0.count > 0 then
935: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();
936: t.extend(a0.count);

Line 935: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();

931: if a0 is not null and a0.count=0 then
932: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();
933: elsif a0 is not null and a0.count > 0 then
934: if a0.count > 0 then
935: t := csp_sch_int_pvt.ws_available_parts_tbl_typ();
936: t.extend(a0.count);
937: indx := a0.first;
938: ddindx := 1;
939: while true loop

Line 970: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

966: end loop;
967: end if;
968: end if;
969: end rosetta_table_copy_in_p21;
970: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
971: , a1 out nocopy JTF_VARCHAR2_TABLE_100
972: , a2 out nocopy JTF_NUMBER_TABLE
973: , a3 out nocopy JTF_VARCHAR2_TABLE_100
974: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1116: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100

1112: end if;
1113: end if;
1114: end rosetta_table_copy_out_p21;
1115:
1116: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1117: , a1 JTF_NUMBER_TABLE
1118: , a2 JTF_NUMBER_TABLE
1119: , a3 JTF_VARCHAR2_TABLE_100
1120: , a4 JTF_VARCHAR2_TABLE_100

Line 1126: t := csp_sch_int_pvt.csp_ws_resource_table_type();

1122: ) as
1123: ddindx binary_integer; indx binary_integer;
1124: begin
1125: if a0 is not null and a0.count=0 then
1126: t := csp_sch_int_pvt.csp_ws_resource_table_type();
1127: elsif a0 is not null and a0.count > 0 then
1128: if a0.count > 0 then
1129: t := csp_sch_int_pvt.csp_ws_resource_table_type();
1130: t.extend(a0.count);

Line 1129: t := csp_sch_int_pvt.csp_ws_resource_table_type();

1125: if a0 is not null and a0.count=0 then
1126: t := csp_sch_int_pvt.csp_ws_resource_table_type();
1127: elsif a0 is not null and a0.count > 0 then
1128: if a0.count > 0 then
1129: t := csp_sch_int_pvt.csp_ws_resource_table_type();
1130: t.extend(a0.count);
1131: indx := a0.first;
1132: ddindx := 1;
1133: while true loop

Line 1149: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

1145: end loop;
1146: end if;
1147: end if;
1148: end rosetta_table_copy_in_p22;
1149: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1150: , a1 out nocopy JTF_NUMBER_TABLE
1151: , a2 out nocopy JTF_NUMBER_TABLE
1152: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1153: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1205: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE

1201: end if;
1202: end if;
1203: end rosetta_table_copy_out_p22;
1204:
1205: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1206: , a1 JTF_VARCHAR2_TABLE_100
1207: , a2 JTF_VARCHAR2_TABLE_100
1208: , a3 JTF_NUMBER_TABLE
1209: , a4 JTF_NUMBER_TABLE

Line 1217: t := csp_sch_int_pvt.alternate_items_table_type();

1213: ) as
1214: ddindx binary_integer; indx binary_integer;
1215: begin
1216: if a0 is not null and a0.count=0 then
1217: t := csp_sch_int_pvt.alternate_items_table_type();
1218: elsif a0 is not null and a0.count > 0 then
1219: if a0.count > 0 then
1220: t := csp_sch_int_pvt.alternate_items_table_type();
1221: t.extend(a0.count);

Line 1220: t := csp_sch_int_pvt.alternate_items_table_type();

1216: if a0 is not null and a0.count=0 then
1217: t := csp_sch_int_pvt.alternate_items_table_type();
1218: elsif a0 is not null and a0.count > 0 then
1219: if a0.count > 0 then
1220: t := csp_sch_int_pvt.alternate_items_table_type();
1221: t.extend(a0.count);
1222: indx := a0.first;
1223: ddindx := 1;
1224: while true loop

Line 1242: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE

1238: end loop;
1239: end if;
1240: end if;
1241: end rosetta_table_copy_in_p23;
1242: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1243: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1244: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1245: , a3 out nocopy JTF_NUMBER_TABLE
1246: , a4 out nocopy JTF_NUMBER_TABLE

Line 1328: ddp_resources csp_sch_int_pvt.csp_sch_resource_tbl_typ;

1324: , x_msg_count out nocopy NUMBER
1325: )
1326:
1327: as
1328: ddp_resources csp_sch_int_pvt.csp_sch_resource_tbl_typ;
1329: ddp_interval csp_sch_int_pvt.csp_sch_interval_rec_typ;
1330: ddp_subinv_only boolean;
1331: ddx_options csp_sch_int_pvt.csp_sch_options_tbl_typ;
1332: ddindx binary_integer; indx binary_integer;

Line 1329: ddp_interval csp_sch_int_pvt.csp_sch_interval_rec_typ;

1325: )
1326:
1327: as
1328: ddp_resources csp_sch_int_pvt.csp_sch_resource_tbl_typ;
1329: ddp_interval csp_sch_int_pvt.csp_sch_interval_rec_typ;
1330: ddp_subinv_only boolean;
1331: ddx_options csp_sch_int_pvt.csp_sch_options_tbl_typ;
1332: ddindx binary_integer; indx binary_integer;
1333: begin

Line 1331: ddx_options csp_sch_int_pvt.csp_sch_options_tbl_typ;

1327: as
1328: ddp_resources csp_sch_int_pvt.csp_sch_resource_tbl_typ;
1329: ddp_interval csp_sch_int_pvt.csp_sch_interval_rec_typ;
1330: ddp_subinv_only boolean;
1331: ddx_options csp_sch_int_pvt.csp_sch_options_tbl_typ;
1332: ddindx binary_integer; indx binary_integer;
1333: begin
1334:
1335: -- copy data to the local IN or IN-OUT args, if any

Line 1338: csp_sch_int_pvt_w.rosetta_table_copy_in_p13(ddp_resources, p2_a0

1334:
1335: -- copy data to the local IN or IN-OUT args, if any
1336:
1337:
1338: csp_sch_int_pvt_w.rosetta_table_copy_in_p13(ddp_resources, p2_a0
1339: , p2_a1
1340: );
1341:
1342: ddp_interval.earliest_time := p3_a0;

Line 1358: csp_sch_int_pvt.get_availability_options(p_api_version_number,

1354:
1355:
1356:
1357: -- here's the delegated call to the old PL/SQL routine
1358: csp_sch_int_pvt.get_availability_options(p_api_version_number,
1359: p_task_id,
1360: ddp_resources,
1361: ddp_interval,
1362: p_likelihood,

Line 1376: csp_sch_int_pvt_w.rosetta_table_copy_out_p14(ddx_options, p6_a0

1372:
1373:
1374:
1375:
1376: csp_sch_int_pvt_w.rosetta_table_copy_out_p14(ddx_options, p6_a0
1377: , p6_a1
1378: , p6_a2
1379: , p6_a3
1380: );

Line 1400: ddp_options csp_sch_int_pvt.csp_sch_options_rec_typ;

1396: , x_msg_count out nocopy NUMBER
1397: )
1398:
1399: as
1400: ddp_options csp_sch_int_pvt.csp_sch_options_rec_typ;
1401: ddindx binary_integer; indx binary_integer;
1402: begin
1403:
1404: -- copy data to the local IN or IN-OUT args, if any

Line 1418: csp_sch_int_pvt.choose_option(p_api_version_number,

1414:
1415:
1416:
1417: -- here's the delegated call to the old PL/SQL routine
1418: csp_sch_int_pvt.choose_option(p_api_version_number,
1419: p_task_id,
1420: p_task_assignment_id,
1421: p_likelihood,
1422: ddp_options,

Line 1473: ddp_resource csp_sch_int_pvt.csp_sch_resources_rec_typ;

1469: , p_location_id NUMBER
1470: )
1471:
1472: as
1473: ddp_resource csp_sch_int_pvt.csp_sch_resources_rec_typ;
1474: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1475: ddx_availability csp_sch_int_pvt.available_parts_tbl_typ1;
1476: ddindx binary_integer; indx binary_integer;
1477: begin

Line 1474: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;

1470: )
1471:
1472: as
1473: ddp_resource csp_sch_int_pvt.csp_sch_resources_rec_typ;
1474: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1475: ddx_availability csp_sch_int_pvt.available_parts_tbl_typ1;
1476: ddindx binary_integer; indx binary_integer;
1477: begin
1478:

Line 1475: ddx_availability csp_sch_int_pvt.available_parts_tbl_typ1;

1471:
1472: as
1473: ddp_resource csp_sch_int_pvt.csp_sch_resources_rec_typ;
1474: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1475: ddx_availability csp_sch_int_pvt.available_parts_tbl_typ1;
1476: ddindx binary_integer; indx binary_integer;
1477: begin
1478:
1479: -- copy data to the local IN or IN-OUT args, if any

Line 1486: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p4_a0

1482:
1483:
1484:
1485:
1486: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p4_a0
1487: , p4_a1
1488: , p4_a2
1489: , p4_a3
1490: , p4_a4

Line 1502: csp_sch_int_pvt.check_parts_availability(ddp_resource,

1498:
1499:
1500:
1501: -- here's the delegated call to the old PL/SQL routine
1502: csp_sch_int_pvt.check_parts_availability(ddp_resource,
1503: p_organization_id,
1504: p_subinv_code,
1505: p_need_by_date,
1506: ddp_parts_list,

Line 1522: csp_sch_int_pvt_w.rosetta_table_copy_out_p19(ddx_availability, p6_a0

1518:
1519:
1520:
1521:
1522: csp_sch_int_pvt_w.rosetta_table_copy_out_p19(ddx_availability, p6_a0
1523: , p6_a1
1524: , p6_a2
1525: , p6_a3
1526: , p6_a4

Line 1559: ddp_reservation_parts csp_sch_int_pvt.reservation_rec_typ;

1555: , x_msg_data out nocopy VARCHAR2
1556: ) return number
1557:
1558: as
1559: ddp_reservation_parts csp_sch_int_pvt.reservation_rec_typ;
1560: ddindx binary_integer; indx binary_integer;
1561: ddrosetta_retval number;
1562: begin
1563:

Line 1577: ddrosetta_retval := csp_sch_int_pvt.create_reservation(ddp_reservation_parts,

1573:
1574:
1575:
1576: -- here's the delegated call to the old PL/SQL routine
1577: ddrosetta_retval := csp_sch_int_pvt.create_reservation(ddp_reservation_parts,
1578: x_return_status,
1579: x_msg_data);
1580:
1581: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1628: ddp_resource_list csp_sch_int_pvt.csp_ws_resource_table_type;

1624: , x_msg_count out nocopy NUMBER
1625: )
1626:
1627: as
1628: ddp_resource_list csp_sch_int_pvt.csp_ws_resource_table_type;
1629: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1630: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1631: ddindx binary_integer; indx binary_integer;
1632: begin

Line 1629: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;

1625: )
1626:
1627: as
1628: ddp_resource_list csp_sch_int_pvt.csp_ws_resource_table_type;
1629: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1630: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1631: ddindx binary_integer; indx binary_integer;
1632: begin
1633:

Line 1630: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;

1626:
1627: as
1628: ddp_resource_list csp_sch_int_pvt.csp_ws_resource_table_type;
1629: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1630: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1631: ddindx binary_integer; indx binary_integer;
1632: begin
1633:
1634: -- copy data to the local IN or IN-OUT args, if any

Line 1635: csp_sch_int_pvt_w.rosetta_table_copy_in_p22(ddp_resource_list, p0_a0

1631: ddindx binary_integer; indx binary_integer;
1632: begin
1633:
1634: -- copy data to the local IN or IN-OUT args, if any
1635: csp_sch_int_pvt_w.rosetta_table_copy_in_p22(ddp_resource_list, p0_a0
1636: , p0_a1
1637: , p0_a2
1638: , p0_a3
1639: , p0_a4

Line 1643: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p1_a0

1639: , p0_a4
1640: , p0_a5
1641: );
1642:
1643: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p1_a0
1644: , p1_a1
1645: , p1_a2
1646: , p1_a3
1647: , p1_a4

Line 1657: csp_sch_int_pvt.ws_check_other_eng_subinv(ddp_resource_list,

1653:
1654:
1655:
1656: -- here's the delegated call to the old PL/SQL routine
1657: csp_sch_int_pvt.ws_check_other_eng_subinv(ddp_resource_list,
1658: ddp_parts_list,
1659: p_include_alternate,
1660: ddx_available_list,
1661: x_return_status,

Line 1669: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p3_a0

1665: -- copy data back from the local variables to OUT or IN-OUT args, if any
1666:
1667:
1668:
1669: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p3_a0
1670: , p3_a1
1671: , p3_a2
1672: , p3_a3
1673: , p3_a4

Line 1732: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;

1728: , x_msg_count out nocopy NUMBER
1729: )
1730:
1731: as
1732: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1733: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1734: ddindx binary_integer; indx binary_integer;
1735: begin
1736:

Line 1733: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;

1729: )
1730:
1731: as
1732: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1733: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1734: ddindx binary_integer; indx binary_integer;
1735: begin
1736:
1737: -- copy data to the local IN or IN-OUT args, if any

Line 1740: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p2_a0

1736:
1737: -- copy data to the local IN or IN-OUT args, if any
1738:
1739:
1740: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p2_a0
1741: , p2_a1
1742: , p2_a2
1743: , p2_a3
1744: , p2_a4

Line 1754: csp_sch_int_pvt.ws_check_engineers_subinv(p_resource_type,

1750:
1751:
1752:
1753: -- here's the delegated call to the old PL/SQL routine
1754: csp_sch_int_pvt.ws_check_engineers_subinv(p_resource_type,
1755: p_resource_id,
1756: ddp_parts_list,
1757: p_include_alternate,
1758: ddx_available_list,

Line 1768: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p4_a0

1764:
1765:
1766:
1767:
1768: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p4_a0
1769: , p4_a1
1770: , p4_a2
1771: , p4_a3
1772: , p4_a4

Line 1831: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;

1827: , x_msg_count out nocopy NUMBER
1828: )
1829:
1830: as
1831: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1832: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1833: ddindx binary_integer; indx binary_integer;
1834: begin
1835:

Line 1832: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;

1828: )
1829:
1830: as
1831: ddp_parts_list csp_sch_int_pvt.csp_parts_tbl_typ1;
1832: ddx_available_list csp_sch_int_pvt.ws_available_parts_tbl_typ;
1833: ddindx binary_integer; indx binary_integer;
1834: begin
1835:
1836: -- copy data to the local IN or IN-OUT args, if any

Line 1839: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p2_a0

1835:
1836: -- copy data to the local IN or IN-OUT args, if any
1837:
1838:
1839: csp_sch_int_pvt_w.rosetta_table_copy_in_p20(ddp_parts_list, p2_a0
1840: , p2_a1
1841: , p2_a2
1842: , p2_a3
1843: , p2_a4

Line 1853: csp_sch_int_pvt.ws_check_organizations(p_resource_type,

1849:
1850:
1851:
1852: -- here's the delegated call to the old PL/SQL routine
1853: csp_sch_int_pvt.ws_check_organizations(p_resource_type,
1854: p_resource_id,
1855: ddp_parts_list,
1856: p_include_alternate,
1857: ddx_available_list,

Line 1867: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p4_a0

1863:
1864:
1865:
1866:
1867: csp_sch_int_pvt_w.rosetta_table_copy_out_p21(ddx_available_list, p4_a0
1868: , p4_a1
1869: , p4_a2
1870: , p4_a3
1871: , p4_a4

Line 1915: ddp_parts_rec csp_sch_int_pvt.csp_parts_rec_type;

1911: , x_msg_count out nocopy NUMBER
1912: )
1913:
1914: as
1915: ddp_parts_rec csp_sch_int_pvt.csp_parts_rec_type;
1916: ddpx_alternate_items csp_sch_int_pvt.alternate_items_table_type;
1917: ddindx binary_integer; indx binary_integer;
1918: begin
1919:

Line 1916: ddpx_alternate_items csp_sch_int_pvt.alternate_items_table_type;

1912: )
1913:
1914: as
1915: ddp_parts_rec csp_sch_int_pvt.csp_parts_rec_type;
1916: ddpx_alternate_items csp_sch_int_pvt.alternate_items_table_type;
1917: ddindx binary_integer; indx binary_integer;
1918: begin
1919:
1920: -- copy data to the local IN or IN-OUT args, if any

Line 1929: csp_sch_int_pvt_w.rosetta_table_copy_in_p23(ddpx_alternate_items, p2_a0

1925: ddp_parts_rec.ship_set_name := p0_a4;
1926: ddp_parts_rec.line_id := p0_a5;
1927:
1928:
1929: csp_sch_int_pvt_w.rosetta_table_copy_in_p23(ddpx_alternate_items, p2_a0
1930: , p2_a1
1931: , p2_a2
1932: , p2_a3
1933: , p2_a4

Line 1943: csp_sch_int_pvt.get_alternates(ddp_parts_rec,

1939:
1940:
1941:
1942: -- here's the delegated call to the old PL/SQL routine
1943: csp_sch_int_pvt.get_alternates(ddp_parts_rec,
1944: p_org_id,
1945: ddpx_alternate_items,
1946: x_return_status,
1947: x_msg_data,

Line 1953: csp_sch_int_pvt_w.rosetta_table_copy_out_p23(ddpx_alternate_items, p2_a0

1949:
1950: -- copy data back from the local variables to OUT or IN-OUT args, if any
1951:
1952:
1953: csp_sch_int_pvt_w.rosetta_table_copy_out_p23(ddpx_alternate_items, p2_a0
1954: , p2_a1
1955: , p2_a2
1956: , p2_a3
1957: , p2_a4

Line 1988: csp_sch_int_pvt.get_delivery_date(p_relation_ship_id,

1984:
1985:
1986:
1987: -- here's the delegated call to the old PL/SQL routine
1988: csp_sch_int_pvt.get_delivery_date(p_relation_ship_id,
1989: x_delivery_date,
1990: ddx_shipping_option,
1991: x_return_status,
1992: x_msg_data,

Line 2009: end csp_sch_int_pvt_w;

2005:
2006:
2007: end;
2008:
2009: end csp_sch_int_pvt_w;