APPS.AHL_PP_MATERIALS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWPPMS.pls 120.2 2008/01/31 09:07:56 bachandr ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pp_materials_pvt.req_material_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_300
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE

Line 21: , a18 JTF_VARCHAR2_TABLE_100

17: , a14 JTF_VARCHAR2_TABLE_300
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_DATE_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE

Line 30: , a27 JTF_VARCHAR2_TABLE_100

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE

Line 35: , a32 JTF_VARCHAR2_TABLE_100

31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_DATE_TABLE

Line 40: , a37 JTF_VARCHAR2_TABLE_100

36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_NUMBER_TABLE

Line 45: , a42 JTF_VARCHAR2_TABLE_100

41: , a38 JTF_NUMBER_TABLE
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_200
48: , a45 JTF_VARCHAR2_TABLE_200
49: , a46 JTF_VARCHAR2_TABLE_200

Line 46: , a43 JTF_VARCHAR2_TABLE_100

42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_200
48: , a45 JTF_VARCHAR2_TABLE_200
49: , a46 JTF_VARCHAR2_TABLE_200
50: , a47 JTF_VARCHAR2_TABLE_200

Line 64: , a61 JTF_VARCHAR2_TABLE_100

60: , a57 JTF_VARCHAR2_TABLE_200
61: , a58 JTF_VARCHAR2_TABLE_200
62: , a59 JTF_NUMBER_TABLE
63: , a60 JTF_VARCHAR2_TABLE_3000
64: , a61 JTF_VARCHAR2_TABLE_100
65: , a62 JTF_VARCHAR2_TABLE_100
66: );
67: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE

Line 65: , a62 JTF_VARCHAR2_TABLE_100

61: , a58 JTF_VARCHAR2_TABLE_200
62: , a59 JTF_NUMBER_TABLE
63: , a60 JTF_VARCHAR2_TABLE_3000
64: , a61 JTF_VARCHAR2_TABLE_100
65: , a62 JTF_VARCHAR2_TABLE_100
66: );
67: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE

Line 70: , a3 out nocopy JTF_VARCHAR2_TABLE_100

66: );
67: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_VARCHAR2_TABLE_100
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_DATE_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE

Line 80: , a13 out nocopy JTF_VARCHAR2_TABLE_100

76: , a9 out nocopy JTF_NUMBER_TABLE
77: , a10 out nocopy JTF_NUMBER_TABLE
78: , a11 out nocopy JTF_VARCHAR2_TABLE_200
79: , a12 out nocopy JTF_NUMBER_TABLE
80: , a13 out nocopy JTF_VARCHAR2_TABLE_100
81: , a14 out nocopy JTF_VARCHAR2_TABLE_300
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_NUMBER_TABLE
84: , a17 out nocopy JTF_DATE_TABLE

Line 85: , a18 out nocopy JTF_VARCHAR2_TABLE_100

81: , a14 out nocopy JTF_VARCHAR2_TABLE_300
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_NUMBER_TABLE
84: , a17 out nocopy JTF_DATE_TABLE
85: , a18 out nocopy JTF_VARCHAR2_TABLE_100
86: , a19 out nocopy JTF_VARCHAR2_TABLE_100
87: , a20 out nocopy JTF_NUMBER_TABLE
88: , a21 out nocopy JTF_VARCHAR2_TABLE_100
89: , a22 out nocopy JTF_NUMBER_TABLE

Line 86: , a19 out nocopy JTF_VARCHAR2_TABLE_100

82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_NUMBER_TABLE
84: , a17 out nocopy JTF_DATE_TABLE
85: , a18 out nocopy JTF_VARCHAR2_TABLE_100
86: , a19 out nocopy JTF_VARCHAR2_TABLE_100
87: , a20 out nocopy JTF_NUMBER_TABLE
88: , a21 out nocopy JTF_VARCHAR2_TABLE_100
89: , a22 out nocopy JTF_NUMBER_TABLE
90: , a23 out nocopy JTF_NUMBER_TABLE

Line 88: , a21 out nocopy JTF_VARCHAR2_TABLE_100

