APPS.OKL_RSP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLIRSPS.pls 120.0 2007/12/10 18:30:50 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rsp_pvt.rps_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_DATE_TABLE

Line 16: , a3 out nocopy JTF_VARCHAR2_TABLE_100

12: );
13: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_VARCHAR2_TABLE_100
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE

Line 56: , p5_a3 JTF_VARCHAR2_TABLE_100

52: , x_msg_data out nocopy VARCHAR2
53: , p5_a0 JTF_NUMBER_TABLE
54: , p5_a1 JTF_NUMBER_TABLE
55: , p5_a2 JTF_NUMBER_TABLE
56: , p5_a3 JTF_VARCHAR2_TABLE_100
57: , p5_a4 JTF_NUMBER_TABLE
58: , p5_a5 JTF_DATE_TABLE
59: , p5_a6 JTF_NUMBER_TABLE
60: , p5_a7 JTF_DATE_TABLE

Line 65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

61: , p5_a8 JTF_NUMBER_TABLE
62: , p6_a0 out nocopy JTF_NUMBER_TABLE
63: , p6_a1 out nocopy JTF_NUMBER_TABLE
64: , p6_a2 out nocopy JTF_NUMBER_TABLE
65: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , p6_a4 out nocopy JTF_NUMBER_TABLE
67: , p6_a5 out nocopy JTF_DATE_TABLE
68: , p6_a6 out nocopy JTF_NUMBER_TABLE
69: , p6_a7 out nocopy JTF_DATE_TABLE

Line 72: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

68: , p6_a6 out nocopy JTF_NUMBER_TABLE
69: , p6_a7 out nocopy JTF_DATE_TABLE
70: , p6_a8 out nocopy JTF_NUMBER_TABLE
71: , p7_a0 in out nocopy JTF_NUMBER_TABLE
72: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p7_a2 in out nocopy JTF_NUMBER_TABLE
74: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
75: , p7_a4 in out nocopy JTF_NUMBER_TABLE
76: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 76: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

