DBA Data[Home] [Help]

APPS.WSM_WIP_LOT_TXN_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 4: , a1 JTF_VARCHAR2_TABLE_300

1: package wsm_wip_lot_txn_pvt_w as
2: /* $Header: WSMVWLTS.pls 120.0 2005/07/26 23:52 nlal noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 11: , a1 out nocopy JTF_VARCHAR2_TABLE_300

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: );
10: procedure rosetta_table_copy_out_p5(t wsm_wip_lot_txn_pvt.wsm_job_secondary_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_VARCHAR2_TABLE_300
12: , a2 out nocopy JTF_NUMBER_TABLE
13: , a3 out nocopy JTF_VARCHAR2_TABLE_100
14: , a4 out nocopy JTF_NUMBER_TABLE
15: , a5 out nocopy JTF_NUMBER_TABLE

Line 19: , a1 JTF_VARCHAR2_TABLE_300

15: , a5 out nocopy JTF_NUMBER_TABLE
16: );
17:
18: procedure rosetta_table_copy_in_p6(t out nocopy wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_VARCHAR2_TABLE_300
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_NUMBER_TABLE
22: , a4 JTF_VARCHAR2_TABLE_300
23: , a5 JTF_VARCHAR2_TABLE_100

Line 22: , a4 JTF_VARCHAR2_TABLE_300

18: procedure rosetta_table_copy_in_p6(t out nocopy wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_VARCHAR2_TABLE_300
20: , a2 JTF_NUMBER_TABLE
21: , a3 JTF_NUMBER_TABLE
22: , a4 JTF_VARCHAR2_TABLE_300
23: , a5 JTF_VARCHAR2_TABLE_100
24: , a6 JTF_NUMBER_TABLE
25: , a7 JTF_VARCHAR2_TABLE_100
26: , a8 JTF_VARCHAR2_TABLE_100

Line 34: , a16 JTF_VARCHAR2_TABLE_300

30: , a12 JTF_NUMBER_TABLE
31: , a13 JTF_NUMBER_TABLE
32: , a14 JTF_NUMBER_TABLE
33: , a15 JTF_VARCHAR2_TABLE_100
34: , a16 JTF_VARCHAR2_TABLE_300
35: , a17 JTF_NUMBER_TABLE
36: , a18 JTF_NUMBER_TABLE
37: , a19 JTF_NUMBER_TABLE
38: , a20 JTF_VARCHAR2_TABLE_100

Line 79: , a1 out nocopy JTF_VARCHAR2_TABLE_300

75: , a57 JTF_VARCHAR2_TABLE_200
76: , a58 JTF_VARCHAR2_TABLE_200
77: );
78: procedure rosetta_table_copy_out_p6(t wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_VARCHAR2_TABLE_300
80: , a2 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_VARCHAR2_TABLE_300
83: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 82: , a4 out nocopy JTF_VARCHAR2_TABLE_300

78: procedure rosetta_table_copy_out_p6(t wsm_wip_lot_txn_pvt.wltx_starting_jobs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_VARCHAR2_TABLE_300
80: , a2 out nocopy JTF_NUMBER_TABLE
81: , a3 out nocopy JTF_NUMBER_TABLE
82: , a4 out nocopy JTF_VARCHAR2_TABLE_300
83: , a5 out nocopy JTF_VARCHAR2_TABLE_100
84: , a6 out nocopy JTF_NUMBER_TABLE
85: , a7 out nocopy JTF_VARCHAR2_TABLE_100
86: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 94: , a16 out nocopy JTF_VARCHAR2_TABLE_300

90: , a12 out nocopy JTF_NUMBER_TABLE
91: , a13 out nocopy JTF_NUMBER_TABLE
92: , a14 out nocopy JTF_NUMBER_TABLE
93: , a15 out nocopy JTF_VARCHAR2_TABLE_100
94: , a16 out nocopy JTF_VARCHAR2_TABLE_300
95: , a17 out nocopy JTF_NUMBER_TABLE
96: , a18 out nocopy JTF_NUMBER_TABLE
97: , a19 out nocopy JTF_NUMBER_TABLE
98: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 139: procedure rosetta_table_copy_in_p7(t out nocopy wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 JTF_VARCHAR2_TABLE_300

135: , a57 out nocopy JTF_VARCHAR2_TABLE_200
136: , a58 out nocopy JTF_VARCHAR2_TABLE_200
137: );
138:
139: procedure rosetta_table_copy_in_p7(t out nocopy wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 JTF_VARCHAR2_TABLE_300
140: , a1 JTF_NUMBER_TABLE
141: , a2 JTF_VARCHAR2_TABLE_300
142: , a3 JTF_NUMBER_TABLE
143: , a4 JTF_NUMBER_TABLE

Line 141: , a2 JTF_VARCHAR2_TABLE_300

137: );
138:
139: procedure rosetta_table_copy_in_p7(t out nocopy wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 JTF_VARCHAR2_TABLE_300
140: , a1 JTF_NUMBER_TABLE
141: , a2 JTF_VARCHAR2_TABLE_300
142: , a3 JTF_NUMBER_TABLE
143: , a4 JTF_NUMBER_TABLE
144: , a5 JTF_NUMBER_TABLE
145: , a6 JTF_NUMBER_TABLE

Line 171: , a32 JTF_VARCHAR2_TABLE_300

167: , a28 JTF_NUMBER_TABLE
168: , a29 JTF_NUMBER_TABLE
169: , a30 JTF_NUMBER_TABLE
170: , a31 JTF_VARCHAR2_TABLE_100
171: , a32 JTF_VARCHAR2_TABLE_300
172: , a33 JTF_NUMBER_TABLE
173: , a34 JTF_NUMBER_TABLE
174: , a35 JTF_VARCHAR2_TABLE_100
175: , a36 JTF_NUMBER_TABLE

Line 199: procedure rosetta_table_copy_out_p7(t wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

195: , a56 JTF_VARCHAR2_TABLE_200
196: , a57 JTF_VARCHAR2_TABLE_200
197: , a58 JTF_VARCHAR2_TABLE_200
198: );
199: procedure rosetta_table_copy_out_p7(t wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
200: , a1 out nocopy JTF_NUMBER_TABLE
201: , a2 out nocopy JTF_VARCHAR2_TABLE_300
202: , a3 out nocopy JTF_NUMBER_TABLE
203: , a4 out nocopy JTF_NUMBER_TABLE

Line 201: , a2 out nocopy JTF_VARCHAR2_TABLE_300

197: , a58 JTF_VARCHAR2_TABLE_200
198: );
199: procedure rosetta_table_copy_out_p7(t wsm_wip_lot_txn_pvt.wltx_resulting_jobs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
200: , a1 out nocopy JTF_NUMBER_TABLE
201: , a2 out nocopy JTF_VARCHAR2_TABLE_300
202: , a3 out nocopy JTF_NUMBER_TABLE
203: , a4 out nocopy JTF_NUMBER_TABLE
204: , a5 out nocopy JTF_NUMBER_TABLE
205: , a6 out nocopy JTF_NUMBER_TABLE

Line 231: , a32 out nocopy JTF_VARCHAR2_TABLE_300

227: , a28 out nocopy JTF_NUMBER_TABLE
228: , a29 out nocopy JTF_NUMBER_TABLE
229: , a30 out nocopy JTF_NUMBER_TABLE
230: , a31 out nocopy JTF_VARCHAR2_TABLE_100
231: , a32 out nocopy JTF_VARCHAR2_TABLE_300
232: , a33 out nocopy JTF_NUMBER_TABLE
233: , a34 out nocopy JTF_NUMBER_TABLE
234: , a35 out nocopy JTF_VARCHAR2_TABLE_100
235: , a36 out nocopy JTF_NUMBER_TABLE

Line 266: , a6 JTF_VARCHAR2_TABLE_300

262: , a2 JTF_NUMBER_TABLE
263: , a3 JTF_NUMBER_TABLE
264: , a4 JTF_NUMBER_TABLE
265: , a5 JTF_NUMBER_TABLE
266: , a6 JTF_VARCHAR2_TABLE_300
267: , a7 JTF_VARCHAR2_TABLE_300
268: , a8 JTF_NUMBER_TABLE
269: , a9 JTF_NUMBER_TABLE
270: , a10 JTF_VARCHAR2_TABLE_100

Line 267: , a7 JTF_VARCHAR2_TABLE_300

263: , a3 JTF_NUMBER_TABLE
264: , a4 JTF_NUMBER_TABLE
265: , a5 JTF_NUMBER_TABLE
266: , a6 JTF_VARCHAR2_TABLE_300
267: , a7 JTF_VARCHAR2_TABLE_300
268: , a8 JTF_NUMBER_TABLE
269: , a9 JTF_NUMBER_TABLE
270: , a10 JTF_VARCHAR2_TABLE_100
271: , a11 JTF_VARCHAR2_TABLE_100

Line 348: , a6 out nocopy JTF_VARCHAR2_TABLE_300

344: , a2 out nocopy JTF_NUMBER_TABLE
345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_NUMBER_TABLE
347: , a5 out nocopy JTF_NUMBER_TABLE
348: , a6 out nocopy JTF_VARCHAR2_TABLE_300
349: , a7 out nocopy JTF_VARCHAR2_TABLE_300
350: , a8 out nocopy JTF_NUMBER_TABLE
351: , a9 out nocopy JTF_NUMBER_TABLE
352: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 349: , a7 out nocopy JTF_VARCHAR2_TABLE_300

345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_NUMBER_TABLE
347: , a5 out nocopy JTF_NUMBER_TABLE
348: , a6 out nocopy JTF_VARCHAR2_TABLE_300
349: , a7 out nocopy JTF_VARCHAR2_TABLE_300
350: , a8 out nocopy JTF_NUMBER_TABLE
351: , a9 out nocopy JTF_NUMBER_TABLE
352: , a10 out nocopy JTF_VARCHAR2_TABLE_100
353: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 456: , p6_a1 JTF_VARCHAR2_TABLE_300

452: , p5_a22 VARCHAR2
453: , p5_a23 VARCHAR2
454: , p5_a24 VARCHAR2
455: , p6_a0 JTF_NUMBER_TABLE
456: , p6_a1 JTF_VARCHAR2_TABLE_300
457: , p6_a2 JTF_NUMBER_TABLE
458: , p6_a3 JTF_NUMBER_TABLE
459: , p6_a4 JTF_VARCHAR2_TABLE_300
460: , p6_a5 JTF_VARCHAR2_TABLE_100

Line 459: , p6_a4 JTF_VARCHAR2_TABLE_300

455: , p6_a0 JTF_NUMBER_TABLE
456: , p6_a1 JTF_VARCHAR2_TABLE_300
457: , p6_a2 JTF_NUMBER_TABLE
458: , p6_a3 JTF_NUMBER_TABLE
459: , p6_a4 JTF_VARCHAR2_TABLE_300
460: , p6_a5 JTF_VARCHAR2_TABLE_100
461: , p6_a6 JTF_NUMBER_TABLE
462: , p6_a7 JTF_VARCHAR2_TABLE_100
463: , p6_a8 JTF_VARCHAR2_TABLE_100

Line 471: , p6_a16 JTF_VARCHAR2_TABLE_300

467: , p6_a12 JTF_NUMBER_TABLE
468: , p6_a13 JTF_NUMBER_TABLE
469: , p6_a14 JTF_NUMBER_TABLE
470: , p6_a15 JTF_VARCHAR2_TABLE_100
471: , p6_a16 JTF_VARCHAR2_TABLE_300
472: , p6_a17 JTF_NUMBER_TABLE
473: , p6_a18 JTF_NUMBER_TABLE
474: , p6_a19 JTF_NUMBER_TABLE
475: , p6_a20 JTF_VARCHAR2_TABLE_100

Line 514: , p7_a0 JTF_VARCHAR2_TABLE_300

510: , p6_a55 JTF_VARCHAR2_TABLE_200
511: , p6_a56 JTF_VARCHAR2_TABLE_200
512: , p6_a57 JTF_VARCHAR2_TABLE_200
513: , p6_a58 JTF_VARCHAR2_TABLE_200
514: , p7_a0 JTF_VARCHAR2_TABLE_300
515: , p7_a1 JTF_NUMBER_TABLE
516: , p7_a2 JTF_VARCHAR2_TABLE_300
517: , p7_a3 JTF_NUMBER_TABLE
518: , p7_a4 JTF_NUMBER_TABLE

Line 516: , p7_a2 JTF_VARCHAR2_TABLE_300

512: , p6_a57 JTF_VARCHAR2_TABLE_200
513: , p6_a58 JTF_VARCHAR2_TABLE_200
514: , p7_a0 JTF_VARCHAR2_TABLE_300
515: , p7_a1 JTF_NUMBER_TABLE
516: , p7_a2 JTF_VARCHAR2_TABLE_300
517: , p7_a3 JTF_NUMBER_TABLE
518: , p7_a4 JTF_NUMBER_TABLE
519: , p7_a5 JTF_NUMBER_TABLE
520: , p7_a6 JTF_NUMBER_TABLE

Line 546: , p7_a32 JTF_VARCHAR2_TABLE_300

542: , p7_a28 JTF_NUMBER_TABLE
543: , p7_a29 JTF_NUMBER_TABLE
544: , p7_a30 JTF_NUMBER_TABLE
545: , p7_a31 JTF_VARCHAR2_TABLE_100
546: , p7_a32 JTF_VARCHAR2_TABLE_300
547: , p7_a33 JTF_NUMBER_TABLE
548: , p7_a34 JTF_NUMBER_TABLE
549: , p7_a35 JTF_VARCHAR2_TABLE_100
550: , p7_a36 JTF_NUMBER_TABLE

Line 579: , p8_a6 JTF_VARCHAR2_TABLE_300

575: , p8_a2 JTF_NUMBER_TABLE
576: , p8_a3 JTF_NUMBER_TABLE
577: , p8_a4 JTF_NUMBER_TABLE
578: , p8_a5 JTF_NUMBER_TABLE
579: , p8_a6 JTF_VARCHAR2_TABLE_300
580: , p8_a7 JTF_VARCHAR2_TABLE_300
581: , p8_a8 JTF_NUMBER_TABLE
582: , p8_a9 JTF_NUMBER_TABLE
583: , p8_a10 JTF_VARCHAR2_TABLE_100

Line 580: , p8_a7 JTF_VARCHAR2_TABLE_300

576: , p8_a3 JTF_NUMBER_TABLE
577: , p8_a4 JTF_NUMBER_TABLE
578: , p8_a5 JTF_NUMBER_TABLE
579: , p8_a6 JTF_VARCHAR2_TABLE_300
580: , p8_a7 JTF_VARCHAR2_TABLE_300
581: , p8_a8 JTF_NUMBER_TABLE
582: , p8_a9 JTF_NUMBER_TABLE
583: , p8_a10 JTF_VARCHAR2_TABLE_100
584: , p8_a11 JTF_VARCHAR2_TABLE_100

Line 655: , p9_a1 JTF_VARCHAR2_TABLE_300

651: , p8_a78 JTF_VARCHAR2_TABLE_200
652: , p8_a79 JTF_VARCHAR2_TABLE_200
653: , p8_a80 JTF_VARCHAR2_TABLE_200
654: , p9_a0 JTF_NUMBER_TABLE
655: , p9_a1 JTF_VARCHAR2_TABLE_300
656: , p9_a2 JTF_NUMBER_TABLE
657: , p9_a3 JTF_VARCHAR2_TABLE_100
658: , p9_a4 JTF_NUMBER_TABLE
659: , p9_a5 JTF_NUMBER_TABLE