84: , a17 out nocopy JTF_DATE_TABLE
85: , a18 out nocopy JTF_VARCHAR2_TABLE_100
86: , a19 out nocopy JTF_VARCHAR2_TABLE_100
87: , a20 out nocopy JTF_NUMBER_TABLE
88: , a21 out nocopy JTF_VARCHAR2_TABLE_100
89: , a22 out nocopy JTF_NUMBER_TABLE
90: , a23 out nocopy JTF_NUMBER_TABLE
91: , a24 out nocopy JTF_NUMBER_TABLE
92: , a25 out nocopy JTF_NUMBER_TABLE

Line 94: , a27 out nocopy JTF_VARCHAR2_TABLE_100

90: , a23 out nocopy JTF_NUMBER_TABLE
91: , a24 out nocopy JTF_NUMBER_TABLE
92: , a25 out nocopy JTF_NUMBER_TABLE
93: , a26 out nocopy JTF_NUMBER_TABLE
94: , a27 out nocopy JTF_VARCHAR2_TABLE_100
95: , a28 out nocopy JTF_NUMBER_TABLE
96: , a29 out nocopy JTF_NUMBER_TABLE
97: , a30 out nocopy JTF_NUMBER_TABLE
98: , a31 out nocopy JTF_NUMBER_TABLE

Line 99: , a32 out nocopy JTF_VARCHAR2_TABLE_100

95: , a28 out nocopy JTF_NUMBER_TABLE
96: , a29 out nocopy JTF_NUMBER_TABLE
97: , a30 out nocopy JTF_NUMBER_TABLE
98: , a31 out nocopy JTF_NUMBER_TABLE
99: , a32 out nocopy JTF_VARCHAR2_TABLE_100
100: , a33 out nocopy JTF_NUMBER_TABLE
101: , a34 out nocopy JTF_NUMBER_TABLE
102: , a35 out nocopy JTF_DATE_TABLE
103: , a36 out nocopy JTF_DATE_TABLE

Line 104: , a37 out nocopy JTF_VARCHAR2_TABLE_100

100: , a33 out nocopy JTF_NUMBER_TABLE
101: , a34 out nocopy JTF_NUMBER_TABLE
102: , a35 out nocopy JTF_DATE_TABLE
103: , a36 out nocopy JTF_DATE_TABLE
104: , a37 out nocopy JTF_VARCHAR2_TABLE_100
105: , a38 out nocopy JTF_NUMBER_TABLE
106: , a39 out nocopy JTF_NUMBER_TABLE
107: , a40 out nocopy JTF_NUMBER_TABLE
108: , a41 out nocopy JTF_NUMBER_TABLE

Line 109: , a42 out nocopy JTF_VARCHAR2_TABLE_100

105: , a38 out nocopy JTF_NUMBER_TABLE
106: , a39 out nocopy JTF_NUMBER_TABLE
107: , a40 out nocopy JTF_NUMBER_TABLE
108: , a41 out nocopy JTF_NUMBER_TABLE
109: , a42 out nocopy JTF_VARCHAR2_TABLE_100
110: , a43 out nocopy JTF_VARCHAR2_TABLE_100
111: , a44 out nocopy JTF_VARCHAR2_TABLE_200
112: , a45 out nocopy JTF_VARCHAR2_TABLE_200
113: , a46 out nocopy JTF_VARCHAR2_TABLE_200

Line 110: , a43 out nocopy JTF_VARCHAR2_TABLE_100

106: , a39 out nocopy JTF_NUMBER_TABLE
107: , a40 out nocopy JTF_NUMBER_TABLE
108: , a41 out nocopy JTF_NUMBER_TABLE
109: , a42 out nocopy JTF_VARCHAR2_TABLE_100
110: , a43 out nocopy JTF_VARCHAR2_TABLE_100
111: , a44 out nocopy JTF_VARCHAR2_TABLE_200
112: , a45 out nocopy JTF_VARCHAR2_TABLE_200
113: , a46 out nocopy JTF_VARCHAR2_TABLE_200
114: , a47 out nocopy JTF_VARCHAR2_TABLE_200

