DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: );
11: procedure rosetta_table_copy_out_p3(t csd_hv_wip_job_pvt.mv_txn_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
12: , a1 out nocopy JTF_NUMBER_TABLE

Line 16: , a5 out nocopy JTF_VARCHAR2_TABLE_100

12: , a1 out nocopy JTF_NUMBER_TABLE
13: , a2 out nocopy JTF_NUMBER_TABLE
14: , a3 out nocopy JTF_NUMBER_TABLE
15: , a4 out nocopy JTF_NUMBER_TABLE
16: , a5 out nocopy JTF_VARCHAR2_TABLE_100
17: , a6 out nocopy JTF_NUMBER_TABLE
18: );
19:
20: procedure rosetta_table_copy_in_p5(t out nocopy csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE

Line 30: , a10 JTF_VARCHAR2_TABLE_100

26: , a6 JTF_NUMBER_TABLE
27: , a7 JTF_NUMBER_TABLE
28: , a8 JTF_NUMBER_TABLE
29: , a9 JTF_NUMBER_TABLE
30: , a10 JTF_VARCHAR2_TABLE_100
31: , a11 JTF_VARCHAR2_TABLE_100
32: , a12 JTF_VARCHAR2_TABLE_100
33: , a13 JTF_VARCHAR2_TABLE_100
34: , a14 JTF_VARCHAR2_TABLE_100

Line 31: , a11 JTF_VARCHAR2_TABLE_100

27: , a7 JTF_NUMBER_TABLE
28: , a8 JTF_NUMBER_TABLE
29: , a9 JTF_NUMBER_TABLE
30: , a10 JTF_VARCHAR2_TABLE_100
31: , a11 JTF_VARCHAR2_TABLE_100
32: , a12 JTF_VARCHAR2_TABLE_100
33: , a13 JTF_VARCHAR2_TABLE_100
34: , a14 JTF_VARCHAR2_TABLE_100
35: , a15 JTF_NUMBER_TABLE

Line 32: , a12 JTF_VARCHAR2_TABLE_100

28: , a8 JTF_NUMBER_TABLE
29: , a9 JTF_NUMBER_TABLE
30: , a10 JTF_VARCHAR2_TABLE_100
31: , a11 JTF_VARCHAR2_TABLE_100
32: , a12 JTF_VARCHAR2_TABLE_100
33: , a13 JTF_VARCHAR2_TABLE_100
34: , a14 JTF_VARCHAR2_TABLE_100
35: , a15 JTF_NUMBER_TABLE
36: , a16 JTF_NUMBER_TABLE

Line 33: , a13 JTF_VARCHAR2_TABLE_100

29: , a9 JTF_NUMBER_TABLE
30: , a10 JTF_VARCHAR2_TABLE_100
31: , a11 JTF_VARCHAR2_TABLE_100
32: , a12 JTF_VARCHAR2_TABLE_100
33: , a13 JTF_VARCHAR2_TABLE_100
34: , a14 JTF_VARCHAR2_TABLE_100
35: , a15 JTF_NUMBER_TABLE
36: , a16 JTF_NUMBER_TABLE
37: , a17 JTF_NUMBER_TABLE

Line 34: , a14 JTF_VARCHAR2_TABLE_100

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

Line 38: , a18 JTF_VARCHAR2_TABLE_100

34: , a14 JTF_VARCHAR2_TABLE_100
35: , a15 JTF_NUMBER_TABLE
36: , a16 JTF_NUMBER_TABLE
37: , a17 JTF_NUMBER_TABLE
38: , a18 JTF_VARCHAR2_TABLE_100
39: , a19 JTF_NUMBER_TABLE
40: , a20 JTF_NUMBER_TABLE
41: , a21 JTF_NUMBER_TABLE
42: , a22 JTF_VARCHAR2_TABLE_100

Line 42: , a22 JTF_VARCHAR2_TABLE_100

38: , a18 JTF_VARCHAR2_TABLE_100
39: , a19 JTF_NUMBER_TABLE
40: , a20 JTF_NUMBER_TABLE
41: , a21 JTF_NUMBER_TABLE
42: , a22 JTF_VARCHAR2_TABLE_100
43: , a23 JTF_NUMBER_TABLE
44: );
45: procedure rosetta_table_copy_out_p5(t csd_hv_wip_job_pvt.mtl_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE

Line 55: , a10 out nocopy JTF_VARCHAR2_TABLE_100

51: , a6 out nocopy JTF_NUMBER_TABLE
52: , a7 out nocopy JTF_NUMBER_TABLE
53: , a8 out nocopy JTF_NUMBER_TABLE
54: , a9 out nocopy JTF_NUMBER_TABLE
55: , a10 out nocopy JTF_VARCHAR2_TABLE_100
56: , a11 out nocopy JTF_VARCHAR2_TABLE_100
57: , a12 out nocopy JTF_VARCHAR2_TABLE_100
58: , a13 out nocopy JTF_VARCHAR2_TABLE_100
59: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 56: , a11 out nocopy JTF_VARCHAR2_TABLE_100

52: , a7 out nocopy JTF_NUMBER_TABLE
53: , a8 out nocopy JTF_NUMBER_TABLE
54: , a9 out nocopy JTF_NUMBER_TABLE
55: , a10 out nocopy JTF_VARCHAR2_TABLE_100
56: , a11 out nocopy JTF_VARCHAR2_TABLE_100
57: , a12 out nocopy JTF_VARCHAR2_TABLE_100
58: , a13 out nocopy JTF_VARCHAR2_TABLE_100
59: , a14 out nocopy JTF_VARCHAR2_TABLE_100
60: , a15 out nocopy JTF_NUMBER_TABLE

Line 57: , a12 out nocopy JTF_VARCHAR2_TABLE_100

53: , a8 out nocopy JTF_NUMBER_TABLE
54: , a9 out nocopy JTF_NUMBER_TABLE
55: , a10 out nocopy JTF_VARCHAR2_TABLE_100
56: , a11 out nocopy JTF_VARCHAR2_TABLE_100
57: , a12 out nocopy JTF_VARCHAR2_TABLE_100
58: , a13 out nocopy JTF_VARCHAR2_TABLE_100
59: , a14 out nocopy JTF_VARCHAR2_TABLE_100
60: , a15 out nocopy JTF_NUMBER_TABLE
61: , a16 out nocopy JTF_NUMBER_TABLE

Line 58: , a13 out nocopy JTF_VARCHAR2_TABLE_100

54: , a9 out nocopy JTF_NUMBER_TABLE
55: , a10 out nocopy JTF_VARCHAR2_TABLE_100
56: , a11 out nocopy JTF_VARCHAR2_TABLE_100
57: , a12 out nocopy JTF_VARCHAR2_TABLE_100
58: , a13 out nocopy JTF_VARCHAR2_TABLE_100
59: , a14 out nocopy JTF_VARCHAR2_TABLE_100
60: , a15 out nocopy JTF_NUMBER_TABLE
61: , a16 out nocopy JTF_NUMBER_TABLE
62: , a17 out nocopy JTF_NUMBER_TABLE

Line 59: , a14 out nocopy JTF_VARCHAR2_TABLE_100

55: , a10 out nocopy JTF_VARCHAR2_TABLE_100
56: , a11 out nocopy JTF_VARCHAR2_TABLE_100
57: , a12 out nocopy JTF_VARCHAR2_TABLE_100
58: , a13 out nocopy JTF_VARCHAR2_TABLE_100
59: , a14 out nocopy JTF_VARCHAR2_TABLE_100
60: , a15 out nocopy JTF_NUMBER_TABLE
61: , a16 out nocopy JTF_NUMBER_TABLE
62: , a17 out nocopy JTF_NUMBER_TABLE
63: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 63: , a18 out nocopy JTF_VARCHAR2_TABLE_100

59: , a14 out nocopy JTF_VARCHAR2_TABLE_100
60: , a15 out nocopy JTF_NUMBER_TABLE
61: , a16 out nocopy JTF_NUMBER_TABLE
62: , a17 out nocopy JTF_NUMBER_TABLE
63: , a18 out nocopy JTF_VARCHAR2_TABLE_100
64: , a19 out nocopy JTF_NUMBER_TABLE
65: , a20 out nocopy JTF_NUMBER_TABLE
66: , a21 out nocopy JTF_NUMBER_TABLE
67: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: , a22 out nocopy JTF_VARCHAR2_TABLE_100

63: , a18 out nocopy JTF_VARCHAR2_TABLE_100
64: , a19 out nocopy JTF_NUMBER_TABLE
65: , a20 out nocopy JTF_NUMBER_TABLE
66: , a21 out nocopy JTF_NUMBER_TABLE
67: , a22 out nocopy JTF_VARCHAR2_TABLE_100
68: , a23 out nocopy JTF_NUMBER_TABLE
69: );
70:
71: procedure rosetta_table_copy_in_p7(t out nocopy csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 JTF_NUMBER_TABLE

Line 82: , a11 JTF_VARCHAR2_TABLE_100

78: , a7 JTF_NUMBER_TABLE
79: , a8 JTF_NUMBER_TABLE
80: , a9 JTF_NUMBER_TABLE
81: , a10 JTF_NUMBER_TABLE
82: , a11 JTF_VARCHAR2_TABLE_100
83: , a12 JTF_NUMBER_TABLE
84: , a13 JTF_NUMBER_TABLE
85: , a14 JTF_VARCHAR2_TABLE_100
86: , a15 JTF_VARCHAR2_TABLE_100

Line 85: , a14 JTF_VARCHAR2_TABLE_100

81: , a10 JTF_NUMBER_TABLE
82: , a11 JTF_VARCHAR2_TABLE_100
83: , a12 JTF_NUMBER_TABLE
84: , a13 JTF_NUMBER_TABLE
85: , a14 JTF_VARCHAR2_TABLE_100
86: , a15 JTF_VARCHAR2_TABLE_100
87: , a16 JTF_VARCHAR2_TABLE_100
88: , a17 JTF_NUMBER_TABLE
89: , a18 JTF_VARCHAR2_TABLE_100

Line 86: , a15 JTF_VARCHAR2_TABLE_100

82: , a11 JTF_VARCHAR2_TABLE_100
83: , a12 JTF_NUMBER_TABLE
84: , a13 JTF_NUMBER_TABLE
85: , a14 JTF_VARCHAR2_TABLE_100
86: , a15 JTF_VARCHAR2_TABLE_100
87: , a16 JTF_VARCHAR2_TABLE_100
88: , a17 JTF_NUMBER_TABLE
89: , a18 JTF_VARCHAR2_TABLE_100
90: , a19 JTF_NUMBER_TABLE

Line 87: , a16 JTF_VARCHAR2_TABLE_100

83: , a12 JTF_NUMBER_TABLE
84: , a13 JTF_NUMBER_TABLE
85: , a14 JTF_VARCHAR2_TABLE_100
86: , a15 JTF_VARCHAR2_TABLE_100
87: , a16 JTF_VARCHAR2_TABLE_100
88: , a17 JTF_NUMBER_TABLE
89: , a18 JTF_VARCHAR2_TABLE_100
90: , a19 JTF_NUMBER_TABLE
91: , a20 JTF_VARCHAR2_TABLE_100

Line 89: , a18 JTF_VARCHAR2_TABLE_100

85: , a14 JTF_VARCHAR2_TABLE_100
86: , a15 JTF_VARCHAR2_TABLE_100
87: , a16 JTF_VARCHAR2_TABLE_100
88: , a17 JTF_NUMBER_TABLE
89: , a18 JTF_VARCHAR2_TABLE_100
90: , a19 JTF_NUMBER_TABLE
91: , a20 JTF_VARCHAR2_TABLE_100
92: );
93: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 91: , a20 JTF_VARCHAR2_TABLE_100

