APPS.CN_ADJ_DISP_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_adj_disp_pub.adj_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package cn_adj_disp_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwadjs.pls 115.9 2002/11/25 23:27:07 mblum ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_adj_disp_pub.adj_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_300

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_300
18: , a15 JTF_VARCHAR2_TABLE_300

Line 118: , a115 JTF_VARCHAR2_TABLE_100

114: , a111 JTF_VARCHAR2_TABLE_300
115: , a112 JTF_VARCHAR2_TABLE_300
116: , a113 JTF_VARCHAR2_TABLE_300
117: , a114 JTF_NUMBER_TABLE
118: , a115 JTF_VARCHAR2_TABLE_100
119: , a116 JTF_VARCHAR2_TABLE_100
120: , a117 JTF_NUMBER_TABLE
121: , a118 JTF_NUMBER_TABLE
122: , a119 JTF_NUMBER_TABLE

Line 119: , a116 JTF_VARCHAR2_TABLE_100

115: , a112 JTF_VARCHAR2_TABLE_300
116: , a113 JTF_VARCHAR2_TABLE_300
117: , a114 JTF_NUMBER_TABLE
118: , a115 JTF_VARCHAR2_TABLE_100
119: , a116 JTF_VARCHAR2_TABLE_100
120: , a117 JTF_NUMBER_TABLE
121: , a118 JTF_NUMBER_TABLE
122: , a119 JTF_NUMBER_TABLE
123: , a120 JTF_NUMBER_TABLE

Line 126: , a123 JTF_VARCHAR2_TABLE_100

122: , a119 JTF_NUMBER_TABLE
123: , a120 JTF_NUMBER_TABLE
124: , a121 JTF_DATE_TABLE
125: , a122 JTF_VARCHAR2_TABLE_1800
126: , a123 JTF_VARCHAR2_TABLE_100
127: , a124 JTF_VARCHAR2_TABLE_100
128: , a125 JTF_NUMBER_TABLE
129: , a126 JTF_VARCHAR2_TABLE_100
130: , a127 JTF_NUMBER_TABLE

Line 127: , a124 JTF_VARCHAR2_TABLE_100

123: , a120 JTF_NUMBER_TABLE
124: , a121 JTF_DATE_TABLE
125: , a122 JTF_VARCHAR2_TABLE_1800
126: , a123 JTF_VARCHAR2_TABLE_100
127: , a124 JTF_VARCHAR2_TABLE_100
128: , a125 JTF_NUMBER_TABLE
129: , a126 JTF_VARCHAR2_TABLE_100
130: , a127 JTF_NUMBER_TABLE
131: , a128 JTF_VARCHAR2_TABLE_100

Line 129: , a126 JTF_VARCHAR2_TABLE_100