Line 128: , a61 out nocopy JTF_VARCHAR2_TABLE_100

124: , a57 out nocopy JTF_VARCHAR2_TABLE_200
125: , a58 out nocopy JTF_VARCHAR2_TABLE_200
126: , a59 out nocopy JTF_NUMBER_TABLE
127: , a60 out nocopy JTF_VARCHAR2_TABLE_3000
128: , a61 out nocopy JTF_VARCHAR2_TABLE_100
129: , a62 out nocopy JTF_VARCHAR2_TABLE_100
130: );
131:
132: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE

Line 129: , a62 out nocopy JTF_VARCHAR2_TABLE_100

125: , a58 out nocopy JTF_VARCHAR2_TABLE_200
126: , a59 out nocopy JTF_NUMBER_TABLE
127: , a60 out nocopy JTF_VARCHAR2_TABLE_3000
128: , a61 out nocopy JTF_VARCHAR2_TABLE_100
129: , a62 out nocopy JTF_VARCHAR2_TABLE_100
130: );
131:
132: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
133: , a1 JTF_NUMBER_TABLE

Line 135: , a3 JTF_VARCHAR2_TABLE_100

131:
132: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
133: , a1 JTF_NUMBER_TABLE
134: , a2 JTF_NUMBER_TABLE
135: , a3 JTF_VARCHAR2_TABLE_100
136: , a4 JTF_VARCHAR2_TABLE_300
137: , a5 JTF_NUMBER_TABLE
138: , a6 JTF_NUMBER_TABLE
139: , a7 JTF_NUMBER_TABLE

Line 144: , a12 JTF_VARCHAR2_TABLE_100

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

Line 148: , a16 JTF_VARCHAR2_TABLE_100

144: , a12 JTF_VARCHAR2_TABLE_100
145: , a13 JTF_NUMBER_TABLE
146: , a14 JTF_DATE_TABLE
147: , a15 JTF_NUMBER_TABLE
148: , a16 JTF_VARCHAR2_TABLE_100
149: , a17 JTF_NUMBER_TABLE
150: , a18 JTF_NUMBER_TABLE
151: , a19 JTF_NUMBER_TABLE
152: , a20 JTF_NUMBER_TABLE

Line 153: , a21 JTF_VARCHAR2_TABLE_100

149: , a17 JTF_NUMBER_TABLE
150: , a18 JTF_NUMBER_TABLE
151: , a19 JTF_NUMBER_TABLE
152: , a20 JTF_NUMBER_TABLE
153: , a21 JTF_VARCHAR2_TABLE_100
154: , a22 JTF_NUMBER_TABLE
155: , a23 JTF_VARCHAR2_TABLE_100
156: );
157: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 155: , a23 JTF_VARCHAR2_TABLE_100

151: , a19 JTF_NUMBER_TABLE
152: , a20 JTF_NUMBER_TABLE
153: , a21 JTF_VARCHAR2_TABLE_100
154: , a22 JTF_NUMBER_TABLE
155: , a23 JTF_VARCHAR2_TABLE_100
156: );
157: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE

Line 160: , a3 out nocopy JTF_VARCHAR2_TABLE_100

156: );
157: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_NUMBER_TABLE
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_300
162: , a5 out nocopy JTF_NUMBER_TABLE
163: , a6 out nocopy JTF_NUMBER_TABLE
164: , a7 out nocopy JTF_NUMBER_TABLE

Line 169: , a12 out nocopy JTF_VARCHAR2_TABLE_100

165: , a8 out nocopy JTF_NUMBER_TABLE
166: , a9 out nocopy JTF_NUMBER_TABLE
167: , a10 out nocopy JTF_NUMBER_TABLE
168: , a11 out nocopy JTF_DATE_TABLE
169: , a12 out nocopy JTF_VARCHAR2_TABLE_100
170: , a13 out nocopy JTF_NUMBER_TABLE
171: , a14 out nocopy JTF_DATE_TABLE
172: , a15 out nocopy JTF_NUMBER_TABLE
173: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 173: , a16 out nocopy JTF_VARCHAR2_TABLE_100