87: , a16 JTF_VARCHAR2_TABLE_100
88: , a17 JTF_NUMBER_TABLE
89: , a18 JTF_VARCHAR2_TABLE_100
90: , a19 JTF_NUMBER_TABLE
91: , a20 JTF_VARCHAR2_TABLE_100
92: );
93: procedure rosetta_table_copy_out_p7(t csd_hv_wip_job_pvt.res_txn_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_NUMBER_TABLE

Line 104: , a11 out nocopy JTF_VARCHAR2_TABLE_100

100: , a7 out nocopy JTF_NUMBER_TABLE
101: , a8 out nocopy JTF_NUMBER_TABLE
102: , a9 out nocopy JTF_NUMBER_TABLE
103: , a10 out nocopy JTF_NUMBER_TABLE
104: , a11 out nocopy JTF_VARCHAR2_TABLE_100
105: , a12 out nocopy JTF_NUMBER_TABLE
106: , a13 out nocopy JTF_NUMBER_TABLE
107: , a14 out nocopy JTF_VARCHAR2_TABLE_100
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 107: , a14 out nocopy JTF_VARCHAR2_TABLE_100

103: , a10 out nocopy JTF_NUMBER_TABLE
104: , a11 out nocopy JTF_VARCHAR2_TABLE_100
105: , a12 out nocopy JTF_NUMBER_TABLE
106: , a13 out nocopy JTF_NUMBER_TABLE
107: , a14 out nocopy JTF_VARCHAR2_TABLE_100
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100
109: , a16 out nocopy JTF_VARCHAR2_TABLE_100
110: , a17 out nocopy JTF_NUMBER_TABLE
111: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a15 out nocopy JTF_VARCHAR2_TABLE_100

104: , a11 out nocopy JTF_VARCHAR2_TABLE_100
105: , a12 out nocopy JTF_NUMBER_TABLE
106: , a13 out nocopy JTF_NUMBER_TABLE
107: , a14 out nocopy JTF_VARCHAR2_TABLE_100
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100
109: , a16 out nocopy JTF_VARCHAR2_TABLE_100
110: , a17 out nocopy JTF_NUMBER_TABLE
111: , a18 out nocopy JTF_VARCHAR2_TABLE_100
112: , a19 out nocopy JTF_NUMBER_TABLE

Line 109: , a16 out nocopy JTF_VARCHAR2_TABLE_100

105: , a12 out nocopy JTF_NUMBER_TABLE
106: , a13 out nocopy JTF_NUMBER_TABLE
107: , a14 out nocopy JTF_VARCHAR2_TABLE_100
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100
109: , a16 out nocopy JTF_VARCHAR2_TABLE_100
110: , a17 out nocopy JTF_NUMBER_TABLE
111: , a18 out nocopy JTF_VARCHAR2_TABLE_100
112: , a19 out nocopy JTF_NUMBER_TABLE
113: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 111: , a18 out nocopy JTF_VARCHAR2_TABLE_100

107: , a14 out nocopy JTF_VARCHAR2_TABLE_100
108: , a15 out nocopy JTF_VARCHAR2_TABLE_100
109: , a16 out nocopy JTF_VARCHAR2_TABLE_100
110: , a17 out nocopy JTF_NUMBER_TABLE
111: , a18 out nocopy JTF_VARCHAR2_TABLE_100
112: , a19 out nocopy JTF_NUMBER_TABLE
113: , a20 out nocopy JTF_VARCHAR2_TABLE_100
114: );
115:

