APPS.CN_ADJ_DISP_PUB_W dependencies on JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

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
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_NUMBER_TABLE

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
19: , a16 JTF_VARCHAR2_TABLE_300

Line 16: , a13 JTF_NUMBER_TABLE

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
19: , a16 JTF_VARCHAR2_TABLE_300
20: , a17 JTF_VARCHAR2_TABLE_300

Line 117: , a114 JTF_NUMBER_TABLE

113: , a110 JTF_VARCHAR2_TABLE_300
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

Line 120: , a117 JTF_NUMBER_TABLE

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
124: , a121 JTF_DATE_TABLE

Line 121: , a118 JTF_NUMBER_TABLE

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
124: , a121 JTF_DATE_TABLE
125: , a122 JTF_VARCHAR2_TABLE_1800

Line 122: , a119 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
124: , a121 JTF_DATE_TABLE
125: , a122 JTF_VARCHAR2_TABLE_1800
126: , a123 JTF_VARCHAR2_TABLE_100

Line 123: , a120 JTF_NUMBER_TABLE

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
124: , a121 JTF_DATE_TABLE
125: , a122 JTF_VARCHAR2_TABLE_1800
126: , a123 JTF_VARCHAR2_TABLE_100
127: , a124 JTF_VARCHAR2_TABLE_100

Line 128: , a125 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
132: );

Line 130: , a127 JTF_NUMBER_TABLE

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
134: , a1 out nocopy JTF_DATE_TABLE

Line 135: , a2 out nocopy 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
138: , a5 out nocopy JTF_DATE_TABLE
139: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 145: , a12 out nocopy JTF_NUMBER_TABLE

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
149: , a16 out nocopy JTF_VARCHAR2_TABLE_300

Line 146: , a13 out nocopy JTF_NUMBER_TABLE

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
149: , a16 out nocopy JTF_VARCHAR2_TABLE_300
150: , a17 out nocopy JTF_VARCHAR2_TABLE_300

Line 247: , a114 out nocopy JTF_NUMBER_TABLE

243: , a110 out nocopy JTF_VARCHAR2_TABLE_300
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

Line 250: , a117 out nocopy JTF_NUMBER_TABLE

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
254: , a121 out nocopy JTF_DATE_TABLE

Line 251: , a118 out nocopy JTF_NUMBER_TABLE

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
254: , a121 out nocopy JTF_DATE_TABLE
255: , a122 out nocopy JTF_VARCHAR2_TABLE_1800

Line 252: , a119 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
254: , a121 out nocopy JTF_DATE_TABLE
255: , a122 out nocopy JTF_VARCHAR2_TABLE_1800
256: , a123 out nocopy JTF_VARCHAR2_TABLE_100

Line 253: , a120 out nocopy JTF_NUMBER_TABLE

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
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

Line 258: , a125 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
262: );

Line 260: , a127 out nocopy JTF_NUMBER_TABLE

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:
264: procedure get_adj(p_api_version NUMBER

Line 286: , p20_a2 out nocopy JTF_NUMBER_TABLE

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
289: , p20_a5 out nocopy JTF_DATE_TABLE
290: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 296: , p20_a12 out nocopy JTF_NUMBER_TABLE

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
300: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_300

Line 297: , p20_a13 out nocopy JTF_NUMBER_TABLE

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
300: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_300
301: , p20_a17 out nocopy JTF_VARCHAR2_TABLE_300

Line 398: , p20_a114 out nocopy JTF_NUMBER_TABLE

394: , p20_a110 out nocopy JTF_VARCHAR2_TABLE_300
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

Line 401: , p20_a117 out nocopy JTF_NUMBER_TABLE

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
405: , p20_a121 out nocopy JTF_DATE_TABLE

Line 402: , p20_a118 out nocopy JTF_NUMBER_TABLE

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
405: , p20_a121 out nocopy JTF_DATE_TABLE
406: , p20_a122 out nocopy JTF_VARCHAR2_TABLE_1800

Line 403: , p20_a119 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
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

Line 404: , p20_a120 out nocopy JTF_NUMBER_TABLE

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
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

Line 409: , p20_a125 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
413: , x_adj_count out nocopy NUMBER

Line 411: , p20_a127 out nocopy JTF_NUMBER_TABLE

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
415: , x_total_commission out nocopy NUMBER