169: , a12 out nocopy JTF_VARCHAR2_TABLE_100
170: , a13 out nocopy JTF_NUMBER_TABLE
171: , a14 out nocopy JTF_DATE_TABLE
172: , a15 out nocopy JTF_NUMBER_TABLE
173: , a16 out nocopy JTF_VARCHAR2_TABLE_100
174: , a17 out nocopy JTF_NUMBER_TABLE
175: , a18 out nocopy JTF_NUMBER_TABLE
176: , a19 out nocopy JTF_NUMBER_TABLE
177: , a20 out nocopy JTF_NUMBER_TABLE

Line 178: , a21 out nocopy JTF_VARCHAR2_TABLE_100

174: , a17 out nocopy JTF_NUMBER_TABLE
175: , a18 out nocopy JTF_NUMBER_TABLE
176: , a19 out nocopy JTF_NUMBER_TABLE
177: , a20 out nocopy JTF_NUMBER_TABLE
178: , a21 out nocopy JTF_VARCHAR2_TABLE_100
179: , a22 out nocopy JTF_NUMBER_TABLE
180: , a23 out nocopy JTF_VARCHAR2_TABLE_100
181: );
182:

Line 180: , a23 out nocopy JTF_VARCHAR2_TABLE_100

176: , a19 out nocopy JTF_NUMBER_TABLE
177: , a20 out nocopy JTF_NUMBER_TABLE
178: , a21 out nocopy JTF_VARCHAR2_TABLE_100
179: , a22 out nocopy JTF_NUMBER_TABLE
180: , a23 out nocopy JTF_VARCHAR2_TABLE_100
181: );
182:
183: procedure create_material_reqst(p_api_version NUMBER
184: , p_init_msg_list VARCHAR2

Line 191: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100

187: , p_interface_flag VARCHAR2
188: , p5_a0 in out nocopy JTF_NUMBER_TABLE
189: , p5_a1 in out nocopy JTF_NUMBER_TABLE
190: , p5_a2 in out nocopy JTF_NUMBER_TABLE
191: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
192: , p5_a4 in out nocopy JTF_NUMBER_TABLE
193: , p5_a5 in out nocopy JTF_DATE_TABLE
194: , p5_a6 in out nocopy JTF_NUMBER_TABLE
195: , p5_a7 in out nocopy JTF_NUMBER_TABLE

Line 201: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100

197: , p5_a9 in out nocopy JTF_NUMBER_TABLE
198: , p5_a10 in out nocopy JTF_NUMBER_TABLE
199: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
200: , p5_a12 in out nocopy JTF_NUMBER_TABLE
201: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
203: , p5_a15 in out nocopy JTF_NUMBER_TABLE
204: , p5_a16 in out nocopy JTF_NUMBER_TABLE
205: , p5_a17 in out nocopy JTF_DATE_TABLE

Line 206: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100

202: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
203: , p5_a15 in out nocopy JTF_NUMBER_TABLE
204: , p5_a16 in out nocopy JTF_NUMBER_TABLE
205: , p5_a17 in out nocopy JTF_DATE_TABLE
206: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
207: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p5_a20 in out nocopy JTF_NUMBER_TABLE
209: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
210: , p5_a22 in out nocopy JTF_NUMBER_TABLE

Line 207: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100

203: , p5_a15 in out nocopy JTF_NUMBER_TABLE
204: , p5_a16 in out nocopy JTF_NUMBER_TABLE
205: , p5_a17 in out nocopy JTF_DATE_TABLE
206: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
207: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p5_a20 in out nocopy JTF_NUMBER_TABLE
209: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
210: , p5_a22 in out nocopy JTF_NUMBER_TABLE
211: , p5_a23 in out nocopy JTF_NUMBER_TABLE

Line 209: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100

205: , p5_a17 in out nocopy JTF_DATE_TABLE
206: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
207: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p5_a20 in out nocopy JTF_NUMBER_TABLE
209: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
210: , p5_a22 in out nocopy JTF_NUMBER_TABLE
211: , p5_a23 in out nocopy JTF_NUMBER_TABLE
212: , p5_a24 in out nocopy JTF_NUMBER_TABLE
213: , p5_a25 in out nocopy JTF_NUMBER_TABLE

Line 215: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100

211: , p5_a23 in out nocopy JTF_NUMBER_TABLE
212: , p5_a24 in out nocopy JTF_NUMBER_TABLE
213: , p5_a25 in out nocopy JTF_NUMBER_TABLE
214: , p5_a26 in out nocopy JTF_NUMBER_TABLE
215: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
216: , p5_a28 in out nocopy JTF_NUMBER_TABLE
217: , p5_a29 in out nocopy JTF_NUMBER_TABLE
218: , p5_a30 in out nocopy JTF_NUMBER_TABLE
219: , p5_a31 in out nocopy JTF_NUMBER_TABLE

Line 220: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100

216: , p5_a28 in out nocopy JTF_NUMBER_TABLE
217: , p5_a29 in out nocopy JTF_NUMBER_TABLE
218: , p5_a30 in out nocopy JTF_NUMBER_TABLE
219: , p5_a31 in out nocopy JTF_NUMBER_TABLE
220: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p5_a33 in out nocopy JTF_NUMBER_TABLE
222: , p5_a34 in out nocopy JTF_NUMBER_TABLE
223: , p5_a35 in out nocopy JTF_DATE_TABLE
224: , p5_a36 in out nocopy JTF_DATE_TABLE

Line 225: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100

221: , p5_a33 in out nocopy JTF_NUMBER_TABLE
222: , p5_a34 in out nocopy JTF_NUMBER_TABLE
223: , p5_a35 in out nocopy JTF_DATE_TABLE
224: , p5_a36 in out nocopy JTF_DATE_TABLE
225: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
226: , p5_a38 in out nocopy JTF_NUMBER_TABLE
227: , p5_a39 in out nocopy JTF_NUMBER_TABLE
228: , p5_a40 in out nocopy JTF_NUMBER_TABLE
229: , p5_a41 in out nocopy JTF_NUMBER_TABLE

Line 230: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100

226: , p5_a38 in out nocopy JTF_NUMBER_TABLE
227: , p5_a39 in out nocopy JTF_NUMBER_TABLE
228: , p5_a40 in out nocopy JTF_NUMBER_TABLE
229: , p5_a41 in out nocopy JTF_NUMBER_TABLE
230: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
231: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
232: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
233: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
234: , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200

Line 231: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100

227: , p5_a39 in out nocopy JTF_NUMBER_TABLE
228: , p5_a40 in out nocopy JTF_NUMBER_TABLE
229: , p5_a41 in out nocopy JTF_NUMBER_TABLE
230: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
231: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
232: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
233: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
234: , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200
235: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_200

Line 249: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100

245: , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
246: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
247: , p5_a59 in out nocopy JTF_NUMBER_TABLE
248: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
249: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
250: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
251: , x_job_return_status out nocopy VARCHAR2
252: , x_return_status out nocopy VARCHAR2
253: , x_msg_count out nocopy NUMBER

Line 250: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100

246: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
247: , p5_a59 in out nocopy JTF_NUMBER_TABLE
248: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
249: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
250: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
251: , x_job_return_status out nocopy VARCHAR2
252: , x_return_status out nocopy VARCHAR2
253: , x_msg_count out nocopy NUMBER
254: , x_msg_data out nocopy VARCHAR2

Line 264: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100

260: , p_module_type VARCHAR2
261: , p5_a0 in out nocopy JTF_NUMBER_TABLE
262: , p5_a1 in out nocopy JTF_NUMBER_TABLE
263: , p5_a2 in out nocopy JTF_NUMBER_TABLE
264: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p5_a4 in out nocopy JTF_NUMBER_TABLE
266: , p5_a5 in out nocopy JTF_DATE_TABLE
267: , p5_a6 in out nocopy JTF_NUMBER_TABLE
268: , p5_a7 in out nocopy JTF_NUMBER_TABLE

Line 274: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100

270: , p5_a9 in out nocopy JTF_NUMBER_TABLE
271: , p5_a10 in out nocopy JTF_NUMBER_TABLE
272: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
273: , p5_a12 in out nocopy JTF_NUMBER_TABLE
274: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
276: , p5_a15 in out nocopy JTF_NUMBER_TABLE
277: , p5_a16 in out nocopy JTF_NUMBER_TABLE
278: , p5_a17 in out nocopy JTF_DATE_TABLE

Line 279: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100

275: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
276: , p5_a15 in out nocopy JTF_NUMBER_TABLE
277: , p5_a16 in out nocopy JTF_NUMBER_TABLE
278: , p5_a17 in out nocopy JTF_DATE_TABLE
279: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p5_a20 in out nocopy JTF_NUMBER_TABLE
282: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p5_a22 in out nocopy JTF_NUMBER_TABLE

Line 280: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100

276: , p5_a15 in out nocopy JTF_NUMBER_TABLE
277: , p5_a16 in out nocopy JTF_NUMBER_TABLE
278: , p5_a17 in out nocopy JTF_DATE_TABLE
279: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p5_a20 in out nocopy JTF_NUMBER_TABLE
282: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p5_a22 in out nocopy JTF_NUMBER_TABLE
284: , p5_a23 in out nocopy JTF_NUMBER_TABLE

Line 282: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100

278: , p5_a17 in out nocopy JTF_DATE_TABLE
279: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p5_a20 in out nocopy JTF_NUMBER_TABLE
282: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
283: , p5_a22 in out nocopy JTF_NUMBER_TABLE
284: , p5_a23 in out nocopy JTF_NUMBER_TABLE
285: , p5_a24 in out nocopy JTF_NUMBER_TABLE
286: , p5_a25 in out nocopy JTF_NUMBER_TABLE

Line 288: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100

284: , p5_a23 in out nocopy JTF_NUMBER_TABLE
285: , p5_a24 in out nocopy JTF_NUMBER_TABLE
286: , p5_a25 in out nocopy JTF_NUMBER_TABLE
287: , p5_a26 in out nocopy JTF_NUMBER_TABLE
288: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
289: , p5_a28 in out nocopy JTF_NUMBER_TABLE
290: , p5_a29 in out nocopy JTF_NUMBER_TABLE
291: , p5_a30 in out nocopy JTF_NUMBER_TABLE
292: , p5_a31 in out nocopy JTF_NUMBER_TABLE

Line 293: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100

289: , p5_a28 in out nocopy JTF_NUMBER_TABLE
290: , p5_a29 in out nocopy JTF_NUMBER_TABLE
291: , p5_a30 in out nocopy JTF_NUMBER_TABLE
292: , p5_a31 in out nocopy JTF_NUMBER_TABLE
293: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
294: , p5_a33 in out nocopy JTF_NUMBER_TABLE
295: , p5_a34 in out nocopy JTF_NUMBER_TABLE
296: , p5_a35 in out nocopy JTF_DATE_TABLE
297: , p5_a36 in out nocopy JTF_DATE_TABLE

Line 298: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100

294: , p5_a33 in out nocopy JTF_NUMBER_TABLE
295: , p5_a34 in out nocopy JTF_NUMBER_TABLE
296: , p5_a35 in out nocopy JTF_DATE_TABLE
297: , p5_a36 in out nocopy JTF_DATE_TABLE
298: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a38 in out nocopy JTF_NUMBER_TABLE
300: , p5_a39 in out nocopy JTF_NUMBER_TABLE
301: , p5_a40 in out nocopy JTF_NUMBER_TABLE
302: , p5_a41 in out nocopy JTF_NUMBER_TABLE

Line 303: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100

299: , p5_a38 in out nocopy JTF_NUMBER_TABLE
300: , p5_a39 in out nocopy JTF_NUMBER_TABLE
301: , p5_a40 in out nocopy JTF_NUMBER_TABLE
302: , p5_a41 in out nocopy JTF_NUMBER_TABLE
303: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
305: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
306: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
307: , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200

Line 304: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100

300: , p5_a39 in out nocopy JTF_NUMBER_TABLE
301: , p5_a40 in out nocopy JTF_NUMBER_TABLE
302: , p5_a41 in out nocopy JTF_NUMBER_TABLE
303: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
305: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
306: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
307: , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200
308: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_200

Line 322: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100

318: , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
319: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
320: , p5_a59 in out nocopy JTF_NUMBER_TABLE
321: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
322: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
324: , x_return_status out nocopy VARCHAR2
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2

Line 323: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100

319: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
320: , p5_a59 in out nocopy JTF_NUMBER_TABLE
321: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
322: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
324: , x_return_status out nocopy VARCHAR2
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: );