Line 113: , a20 out nocopy JTF_VARCHAR2_TABLE_100

109: , a16 out nocopy JTF_VARCHAR2_TABLE_100
110: , a17 out nocopy JTF_NUMBER_TABLE
111: , a18 out nocopy JTF_VARCHAR2_TABLE_100
112: , a19 out nocopy JTF_NUMBER_TABLE
113: , a20 out nocopy JTF_VARCHAR2_TABLE_100
114: );
115:
116: procedure rosetta_table_copy_in_p9(t out nocopy csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE

Line 130: , a14 JTF_VARCHAR2_TABLE_100

126: , a10 JTF_NUMBER_TABLE
127: , a11 JTF_NUMBER_TABLE
128: , a12 JTF_NUMBER_TABLE
129: , a13 JTF_NUMBER_TABLE
130: , a14 JTF_VARCHAR2_TABLE_100
131: , a15 JTF_VARCHAR2_TABLE_100
132: , a16 JTF_NUMBER_TABLE
133: , a17 JTF_VARCHAR2_TABLE_100
134: );

Line 131: , a15 JTF_VARCHAR2_TABLE_100

127: , a11 JTF_NUMBER_TABLE
128: , a12 JTF_NUMBER_TABLE
129: , a13 JTF_NUMBER_TABLE
130: , a14 JTF_VARCHAR2_TABLE_100
131: , a15 JTF_VARCHAR2_TABLE_100
132: , a16 JTF_NUMBER_TABLE
133: , a17 JTF_VARCHAR2_TABLE_100
134: );
135: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 133: , a17 JTF_VARCHAR2_TABLE_100

129: , a13 JTF_NUMBER_TABLE
130: , a14 JTF_VARCHAR2_TABLE_100
131: , a15 JTF_VARCHAR2_TABLE_100
132: , a16 JTF_NUMBER_TABLE
133: , a17 JTF_VARCHAR2_TABLE_100
134: );
135: procedure rosetta_table_copy_out_p9(t csd_hv_wip_job_pvt.op_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
136: , a1 out nocopy JTF_NUMBER_TABLE
137: , a2 out nocopy JTF_NUMBER_TABLE

Line 149: , a14 out nocopy JTF_VARCHAR2_TABLE_100

145: , a10 out nocopy JTF_NUMBER_TABLE
146: , a11 out nocopy JTF_NUMBER_TABLE
147: , a12 out nocopy JTF_NUMBER_TABLE
148: , a13 out nocopy JTF_NUMBER_TABLE
149: , a14 out nocopy JTF_VARCHAR2_TABLE_100
150: , a15 out nocopy JTF_VARCHAR2_TABLE_100
151: , a16 out nocopy JTF_NUMBER_TABLE
152: , a17 out nocopy JTF_VARCHAR2_TABLE_100
153: );