125: , a122 JTF_VARCHAR2_TABLE_1800
126: , a123 JTF_VARCHAR2_TABLE_100
127: , a124 JTF_VARCHAR2_TABLE_100
128: , a125 JTF_NUMBER_TABLE
129: , a126 JTF_VARCHAR2_TABLE_100
130: , a127 JTF_NUMBER_TABLE
131: , a128 JTF_VARCHAR2_TABLE_100
132: );
133: procedure rosetta_table_copy_out_p1(t cn_adj_disp_pub.adj_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , a128 JTF_VARCHAR2_TABLE_100

127: , a124 JTF_VARCHAR2_TABLE_100
128: , a125 JTF_NUMBER_TABLE
129: , a126 JTF_VARCHAR2_TABLE_100
130: , a127 JTF_NUMBER_TABLE
131: , a128 JTF_VARCHAR2_TABLE_100
132: );
133: procedure rosetta_table_copy_out_p1(t cn_adj_disp_pub.adj_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
134: , a1 out nocopy JTF_DATE_TABLE
135: , a2 out nocopy JTF_NUMBER_TABLE

Line 133: procedure rosetta_table_copy_out_p1(t cn_adj_disp_pub.adj_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

129: , a126 JTF_VARCHAR2_TABLE_100
130: , a127 JTF_NUMBER_TABLE
131: , a128 JTF_VARCHAR2_TABLE_100
132: );
133: procedure rosetta_table_copy_out_p1(t cn_adj_disp_pub.adj_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
134: , a1 out nocopy JTF_DATE_TABLE
135: , a2 out nocopy JTF_NUMBER_TABLE
136: , a3 out nocopy JTF_DATE_TABLE
137: , a4 out nocopy JTF_DATE_TABLE

Line 139: , a6 out nocopy JTF_VARCHAR2_TABLE_100

135: , a2 out nocopy JTF_NUMBER_TABLE
136: , a3 out nocopy JTF_DATE_TABLE
137: , a4 out nocopy JTF_DATE_TABLE
138: , a5 out nocopy JTF_DATE_TABLE
139: , a6 out nocopy JTF_VARCHAR2_TABLE_100
140: , a7 out nocopy JTF_VARCHAR2_TABLE_100
141: , a8 out nocopy JTF_VARCHAR2_TABLE_100
142: , a9 out nocopy JTF_DATE_TABLE
143: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: , a7 out nocopy JTF_VARCHAR2_TABLE_100

136: , a3 out nocopy JTF_DATE_TABLE
137: , a4 out nocopy JTF_DATE_TABLE
138: , a5 out nocopy JTF_DATE_TABLE
139: , a6 out nocopy JTF_VARCHAR2_TABLE_100
140: , a7 out nocopy JTF_VARCHAR2_TABLE_100
141: , a8 out nocopy JTF_VARCHAR2_TABLE_100
142: , a9 out nocopy JTF_DATE_TABLE
143: , a10 out nocopy JTF_VARCHAR2_TABLE_100
144: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 141: , a8 out nocopy JTF_VARCHAR2_TABLE_100

137: , a4 out nocopy JTF_DATE_TABLE
138: , a5 out nocopy JTF_DATE_TABLE
139: , a6 out nocopy JTF_VARCHAR2_TABLE_100
140: , a7 out nocopy JTF_VARCHAR2_TABLE_100
141: , a8 out nocopy JTF_VARCHAR2_TABLE_100
142: , a9 out nocopy JTF_DATE_TABLE
143: , a10 out nocopy JTF_VARCHAR2_TABLE_100
144: , a11 out nocopy JTF_VARCHAR2_TABLE_100
145: , a12 out nocopy JTF_NUMBER_TABLE

Line 143: , a10 out nocopy JTF_VARCHAR2_TABLE_100

139: , a6 out nocopy JTF_VARCHAR2_TABLE_100
140: , a7 out nocopy JTF_VARCHAR2_TABLE_100
141: , a8 out nocopy JTF_VARCHAR2_TABLE_100
142: , a9 out nocopy JTF_DATE_TABLE
143: , a10 out nocopy JTF_VARCHAR2_TABLE_100
144: , a11 out nocopy JTF_VARCHAR2_TABLE_100
145: , a12 out nocopy JTF_NUMBER_TABLE
146: , a13 out nocopy JTF_NUMBER_TABLE
147: , a14 out nocopy JTF_VARCHAR2_TABLE_300

Line 144: , a11 out nocopy JTF_VARCHAR2_TABLE_100

140: , a7 out nocopy JTF_VARCHAR2_TABLE_100
141: , a8 out nocopy JTF_VARCHAR2_TABLE_100
142: , a9 out nocopy JTF_DATE_TABLE
143: , a10 out nocopy JTF_VARCHAR2_TABLE_100
144: , a11 out nocopy JTF_VARCHAR2_TABLE_100
145: , a12 out nocopy JTF_NUMBER_TABLE
146: , a13 out nocopy JTF_NUMBER_TABLE
147: , a14 out nocopy JTF_VARCHAR2_TABLE_300
148: , a15 out nocopy JTF_VARCHAR2_TABLE_300

Line 248: , a115 out nocopy JTF_VARCHAR2_TABLE_100

244: , a111 out nocopy JTF_VARCHAR2_TABLE_300
245: , a112 out nocopy JTF_VARCHAR2_TABLE_300
246: , a113 out nocopy JTF_VARCHAR2_TABLE_300
247: , a114 out nocopy JTF_NUMBER_TABLE
248: , a115 out nocopy JTF_VARCHAR2_TABLE_100
249: , a116 out nocopy JTF_VARCHAR2_TABLE_100
250: , a117 out nocopy JTF_NUMBER_TABLE
251: , a118 out nocopy JTF_NUMBER_TABLE
252: , a119 out nocopy JTF_NUMBER_TABLE

Line 249: , a116 out nocopy JTF_VARCHAR2_TABLE_100

245: , a112 out nocopy JTF_VARCHAR2_TABLE_300
246: , a113 out nocopy JTF_VARCHAR2_TABLE_300
247: , a114 out nocopy JTF_NUMBER_TABLE
248: , a115 out nocopy JTF_VARCHAR2_TABLE_100
249: , a116 out nocopy JTF_VARCHAR2_TABLE_100
250: , a117 out nocopy JTF_NUMBER_TABLE
251: , a118 out nocopy JTF_NUMBER_TABLE
252: , a119 out nocopy JTF_NUMBER_TABLE
253: , a120 out nocopy JTF_NUMBER_TABLE

Line 256: , a123 out nocopy JTF_VARCHAR2_TABLE_100

252: , a119 out nocopy JTF_NUMBER_TABLE
253: , a120 out nocopy JTF_NUMBER_TABLE
254: , a121 out nocopy JTF_DATE_TABLE
255: , a122 out nocopy JTF_VARCHAR2_TABLE_1800
256: , a123 out nocopy JTF_VARCHAR2_TABLE_100
257: , a124 out nocopy JTF_VARCHAR2_TABLE_100
258: , a125 out nocopy JTF_NUMBER_TABLE
259: , a126 out nocopy JTF_VARCHAR2_TABLE_100
260: , a127 out nocopy JTF_NUMBER_TABLE

Line 257: , a124 out nocopy JTF_VARCHAR2_TABLE_100

253: , a120 out nocopy JTF_NUMBER_TABLE
254: , a121 out nocopy JTF_DATE_TABLE
255: , a122 out nocopy JTF_VARCHAR2_TABLE_1800
256: , a123 out nocopy JTF_VARCHAR2_TABLE_100
257: , a124 out nocopy JTF_VARCHAR2_TABLE_100
258: , a125 out nocopy JTF_NUMBER_TABLE
259: , a126 out nocopy JTF_VARCHAR2_TABLE_100
260: , a127 out nocopy JTF_NUMBER_TABLE
261: , a128 out nocopy JTF_VARCHAR2_TABLE_100

Line 259: , a126 out nocopy JTF_VARCHAR2_TABLE_100

255: , a122 out nocopy JTF_VARCHAR2_TABLE_1800
256: , a123 out nocopy JTF_VARCHAR2_TABLE_100
257: , a124 out nocopy JTF_VARCHAR2_TABLE_100
258: , a125 out nocopy JTF_NUMBER_TABLE
259: , a126 out nocopy JTF_VARCHAR2_TABLE_100
260: , a127 out nocopy JTF_NUMBER_TABLE
261: , a128 out nocopy JTF_VARCHAR2_TABLE_100
262: );
263:

Line 261: , a128 out nocopy JTF_VARCHAR2_TABLE_100

257: , a124 out nocopy JTF_VARCHAR2_TABLE_100
258: , a125 out nocopy JTF_NUMBER_TABLE
259: , a126 out nocopy JTF_VARCHAR2_TABLE_100
260: , a127 out nocopy JTF_NUMBER_TABLE
261: , a128 out nocopy JTF_VARCHAR2_TABLE_100
262: );
263:
264: procedure get_adj(p_api_version NUMBER
265: , p_init_msg_list VARCHAR2

Line 284: , p20_a0 out nocopy JTF_VARCHAR2_TABLE_100

280: , p_date_pattern date
281: , p_start_record NUMBER
282: , p_increment_count NUMBER
283: , p_curr_code VARCHAR2
284: , p20_a0 out nocopy JTF_VARCHAR2_TABLE_100
285: , p20_a1 out nocopy JTF_DATE_TABLE
286: , p20_a2 out nocopy JTF_NUMBER_TABLE
287: , p20_a3 out nocopy JTF_DATE_TABLE
288: , p20_a4 out nocopy JTF_DATE_TABLE

Line 290: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100

286: , p20_a2 out nocopy JTF_NUMBER_TABLE
287: , p20_a3 out nocopy JTF_DATE_TABLE
288: , p20_a4 out nocopy JTF_DATE_TABLE
289: , p20_a5 out nocopy JTF_DATE_TABLE
290: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100
291: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
292: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
293: , p20_a9 out nocopy JTF_DATE_TABLE
294: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 291: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100

287: , p20_a3 out nocopy JTF_DATE_TABLE
288: , p20_a4 out nocopy JTF_DATE_TABLE
289: , p20_a5 out nocopy JTF_DATE_TABLE
290: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100
291: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
292: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
293: , p20_a9 out nocopy JTF_DATE_TABLE
294: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100
295: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 292: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100

288: , p20_a4 out nocopy JTF_DATE_TABLE
289: , p20_a5 out nocopy JTF_DATE_TABLE
290: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100
291: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
292: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
293: , p20_a9 out nocopy JTF_DATE_TABLE
294: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100
295: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
296: , p20_a12 out nocopy JTF_NUMBER_TABLE

Line 294: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100

290: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100
291: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
292: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
293: , p20_a9 out nocopy JTF_DATE_TABLE
294: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100
295: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
296: , p20_a12 out nocopy JTF_NUMBER_TABLE
297: , p20_a13 out nocopy JTF_NUMBER_TABLE
298: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_300

Line 295: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100

291: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
292: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
293: , p20_a9 out nocopy JTF_DATE_TABLE
294: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100
295: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
296: , p20_a12 out nocopy JTF_NUMBER_TABLE
297: , p20_a13 out nocopy JTF_NUMBER_TABLE
298: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_300
299: , p20_a15 out nocopy JTF_VARCHAR2_TABLE_300

Line 399: , p20_a115 out nocopy JTF_VARCHAR2_TABLE_100

395: , p20_a111 out nocopy JTF_VARCHAR2_TABLE_300
396: , p20_a112 out nocopy JTF_VARCHAR2_TABLE_300
397: , p20_a113 out nocopy JTF_VARCHAR2_TABLE_300
398: , p20_a114 out nocopy JTF_NUMBER_TABLE
399: , p20_a115 out nocopy JTF_VARCHAR2_TABLE_100
400: , p20_a116 out nocopy JTF_VARCHAR2_TABLE_100
401: , p20_a117 out nocopy JTF_NUMBER_TABLE
402: , p20_a118 out nocopy JTF_NUMBER_TABLE
403: , p20_a119 out nocopy JTF_NUMBER_TABLE

Line 400: , p20_a116 out nocopy JTF_VARCHAR2_TABLE_100

396: , p20_a112 out nocopy JTF_VARCHAR2_TABLE_300
397: , p20_a113 out nocopy JTF_VARCHAR2_TABLE_300
398: , p20_a114 out nocopy JTF_NUMBER_TABLE
399: , p20_a115 out nocopy JTF_VARCHAR2_TABLE_100
400: , p20_a116 out nocopy JTF_VARCHAR2_TABLE_100
401: , p20_a117 out nocopy JTF_NUMBER_TABLE
402: , p20_a118 out nocopy JTF_NUMBER_TABLE
403: , p20_a119 out nocopy JTF_NUMBER_TABLE
404: , p20_a120 out nocopy JTF_NUMBER_TABLE

Line 407: , p20_a123 out nocopy JTF_VARCHAR2_TABLE_100

403: , p20_a119 out nocopy JTF_NUMBER_TABLE
404: , p20_a120 out nocopy JTF_NUMBER_TABLE
405: , p20_a121 out nocopy JTF_DATE_TABLE
406: , p20_a122 out nocopy JTF_VARCHAR2_TABLE_1800
407: , p20_a123 out nocopy JTF_VARCHAR2_TABLE_100
408: , p20_a124 out nocopy JTF_VARCHAR2_TABLE_100
409: , p20_a125 out nocopy JTF_NUMBER_TABLE
410: , p20_a126 out nocopy JTF_VARCHAR2_TABLE_100
411: , p20_a127 out nocopy JTF_NUMBER_TABLE

Line 408: , p20_a124 out nocopy JTF_VARCHAR2_TABLE_100

404: , p20_a120 out nocopy JTF_NUMBER_TABLE
405: , p20_a121 out nocopy JTF_DATE_TABLE
406: , p20_a122 out nocopy JTF_VARCHAR2_TABLE_1800
407: , p20_a123 out nocopy JTF_VARCHAR2_TABLE_100
408: , p20_a124 out nocopy JTF_VARCHAR2_TABLE_100
409: , p20_a125 out nocopy JTF_NUMBER_TABLE
410: , p20_a126 out nocopy JTF_VARCHAR2_TABLE_100
411: , p20_a127 out nocopy JTF_NUMBER_TABLE
412: , p20_a128 out nocopy JTF_VARCHAR2_TABLE_100

Line 410: , p20_a126 out nocopy JTF_VARCHAR2_TABLE_100

406: , p20_a122 out nocopy JTF_VARCHAR2_TABLE_1800
407: , p20_a123 out nocopy JTF_VARCHAR2_TABLE_100
408: , p20_a124 out nocopy JTF_VARCHAR2_TABLE_100
409: , p20_a125 out nocopy JTF_NUMBER_TABLE
410: , p20_a126 out nocopy JTF_VARCHAR2_TABLE_100
411: , p20_a127 out nocopy JTF_NUMBER_TABLE
412: , p20_a128 out nocopy JTF_VARCHAR2_TABLE_100
413: , x_adj_count out nocopy NUMBER
414: , x_total_sales_credit out nocopy NUMBER

Line 412: , p20_a128 out nocopy JTF_VARCHAR2_TABLE_100

408: , p20_a124 out nocopy JTF_VARCHAR2_TABLE_100
409: , p20_a125 out nocopy JTF_NUMBER_TABLE
410: , p20_a126 out nocopy JTF_VARCHAR2_TABLE_100
411: , p20_a127 out nocopy JTF_NUMBER_TABLE
412: , p20_a128 out nocopy JTF_VARCHAR2_TABLE_100
413: , x_adj_count out nocopy NUMBER
414: , x_total_sales_credit out nocopy NUMBER
415: , x_total_commission out nocopy NUMBER
416: , x_conv_status out nocopy VARCHAR2