Line 388: , p4_a3 JTF_VARCHAR2_TABLE_100

384: , p_validation_level NUMBER
385: , p4_a0 JTF_NUMBER_TABLE
386: , p4_a1 JTF_NUMBER_TABLE
387: , p4_a2 JTF_NUMBER_TABLE
388: , p4_a3 JTF_VARCHAR2_TABLE_100
389: , p4_a4 JTF_NUMBER_TABLE
390: , p4_a5 JTF_DATE_TABLE
391: , p4_a6 JTF_NUMBER_TABLE
392: , p4_a7 JTF_NUMBER_TABLE

Line 398: , p4_a13 JTF_VARCHAR2_TABLE_100

394: , p4_a9 JTF_NUMBER_TABLE
395: , p4_a10 JTF_NUMBER_TABLE
396: , p4_a11 JTF_VARCHAR2_TABLE_200
397: , p4_a12 JTF_NUMBER_TABLE
398: , p4_a13 JTF_VARCHAR2_TABLE_100
399: , p4_a14 JTF_VARCHAR2_TABLE_300
400: , p4_a15 JTF_NUMBER_TABLE
401: , p4_a16 JTF_NUMBER_TABLE
402: , p4_a17 JTF_DATE_TABLE

Line 403: , p4_a18 JTF_VARCHAR2_TABLE_100