Line 150: , a15 out nocopy JTF_VARCHAR2_TABLE_100

146: , a11 out nocopy JTF_NUMBER_TABLE
147: , a12 out nocopy JTF_NUMBER_TABLE
148: , a13 out nocopy JTF_NUMBER_TABLE
149: , a14 out nocopy JTF_VARCHAR2_TABLE_100
150: , a15 out nocopy JTF_VARCHAR2_TABLE_100
151: , a16 out nocopy JTF_NUMBER_TABLE
152: , a17 out nocopy JTF_VARCHAR2_TABLE_100
153: );
154:

Line 152: , a17 out nocopy JTF_VARCHAR2_TABLE_100

148: , a13 out nocopy JTF_NUMBER_TABLE
149: , a14 out nocopy JTF_VARCHAR2_TABLE_100
150: , a15 out nocopy JTF_VARCHAR2_TABLE_100
151: , a16 out nocopy JTF_NUMBER_TABLE
152: , a17 out nocopy JTF_VARCHAR2_TABLE_100
153: );
154:
155: procedure rosetta_table_copy_in_p11(t out nocopy csd_hv_wip_job_pvt.service_code_tbl_type, a0 JTF_NUMBER_TABLE
156: , a1 JTF_NUMBER_TABLE

Line 178: , p7_a5 JTF_VARCHAR2_TABLE_100

174: , p7_a1 JTF_NUMBER_TABLE
175: , p7_a2 JTF_NUMBER_TABLE
176: , p7_a3 JTF_NUMBER_TABLE
177: , p7_a4 JTF_NUMBER_TABLE
178: , p7_a5 JTF_VARCHAR2_TABLE_100
179: , p7_a6 JTF_NUMBER_TABLE
180: );
181: procedure process_job_comp_txn(p_api_version_number NUMBER
182: , p_init_msg_list VARCHAR2

Line 237: , p7_a10 JTF_VARCHAR2_TABLE_100

233: , p7_a6 JTF_NUMBER_TABLE
234: , p7_a7 JTF_NUMBER_TABLE
235: , p7_a8 JTF_NUMBER_TABLE
236: , p7_a9 JTF_NUMBER_TABLE
237: , p7_a10 JTF_VARCHAR2_TABLE_100
238: , p7_a11 JTF_VARCHAR2_TABLE_100
239: , p7_a12 JTF_VARCHAR2_TABLE_100
240: , p7_a13 JTF_VARCHAR2_TABLE_100
241: , p7_a14 JTF_VARCHAR2_TABLE_100

Line 238: , p7_a11 JTF_VARCHAR2_TABLE_100

234: , p7_a7 JTF_NUMBER_TABLE
235: , p7_a8 JTF_NUMBER_TABLE
236: , p7_a9 JTF_NUMBER_TABLE
237: , p7_a10 JTF_VARCHAR2_TABLE_100
238: , p7_a11 JTF_VARCHAR2_TABLE_100
239: , p7_a12 JTF_VARCHAR2_TABLE_100
240: , p7_a13 JTF_VARCHAR2_TABLE_100
241: , p7_a14 JTF_VARCHAR2_TABLE_100
242: , p7_a15 JTF_NUMBER_TABLE

Line 239: , p7_a12 JTF_VARCHAR2_TABLE_100

235: , p7_a8 JTF_NUMBER_TABLE
236: , p7_a9 JTF_NUMBER_TABLE
237: , p7_a10 JTF_VARCHAR2_TABLE_100
238: , p7_a11 JTF_VARCHAR2_TABLE_100
239: , p7_a12 JTF_VARCHAR2_TABLE_100
240: , p7_a13 JTF_VARCHAR2_TABLE_100
241: , p7_a14 JTF_VARCHAR2_TABLE_100
242: , p7_a15 JTF_NUMBER_TABLE
243: , p7_a16 JTF_NUMBER_TABLE

Line 240: , p7_a13 JTF_VARCHAR2_TABLE_100

236: , p7_a9 JTF_NUMBER_TABLE
237: , p7_a10 JTF_VARCHAR2_TABLE_100
238: , p7_a11 JTF_VARCHAR2_TABLE_100
239: , p7_a12 JTF_VARCHAR2_TABLE_100
240: , p7_a13 JTF_VARCHAR2_TABLE_100
241: , p7_a14 JTF_VARCHAR2_TABLE_100
242: , p7_a15 JTF_NUMBER_TABLE
243: , p7_a16 JTF_NUMBER_TABLE
244: , p7_a17 JTF_NUMBER_TABLE

Line 241: , p7_a14 JTF_VARCHAR2_TABLE_100

237: , p7_a10 JTF_VARCHAR2_TABLE_100
238: , p7_a11 JTF_VARCHAR2_TABLE_100
239: , p7_a12 JTF_VARCHAR2_TABLE_100
240: , p7_a13 JTF_VARCHAR2_TABLE_100
241: , p7_a14 JTF_VARCHAR2_TABLE_100
242: , p7_a15 JTF_NUMBER_TABLE
243: , p7_a16 JTF_NUMBER_TABLE
244: , p7_a17 JTF_NUMBER_TABLE
245: , p7_a18 JTF_VARCHAR2_TABLE_100

Line 245: , p7_a18 JTF_VARCHAR2_TABLE_100

241: , p7_a14 JTF_VARCHAR2_TABLE_100
242: , p7_a15 JTF_NUMBER_TABLE
243: , p7_a16 JTF_NUMBER_TABLE
244: , p7_a17 JTF_NUMBER_TABLE
245: , p7_a18 JTF_VARCHAR2_TABLE_100
246: , p7_a19 JTF_NUMBER_TABLE
247: , p7_a20 JTF_NUMBER_TABLE
248: , p7_a21 JTF_NUMBER_TABLE
249: , p7_a22 JTF_VARCHAR2_TABLE_100

Line 249: , p7_a22 JTF_VARCHAR2_TABLE_100

245: , p7_a18 JTF_VARCHAR2_TABLE_100
246: , p7_a19 JTF_NUMBER_TABLE
247: , p7_a20 JTF_NUMBER_TABLE
248: , p7_a21 JTF_NUMBER_TABLE
249: , p7_a22 JTF_VARCHAR2_TABLE_100
250: , p7_a23 JTF_NUMBER_TABLE
251: , x_transaction_header_id out nocopy NUMBER
252: );
253: procedure process_issue_mtl_txns_lot_srl(p_api_version_number NUMBER

Line 270: , p7_a10 JTF_VARCHAR2_TABLE_100

266: , p7_a6 JTF_NUMBER_TABLE
267: , p7_a7 JTF_NUMBER_TABLE
268: , p7_a8 JTF_NUMBER_TABLE
269: , p7_a9 JTF_NUMBER_TABLE
270: , p7_a10 JTF_VARCHAR2_TABLE_100
271: , p7_a11 JTF_VARCHAR2_TABLE_100
272: , p7_a12 JTF_VARCHAR2_TABLE_100
273: , p7_a13 JTF_VARCHAR2_TABLE_100
274: , p7_a14 JTF_VARCHAR2_TABLE_100

Line 271: , p7_a11 JTF_VARCHAR2_TABLE_100

267: , p7_a7 JTF_NUMBER_TABLE
268: , p7_a8 JTF_NUMBER_TABLE
269: , p7_a9 JTF_NUMBER_TABLE
270: , p7_a10 JTF_VARCHAR2_TABLE_100
271: , p7_a11 JTF_VARCHAR2_TABLE_100
272: , p7_a12 JTF_VARCHAR2_TABLE_100
273: , p7_a13 JTF_VARCHAR2_TABLE_100
274: , p7_a14 JTF_VARCHAR2_TABLE_100
275: , p7_a15 JTF_NUMBER_TABLE

Line 272: , p7_a12 JTF_VARCHAR2_TABLE_100

268: , p7_a8 JTF_NUMBER_TABLE
269: , p7_a9 JTF_NUMBER_TABLE
270: , p7_a10 JTF_VARCHAR2_TABLE_100
271: , p7_a11 JTF_VARCHAR2_TABLE_100
272: , p7_a12 JTF_VARCHAR2_TABLE_100
273: , p7_a13 JTF_VARCHAR2_TABLE_100
274: , p7_a14 JTF_VARCHAR2_TABLE_100
275: , p7_a15 JTF_NUMBER_TABLE
276: , p7_a16 JTF_NUMBER_TABLE

Line 273: , p7_a13 JTF_VARCHAR2_TABLE_100

269: , p7_a9 JTF_NUMBER_TABLE
270: , p7_a10 JTF_VARCHAR2_TABLE_100
271: , p7_a11 JTF_VARCHAR2_TABLE_100
272: , p7_a12 JTF_VARCHAR2_TABLE_100
273: , p7_a13 JTF_VARCHAR2_TABLE_100
274: , p7_a14 JTF_VARCHAR2_TABLE_100
275: , p7_a15 JTF_NUMBER_TABLE
276: , p7_a16 JTF_NUMBER_TABLE
277: , p7_a17 JTF_NUMBER_TABLE

Line 274: , p7_a14 JTF_VARCHAR2_TABLE_100

270: , p7_a10 JTF_VARCHAR2_TABLE_100
271: , p7_a11 JTF_VARCHAR2_TABLE_100
272: , p7_a12 JTF_VARCHAR2_TABLE_100
273: , p7_a13 JTF_VARCHAR2_TABLE_100
274: , p7_a14 JTF_VARCHAR2_TABLE_100
275: , p7_a15 JTF_NUMBER_TABLE
276: , p7_a16 JTF_NUMBER_TABLE
277: , p7_a17 JTF_NUMBER_TABLE
278: , p7_a18 JTF_VARCHAR2_TABLE_100

Line 278: , p7_a18 JTF_VARCHAR2_TABLE_100

274: , p7_a14 JTF_VARCHAR2_TABLE_100
275: , p7_a15 JTF_NUMBER_TABLE
276: , p7_a16 JTF_NUMBER_TABLE
277: , p7_a17 JTF_NUMBER_TABLE
278: , p7_a18 JTF_VARCHAR2_TABLE_100
279: , p7_a19 JTF_NUMBER_TABLE
280: , p7_a20 JTF_NUMBER_TABLE
281: , p7_a21 JTF_NUMBER_TABLE
282: , p7_a22 JTF_VARCHAR2_TABLE_100

Line 282: , p7_a22 JTF_VARCHAR2_TABLE_100

278: , p7_a18 JTF_VARCHAR2_TABLE_100
279: , p7_a19 JTF_NUMBER_TABLE
280: , p7_a20 JTF_NUMBER_TABLE
281: , p7_a21 JTF_NUMBER_TABLE
282: , p7_a22 JTF_VARCHAR2_TABLE_100
283: , p7_a23 JTF_NUMBER_TABLE
284: , p_transaction_header_id NUMBER
285: );
286: procedure update_mtl_txns_lot_srl(p_api_version_number NUMBER

Line 303: , p7_a10 JTF_VARCHAR2_TABLE_100

299: , p7_a6 JTF_NUMBER_TABLE
300: , p7_a7 JTF_NUMBER_TABLE
301: , p7_a8 JTF_NUMBER_TABLE
302: , p7_a9 JTF_NUMBER_TABLE
303: , p7_a10 JTF_VARCHAR2_TABLE_100
304: , p7_a11 JTF_VARCHAR2_TABLE_100
305: , p7_a12 JTF_VARCHAR2_TABLE_100
306: , p7_a13 JTF_VARCHAR2_TABLE_100
307: , p7_a14 JTF_VARCHAR2_TABLE_100

Line 304: , p7_a11 JTF_VARCHAR2_TABLE_100

300: , p7_a7 JTF_NUMBER_TABLE
301: , p7_a8 JTF_NUMBER_TABLE
302: , p7_a9 JTF_NUMBER_TABLE
303: , p7_a10 JTF_VARCHAR2_TABLE_100
304: , p7_a11 JTF_VARCHAR2_TABLE_100
305: , p7_a12 JTF_VARCHAR2_TABLE_100
306: , p7_a13 JTF_VARCHAR2_TABLE_100
307: , p7_a14 JTF_VARCHAR2_TABLE_100
308: , p7_a15 JTF_NUMBER_TABLE

Line 305: , p7_a12 JTF_VARCHAR2_TABLE_100

301: , p7_a8 JTF_NUMBER_TABLE
302: , p7_a9 JTF_NUMBER_TABLE
303: , p7_a10 JTF_VARCHAR2_TABLE_100
304: , p7_a11 JTF_VARCHAR2_TABLE_100
305: , p7_a12 JTF_VARCHAR2_TABLE_100
306: , p7_a13 JTF_VARCHAR2_TABLE_100
307: , p7_a14 JTF_VARCHAR2_TABLE_100
308: , p7_a15 JTF_NUMBER_TABLE
309: , p7_a16 JTF_NUMBER_TABLE

Line 306: , p7_a13 JTF_VARCHAR2_TABLE_100

302: , p7_a9 JTF_NUMBER_TABLE
303: , p7_a10 JTF_VARCHAR2_TABLE_100
304: , p7_a11 JTF_VARCHAR2_TABLE_100
305: , p7_a12 JTF_VARCHAR2_TABLE_100
306: , p7_a13 JTF_VARCHAR2_TABLE_100
307: , p7_a14 JTF_VARCHAR2_TABLE_100
308: , p7_a15 JTF_NUMBER_TABLE
309: , p7_a16 JTF_NUMBER_TABLE
310: , p7_a17 JTF_NUMBER_TABLE

Line 307: , p7_a14 JTF_VARCHAR2_TABLE_100

303: , p7_a10 JTF_VARCHAR2_TABLE_100
304: , p7_a11 JTF_VARCHAR2_TABLE_100
305: , p7_a12 JTF_VARCHAR2_TABLE_100
306: , p7_a13 JTF_VARCHAR2_TABLE_100
307: , p7_a14 JTF_VARCHAR2_TABLE_100
308: , p7_a15 JTF_NUMBER_TABLE
309: , p7_a16 JTF_NUMBER_TABLE
310: , p7_a17 JTF_NUMBER_TABLE
311: , p7_a18 JTF_VARCHAR2_TABLE_100

Line 311: , p7_a18 JTF_VARCHAR2_TABLE_100

307: , p7_a14 JTF_VARCHAR2_TABLE_100
308: , p7_a15 JTF_NUMBER_TABLE
309: , p7_a16 JTF_NUMBER_TABLE
310: , p7_a17 JTF_NUMBER_TABLE
311: , p7_a18 JTF_VARCHAR2_TABLE_100
312: , p7_a19 JTF_NUMBER_TABLE
313: , p7_a20 JTF_NUMBER_TABLE
314: , p7_a21 JTF_NUMBER_TABLE
315: , p7_a22 JTF_VARCHAR2_TABLE_100

Line 315: , p7_a22 JTF_VARCHAR2_TABLE_100

311: , p7_a18 JTF_VARCHAR2_TABLE_100
312: , p7_a19 JTF_NUMBER_TABLE
313: , p7_a20 JTF_NUMBER_TABLE
314: , p7_a21 JTF_NUMBER_TABLE
315: , p7_a22 JTF_VARCHAR2_TABLE_100
316: , p7_a23 JTF_NUMBER_TABLE
317: , p_transaction_header_id NUMBER
318: );
319: procedure process_transact_res_txn(p_api_version_number NUMBER

Line 337: , p7_a11 JTF_VARCHAR2_TABLE_100

333: , p7_a7 JTF_NUMBER_TABLE
334: , p7_a8 JTF_NUMBER_TABLE
335: , p7_a9 JTF_NUMBER_TABLE
336: , p7_a10 JTF_NUMBER_TABLE
337: , p7_a11 JTF_VARCHAR2_TABLE_100
338: , p7_a12 JTF_NUMBER_TABLE
339: , p7_a13 JTF_NUMBER_TABLE
340: , p7_a14 JTF_VARCHAR2_TABLE_100
341: , p7_a15 JTF_VARCHAR2_TABLE_100

Line 340: , p7_a14 JTF_VARCHAR2_TABLE_100

336: , p7_a10 JTF_NUMBER_TABLE
337: , p7_a11 JTF_VARCHAR2_TABLE_100
338: , p7_a12 JTF_NUMBER_TABLE
339: , p7_a13 JTF_NUMBER_TABLE
340: , p7_a14 JTF_VARCHAR2_TABLE_100
341: , p7_a15 JTF_VARCHAR2_TABLE_100
342: , p7_a16 JTF_VARCHAR2_TABLE_100
343: , p7_a17 JTF_NUMBER_TABLE
344: , p7_a18 JTF_VARCHAR2_TABLE_100

Line 341: , p7_a15 JTF_VARCHAR2_TABLE_100

337: , p7_a11 JTF_VARCHAR2_TABLE_100
338: , p7_a12 JTF_NUMBER_TABLE
339: , p7_a13 JTF_NUMBER_TABLE
340: , p7_a14 JTF_VARCHAR2_TABLE_100
341: , p7_a15 JTF_VARCHAR2_TABLE_100
342: , p7_a16 JTF_VARCHAR2_TABLE_100
343: , p7_a17 JTF_NUMBER_TABLE
344: , p7_a18 JTF_VARCHAR2_TABLE_100
345: , p7_a19 JTF_NUMBER_TABLE

Line 342: , p7_a16 JTF_VARCHAR2_TABLE_100

338: , p7_a12 JTF_NUMBER_TABLE
339: , p7_a13 JTF_NUMBER_TABLE
340: , p7_a14 JTF_VARCHAR2_TABLE_100
341: , p7_a15 JTF_VARCHAR2_TABLE_100
342: , p7_a16 JTF_VARCHAR2_TABLE_100
343: , p7_a17 JTF_NUMBER_TABLE
344: , p7_a18 JTF_VARCHAR2_TABLE_100
345: , p7_a19 JTF_NUMBER_TABLE
346: , p7_a20 JTF_VARCHAR2_TABLE_100

Line 344: , p7_a18 JTF_VARCHAR2_TABLE_100

340: , p7_a14 JTF_VARCHAR2_TABLE_100
341: , p7_a15 JTF_VARCHAR2_TABLE_100
342: , p7_a16 JTF_VARCHAR2_TABLE_100
343: , p7_a17 JTF_NUMBER_TABLE
344: , p7_a18 JTF_VARCHAR2_TABLE_100
345: , p7_a19 JTF_NUMBER_TABLE
346: , p7_a20 JTF_VARCHAR2_TABLE_100
347: );
348: procedure process_save_mtl_txn_dtls(p_api_version_number NUMBER

Line 346: , p7_a20 JTF_VARCHAR2_TABLE_100

342: , p7_a16 JTF_VARCHAR2_TABLE_100
343: , p7_a17 JTF_NUMBER_TABLE
344: , p7_a18 JTF_VARCHAR2_TABLE_100
345: , p7_a19 JTF_NUMBER_TABLE
346: , p7_a20 JTF_VARCHAR2_TABLE_100
347: );
348: procedure process_save_mtl_txn_dtls(p_api_version_number NUMBER
349: , p_init_msg_list VARCHAR2
350: , p_commit VARCHAR2

Line 365: , p7_a10 JTF_VARCHAR2_TABLE_100

361: , p7_a6 JTF_NUMBER_TABLE
362: , p7_a7 JTF_NUMBER_TABLE
363: , p7_a8 JTF_NUMBER_TABLE
364: , p7_a9 JTF_NUMBER_TABLE
365: , p7_a10 JTF_VARCHAR2_TABLE_100
366: , p7_a11 JTF_VARCHAR2_TABLE_100
367: , p7_a12 JTF_VARCHAR2_TABLE_100
368: , p7_a13 JTF_VARCHAR2_TABLE_100
369: , p7_a14 JTF_VARCHAR2_TABLE_100

Line 366: , p7_a11 JTF_VARCHAR2_TABLE_100

362: , p7_a7 JTF_NUMBER_TABLE
363: , p7_a8 JTF_NUMBER_TABLE
364: , p7_a9 JTF_NUMBER_TABLE
365: , p7_a10 JTF_VARCHAR2_TABLE_100
366: , p7_a11 JTF_VARCHAR2_TABLE_100
367: , p7_a12 JTF_VARCHAR2_TABLE_100
368: , p7_a13 JTF_VARCHAR2_TABLE_100
369: , p7_a14 JTF_VARCHAR2_TABLE_100
370: , p7_a15 JTF_NUMBER_TABLE

Line 367: , p7_a12 JTF_VARCHAR2_TABLE_100

363: , p7_a8 JTF_NUMBER_TABLE
364: , p7_a9 JTF_NUMBER_TABLE
365: , p7_a10 JTF_VARCHAR2_TABLE_100
366: , p7_a11 JTF_VARCHAR2_TABLE_100
367: , p7_a12 JTF_VARCHAR2_TABLE_100
368: , p7_a13 JTF_VARCHAR2_TABLE_100
369: , p7_a14 JTF_VARCHAR2_TABLE_100
370: , p7_a15 JTF_NUMBER_TABLE
371: , p7_a16 JTF_NUMBER_TABLE

Line 368: , p7_a13 JTF_VARCHAR2_TABLE_100

364: , p7_a9 JTF_NUMBER_TABLE
365: , p7_a10 JTF_VARCHAR2_TABLE_100
366: , p7_a11 JTF_VARCHAR2_TABLE_100
367: , p7_a12 JTF_VARCHAR2_TABLE_100
368: , p7_a13 JTF_VARCHAR2_TABLE_100
369: , p7_a14 JTF_VARCHAR2_TABLE_100
370: , p7_a15 JTF_NUMBER_TABLE
371: , p7_a16 JTF_NUMBER_TABLE
372: , p7_a17 JTF_NUMBER_TABLE

Line 369: , p7_a14 JTF_VARCHAR2_TABLE_100

365: , p7_a10 JTF_VARCHAR2_TABLE_100
366: , p7_a11 JTF_VARCHAR2_TABLE_100
367: , p7_a12 JTF_VARCHAR2_TABLE_100
368: , p7_a13 JTF_VARCHAR2_TABLE_100
369: , p7_a14 JTF_VARCHAR2_TABLE_100
370: , p7_a15 JTF_NUMBER_TABLE
371: , p7_a16 JTF_NUMBER_TABLE
372: , p7_a17 JTF_NUMBER_TABLE
373: , p7_a18 JTF_VARCHAR2_TABLE_100

Line 373: , p7_a18 JTF_VARCHAR2_TABLE_100

369: , p7_a14 JTF_VARCHAR2_TABLE_100
370: , p7_a15 JTF_NUMBER_TABLE
371: , p7_a16 JTF_NUMBER_TABLE
372: , p7_a17 JTF_NUMBER_TABLE
373: , p7_a18 JTF_VARCHAR2_TABLE_100
374: , p7_a19 JTF_NUMBER_TABLE
375: , p7_a20 JTF_NUMBER_TABLE
376: , p7_a21 JTF_NUMBER_TABLE
377: , p7_a22 JTF_VARCHAR2_TABLE_100

Line 377: , p7_a22 JTF_VARCHAR2_TABLE_100

373: , p7_a18 JTF_VARCHAR2_TABLE_100
374: , p7_a19 JTF_NUMBER_TABLE
375: , p7_a20 JTF_NUMBER_TABLE
376: , p7_a21 JTF_NUMBER_TABLE
377: , p7_a22 JTF_VARCHAR2_TABLE_100
378: , p7_a23 JTF_NUMBER_TABLE
379: , x_op_created out nocopy VARCHAR
380: );
381: procedure process_save_res_txn_dtls(p_api_version_number NUMBER

Line 399: , p7_a11 JTF_VARCHAR2_TABLE_100

395: , p7_a7 JTF_NUMBER_TABLE
396: , p7_a8 JTF_NUMBER_TABLE
397: , p7_a9 JTF_NUMBER_TABLE
398: , p7_a10 JTF_NUMBER_TABLE
399: , p7_a11 JTF_VARCHAR2_TABLE_100
400: , p7_a12 JTF_NUMBER_TABLE
401: , p7_a13 JTF_NUMBER_TABLE
402: , p7_a14 JTF_VARCHAR2_TABLE_100
403: , p7_a15 JTF_VARCHAR2_TABLE_100

Line 402: , p7_a14 JTF_VARCHAR2_TABLE_100

398: , p7_a10 JTF_NUMBER_TABLE
399: , p7_a11 JTF_VARCHAR2_TABLE_100
400: , p7_a12 JTF_NUMBER_TABLE
401: , p7_a13 JTF_NUMBER_TABLE
402: , p7_a14 JTF_VARCHAR2_TABLE_100
403: , p7_a15 JTF_VARCHAR2_TABLE_100
404: , p7_a16 JTF_VARCHAR2_TABLE_100
405: , p7_a17 JTF_NUMBER_TABLE
406: , p7_a18 JTF_VARCHAR2_TABLE_100

Line 403: , p7_a15 JTF_VARCHAR2_TABLE_100

399: , p7_a11 JTF_VARCHAR2_TABLE_100
400: , p7_a12 JTF_NUMBER_TABLE
401: , p7_a13 JTF_NUMBER_TABLE
402: , p7_a14 JTF_VARCHAR2_TABLE_100
403: , p7_a15 JTF_VARCHAR2_TABLE_100
404: , p7_a16 JTF_VARCHAR2_TABLE_100
405: , p7_a17 JTF_NUMBER_TABLE
406: , p7_a18 JTF_VARCHAR2_TABLE_100
407: , p7_a19 JTF_NUMBER_TABLE

Line 404: , p7_a16 JTF_VARCHAR2_TABLE_100

400: , p7_a12 JTF_NUMBER_TABLE
401: , p7_a13 JTF_NUMBER_TABLE
402: , p7_a14 JTF_VARCHAR2_TABLE_100
403: , p7_a15 JTF_VARCHAR2_TABLE_100
404: , p7_a16 JTF_VARCHAR2_TABLE_100
405: , p7_a17 JTF_NUMBER_TABLE
406: , p7_a18 JTF_VARCHAR2_TABLE_100
407: , p7_a19 JTF_NUMBER_TABLE
408: , p7_a20 JTF_VARCHAR2_TABLE_100

Line 406: , p7_a18 JTF_VARCHAR2_TABLE_100

402: , p7_a14 JTF_VARCHAR2_TABLE_100
403: , p7_a15 JTF_VARCHAR2_TABLE_100
404: , p7_a16 JTF_VARCHAR2_TABLE_100
405: , p7_a17 JTF_NUMBER_TABLE
406: , p7_a18 JTF_VARCHAR2_TABLE_100
407: , p7_a19 JTF_NUMBER_TABLE
408: , p7_a20 JTF_VARCHAR2_TABLE_100
409: );
410: procedure process_save_op_dtls(p_api_version_number NUMBER

Line 408: , p7_a20 JTF_VARCHAR2_TABLE_100

404: , p7_a16 JTF_VARCHAR2_TABLE_100
405: , p7_a17 JTF_NUMBER_TABLE
406: , p7_a18 JTF_VARCHAR2_TABLE_100
407: , p7_a19 JTF_NUMBER_TABLE
408: , p7_a20 JTF_VARCHAR2_TABLE_100
409: );
410: procedure process_save_op_dtls(p_api_version_number NUMBER
411: , p_init_msg_list VARCHAR2
412: , p_commit VARCHAR2

Line 431: , p7_a14 JTF_VARCHAR2_TABLE_100

427: , p7_a10 JTF_NUMBER_TABLE
428: , p7_a11 JTF_NUMBER_TABLE
429: , p7_a12 JTF_NUMBER_TABLE
430: , p7_a13 JTF_NUMBER_TABLE
431: , p7_a14 JTF_VARCHAR2_TABLE_100
432: , p7_a15 JTF_VARCHAR2_TABLE_100
433: , p7_a16 JTF_NUMBER_TABLE
434: , p7_a17 JTF_VARCHAR2_TABLE_100
435: );

Line 432: , p7_a15 JTF_VARCHAR2_TABLE_100

428: , p7_a11 JTF_NUMBER_TABLE
429: , p7_a12 JTF_NUMBER_TABLE
430: , p7_a13 JTF_NUMBER_TABLE
431: , p7_a14 JTF_VARCHAR2_TABLE_100
432: , p7_a15 JTF_VARCHAR2_TABLE_100
433: , p7_a16 JTF_NUMBER_TABLE
434: , p7_a17 JTF_VARCHAR2_TABLE_100
435: );
436: procedure generate_wip_jobs_from_scs(p_api_version_number NUMBER

Line 434: , p7_a17 JTF_VARCHAR2_TABLE_100

430: , p7_a13 JTF_NUMBER_TABLE
431: , p7_a14 JTF_VARCHAR2_TABLE_100
432: , p7_a15 JTF_VARCHAR2_TABLE_100
433: , p7_a16 JTF_NUMBER_TABLE
434: , p7_a17 JTF_VARCHAR2_TABLE_100
435: );
436: procedure generate_wip_jobs_from_scs(p_api_version_number NUMBER
437: , p_init_msg_list VARCHAR2
438: , p_commit VARCHAR2