72: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
73: , p7_a2 in out nocopy JTF_NUMBER_TABLE
74: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
75: , p7_a4 in out nocopy JTF_NUMBER_TABLE
76: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
77: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
78: );
79: procedure insert_row(p_api_version NUMBER
80: , p_init_msg_list VARCHAR2

Line 77: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

73: , p7_a2 in out nocopy JTF_NUMBER_TABLE
74: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
75: , p7_a4 in out nocopy JTF_NUMBER_TABLE
76: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
77: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
78: );
79: procedure insert_row(p_api_version NUMBER
80: , p_init_msg_list VARCHAR2
81: , x_return_status out nocopy VARCHAR2

Line 87: , p5_a3 JTF_VARCHAR2_TABLE_100

83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_VARCHAR2_TABLE_100
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_NUMBER_TABLE
91: , p5_a7 JTF_DATE_TABLE

Line 96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

92: , p5_a8 JTF_NUMBER_TABLE
93: , p6_a0 out nocopy JTF_NUMBER_TABLE
94: , p6_a1 out nocopy JTF_NUMBER_TABLE
95: , p6_a2 out nocopy JTF_NUMBER_TABLE
96: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p6_a4 out nocopy JTF_NUMBER_TABLE
98: , p6_a5 out nocopy JTF_DATE_TABLE
99: , p6_a6 out nocopy JTF_NUMBER_TABLE
100: , p6_a7 out nocopy JTF_DATE_TABLE

Line 126: , p5_a3 JTF_VARCHAR2_TABLE_100

122: , x_msg_data out nocopy VARCHAR2
123: , p5_a0 JTF_NUMBER_TABLE
124: , p5_a1 JTF_NUMBER_TABLE
125: , p5_a2 JTF_NUMBER_TABLE
126: , p5_a3 JTF_VARCHAR2_TABLE_100
127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_DATE_TABLE
129: , p5_a6 JTF_NUMBER_TABLE
130: , p5_a7 JTF_DATE_TABLE

Line 133: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

129: , p5_a6 JTF_NUMBER_TABLE
130: , p5_a7 JTF_DATE_TABLE
131: , p5_a8 JTF_NUMBER_TABLE
132: , p6_a0 in out nocopy JTF_NUMBER_TABLE
133: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 in out nocopy JTF_NUMBER_TABLE
135: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
136: , p6_a4 in out nocopy JTF_NUMBER_TABLE
137: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 137: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

133: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 in out nocopy JTF_NUMBER_TABLE
135: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
136: , p6_a4 in out nocopy JTF_NUMBER_TABLE
137: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
138: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
139: );
140: procedure lock_row(p_api_version NUMBER
141: , p_init_msg_list VARCHAR2

Line 138: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

134: , p6_a2 in out nocopy JTF_NUMBER_TABLE
135: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
136: , p6_a4 in out nocopy JTF_NUMBER_TABLE
137: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
138: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
139: );
140: procedure lock_row(p_api_version NUMBER
141: , p_init_msg_list VARCHAR2
142: , x_return_status out nocopy VARCHAR2

Line 148: , p5_a3 JTF_VARCHAR2_TABLE_100

144: , x_msg_data out nocopy VARCHAR2
145: , p5_a0 JTF_NUMBER_TABLE
146: , p5_a1 JTF_NUMBER_TABLE
147: , p5_a2 JTF_NUMBER_TABLE
148: , p5_a3 JTF_VARCHAR2_TABLE_100
149: , p5_a4 JTF_NUMBER_TABLE
150: , p5_a5 JTF_DATE_TABLE
151: , p5_a6 JTF_NUMBER_TABLE
152: , p5_a7 JTF_DATE_TABLE

Line 187: , p5_a3 JTF_VARCHAR2_TABLE_100

183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_VARCHAR2_TABLE_100
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_DATE_TABLE
190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_DATE_TABLE

Line 196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

192: , p5_a8 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_NUMBER_TABLE
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a4 out nocopy JTF_NUMBER_TABLE
198: , p6_a5 out nocopy JTF_DATE_TABLE
199: , p6_a6 out nocopy JTF_NUMBER_TABLE
200: , p6_a7 out nocopy JTF_DATE_TABLE

Line 203: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

199: , p6_a6 out nocopy JTF_NUMBER_TABLE
200: , p6_a7 out nocopy JTF_DATE_TABLE
201: , p6_a8 out nocopy JTF_NUMBER_TABLE
202: , p7_a0 in out nocopy JTF_NUMBER_TABLE
203: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a2 in out nocopy JTF_NUMBER_TABLE
205: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
206: , p7_a4 in out nocopy JTF_NUMBER_TABLE
207: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 207: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

203: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a2 in out nocopy JTF_NUMBER_TABLE
205: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
206: , p7_a4 in out nocopy JTF_NUMBER_TABLE
207: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
209: );
210: procedure update_row(p_api_version NUMBER
211: , p_init_msg_list VARCHAR2

Line 208: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

204: , p7_a2 in out nocopy JTF_NUMBER_TABLE
205: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
206: , p7_a4 in out nocopy JTF_NUMBER_TABLE
207: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
209: );
210: procedure update_row(p_api_version NUMBER
211: , p_init_msg_list VARCHAR2
212: , x_return_status out nocopy VARCHAR2

Line 218: , p5_a3 JTF_VARCHAR2_TABLE_100

214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_VARCHAR2_TABLE_100
219: , p5_a4 JTF_NUMBER_TABLE
220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE
222: , p5_a7 JTF_DATE_TABLE

Line 227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

223: , p5_a8 JTF_NUMBER_TABLE
224: , p6_a0 out nocopy JTF_NUMBER_TABLE
225: , p6_a1 out nocopy JTF_NUMBER_TABLE
226: , p6_a2 out nocopy JTF_NUMBER_TABLE
227: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a4 out nocopy JTF_NUMBER_TABLE
229: , p6_a5 out nocopy JTF_DATE_TABLE
230: , p6_a6 out nocopy JTF_NUMBER_TABLE
231: , p6_a7 out nocopy JTF_DATE_TABLE

Line 257: , p5_a3 JTF_VARCHAR2_TABLE_100

253: , x_msg_data out nocopy VARCHAR2
254: , p5_a0 JTF_NUMBER_TABLE
255: , p5_a1 JTF_NUMBER_TABLE
256: , p5_a2 JTF_NUMBER_TABLE
257: , p5_a3 JTF_VARCHAR2_TABLE_100
258: , p5_a4 JTF_NUMBER_TABLE
259: , p5_a5 JTF_DATE_TABLE
260: , p5_a6 JTF_NUMBER_TABLE
261: , p5_a7 JTF_DATE_TABLE

Line 264: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

260: , p5_a6 JTF_NUMBER_TABLE
261: , p5_a7 JTF_DATE_TABLE
262: , p5_a8 JTF_NUMBER_TABLE
263: , p6_a0 in out nocopy JTF_NUMBER_TABLE
264: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a2 in out nocopy JTF_NUMBER_TABLE
266: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
267: , p6_a4 in out nocopy JTF_NUMBER_TABLE
268: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

264: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a2 in out nocopy JTF_NUMBER_TABLE
266: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
267: , p6_a4 in out nocopy JTF_NUMBER_TABLE
268: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
270: );
271: procedure delete_row(p_api_version NUMBER
272: , p_init_msg_list VARCHAR2

Line 269: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

265: , p6_a2 in out nocopy JTF_NUMBER_TABLE
266: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
267: , p6_a4 in out nocopy JTF_NUMBER_TABLE
268: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
270: );
271: procedure delete_row(p_api_version NUMBER
272: , p_init_msg_list VARCHAR2
273: , x_return_status out nocopy VARCHAR2

Line 279: , p5_a3 JTF_VARCHAR2_TABLE_100

275: , x_msg_data out nocopy VARCHAR2
276: , p5_a0 JTF_NUMBER_TABLE
277: , p5_a1 JTF_NUMBER_TABLE
278: , p5_a2 JTF_NUMBER_TABLE
279: , p5_a3 JTF_VARCHAR2_TABLE_100
280: , p5_a4 JTF_NUMBER_TABLE
281: , p5_a5 JTF_DATE_TABLE
282: , p5_a6 JTF_NUMBER_TABLE
283: , p5_a7 JTF_DATE_TABLE

Line 309: , p5_a3 JTF_VARCHAR2_TABLE_100

305: , x_msg_data out nocopy VARCHAR2
306: , p5_a0 JTF_NUMBER_TABLE
307: , p5_a1 JTF_NUMBER_TABLE
308: , p5_a2 JTF_NUMBER_TABLE
309: , p5_a3 JTF_VARCHAR2_TABLE_100
310: , p5_a4 JTF_NUMBER_TABLE
311: , p5_a5 JTF_DATE_TABLE
312: , p5_a6 JTF_NUMBER_TABLE
313: , p5_a7 JTF_DATE_TABLE

Line 316: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

312: , p5_a6 JTF_NUMBER_TABLE
313: , p5_a7 JTF_DATE_TABLE
314: , p5_a8 JTF_NUMBER_TABLE
315: , p6_a0 in out nocopy JTF_NUMBER_TABLE
316: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a2 in out nocopy JTF_NUMBER_TABLE
318: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p6_a4 in out nocopy JTF_NUMBER_TABLE
320: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 320: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

316: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a2 in out nocopy JTF_NUMBER_TABLE
318: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p6_a4 in out nocopy JTF_NUMBER_TABLE
320: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
322: );
323: procedure validate_row(p_api_version NUMBER
324: , p_init_msg_list VARCHAR2

Line 321: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

317: , p6_a2 in out nocopy JTF_NUMBER_TABLE
318: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p6_a4 in out nocopy JTF_NUMBER_TABLE
320: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
322: );
323: procedure validate_row(p_api_version NUMBER
324: , p_init_msg_list VARCHAR2
325: , x_return_status out nocopy VARCHAR2

Line 331: , p5_a3 JTF_VARCHAR2_TABLE_100

327: , x_msg_data out nocopy VARCHAR2
328: , p5_a0 JTF_NUMBER_TABLE
329: , p5_a1 JTF_NUMBER_TABLE
330: , p5_a2 JTF_NUMBER_TABLE
331: , p5_a3 JTF_VARCHAR2_TABLE_100
332: , p5_a4 JTF_NUMBER_TABLE
333: , p5_a5 JTF_DATE_TABLE
334: , p5_a6 JTF_NUMBER_TABLE
335: , p5_a7 JTF_DATE_TABLE