399: , p4_a14 JTF_VARCHAR2_TABLE_300
400: , p4_a15 JTF_NUMBER_TABLE
401: , p4_a16 JTF_NUMBER_TABLE
402: , p4_a17 JTF_DATE_TABLE
403: , p4_a18 JTF_VARCHAR2_TABLE_100
404: , p4_a19 JTF_VARCHAR2_TABLE_100
405: , p4_a20 JTF_NUMBER_TABLE
406: , p4_a21 JTF_VARCHAR2_TABLE_100
407: , p4_a22 JTF_NUMBER_TABLE

Line 404: , p4_a19 JTF_VARCHAR2_TABLE_100

400: , p4_a15 JTF_NUMBER_TABLE
401: , p4_a16 JTF_NUMBER_TABLE
402: , p4_a17 JTF_DATE_TABLE
403: , p4_a18 JTF_VARCHAR2_TABLE_100
404: , p4_a19 JTF_VARCHAR2_TABLE_100
405: , p4_a20 JTF_NUMBER_TABLE
406: , p4_a21 JTF_VARCHAR2_TABLE_100
407: , p4_a22 JTF_NUMBER_TABLE
408: , p4_a23 JTF_NUMBER_TABLE

Line 406: , p4_a21 JTF_VARCHAR2_TABLE_100

402: , p4_a17 JTF_DATE_TABLE
403: , p4_a18 JTF_VARCHAR2_TABLE_100
404: , p4_a19 JTF_VARCHAR2_TABLE_100
405: , p4_a20 JTF_NUMBER_TABLE
406: , p4_a21 JTF_VARCHAR2_TABLE_100
407: , p4_a22 JTF_NUMBER_TABLE
408: , p4_a23 JTF_NUMBER_TABLE
409: , p4_a24 JTF_NUMBER_TABLE
410: , p4_a25 JTF_NUMBER_TABLE

Line 412: , p4_a27 JTF_VARCHAR2_TABLE_100

408: , p4_a23 JTF_NUMBER_TABLE
409: , p4_a24 JTF_NUMBER_TABLE
410: , p4_a25 JTF_NUMBER_TABLE
411: , p4_a26 JTF_NUMBER_TABLE
412: , p4_a27 JTF_VARCHAR2_TABLE_100
413: , p4_a28 JTF_NUMBER_TABLE
414: , p4_a29 JTF_NUMBER_TABLE
415: , p4_a30 JTF_NUMBER_TABLE
416: , p4_a31 JTF_NUMBER_TABLE

Line 417: , p4_a32 JTF_VARCHAR2_TABLE_100

413: , p4_a28 JTF_NUMBER_TABLE
414: , p4_a29 JTF_NUMBER_TABLE
415: , p4_a30 JTF_NUMBER_TABLE
416: , p4_a31 JTF_NUMBER_TABLE
417: , p4_a32 JTF_VARCHAR2_TABLE_100
418: , p4_a33 JTF_NUMBER_TABLE
419: , p4_a34 JTF_NUMBER_TABLE
420: , p4_a35 JTF_DATE_TABLE
421: , p4_a36 JTF_DATE_TABLE

Line 422: , p4_a37 JTF_VARCHAR2_TABLE_100

418: , p4_a33 JTF_NUMBER_TABLE
419: , p4_a34 JTF_NUMBER_TABLE
420: , p4_a35 JTF_DATE_TABLE
421: , p4_a36 JTF_DATE_TABLE
422: , p4_a37 JTF_VARCHAR2_TABLE_100
423: , p4_a38 JTF_NUMBER_TABLE
424: , p4_a39 JTF_NUMBER_TABLE
425: , p4_a40 JTF_NUMBER_TABLE
426: , p4_a41 JTF_NUMBER_TABLE

Line 427: , p4_a42 JTF_VARCHAR2_TABLE_100

423: , p4_a38 JTF_NUMBER_TABLE
424: , p4_a39 JTF_NUMBER_TABLE
425: , p4_a40 JTF_NUMBER_TABLE
426: , p4_a41 JTF_NUMBER_TABLE
427: , p4_a42 JTF_VARCHAR2_TABLE_100
428: , p4_a43 JTF_VARCHAR2_TABLE_100
429: , p4_a44 JTF_VARCHAR2_TABLE_200
430: , p4_a45 JTF_VARCHAR2_TABLE_200
431: , p4_a46 JTF_VARCHAR2_TABLE_200

Line 428: , p4_a43 JTF_VARCHAR2_TABLE_100

424: , p4_a39 JTF_NUMBER_TABLE
425: , p4_a40 JTF_NUMBER_TABLE
426: , p4_a41 JTF_NUMBER_TABLE
427: , p4_a42 JTF_VARCHAR2_TABLE_100
428: , p4_a43 JTF_VARCHAR2_TABLE_100
429: , p4_a44 JTF_VARCHAR2_TABLE_200
430: , p4_a45 JTF_VARCHAR2_TABLE_200
431: , p4_a46 JTF_VARCHAR2_TABLE_200
432: , p4_a47 JTF_VARCHAR2_TABLE_200

Line 446: , p4_a61 JTF_VARCHAR2_TABLE_100

442: , p4_a57 JTF_VARCHAR2_TABLE_200
443: , p4_a58 JTF_VARCHAR2_TABLE_200
444: , p4_a59 JTF_NUMBER_TABLE
445: , p4_a60 JTF_VARCHAR2_TABLE_3000
446: , p4_a61 JTF_VARCHAR2_TABLE_100
447: , p4_a62 JTF_VARCHAR2_TABLE_100
448: , x_return_status out nocopy VARCHAR2
449: , x_msg_count out nocopy NUMBER
450: , x_msg_data out nocopy VARCHAR2

Line 447: , p4_a62 JTF_VARCHAR2_TABLE_100

443: , p4_a58 JTF_VARCHAR2_TABLE_200
444: , p4_a59 JTF_NUMBER_TABLE
445: , p4_a60 JTF_VARCHAR2_TABLE_3000
446: , p4_a61 JTF_VARCHAR2_TABLE_100
447: , p4_a62 JTF_VARCHAR2_TABLE_100
448: , x_return_status out nocopy VARCHAR2
449: , x_msg_count out nocopy NUMBER
450: , x_msg_data out nocopy VARCHAR2
451: );