DBA Data[Home] [Help]

APPS.OKL_QQH_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 21: , a18 JTF_VARCHAR2_TABLE_200

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

Line 54: , a51 JTF_VARCHAR2_TABLE_2000

50: , a47 JTF_NUMBER_TABLE
51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_VARCHAR2_TABLE_300
54: , a51 JTF_VARCHAR2_TABLE_2000
55: , a52 JTF_VARCHAR2_TABLE_2000
56: , a53 JTF_VARCHAR2_TABLE_100
57: );
58: procedure rosetta_table_copy_out_p23(t okl_qqh_pvt.qqhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 55: , a52 JTF_VARCHAR2_TABLE_2000

51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_VARCHAR2_TABLE_300
54: , a51 JTF_VARCHAR2_TABLE_2000
55: , a52 JTF_VARCHAR2_TABLE_2000
56: , a53 JTF_VARCHAR2_TABLE_100
57: );
58: procedure rosetta_table_copy_out_p23(t okl_qqh_pvt.qqhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE

Line 76: , a18 out nocopy JTF_VARCHAR2_TABLE_200

72: , a14 out nocopy JTF_VARCHAR2_TABLE_500
73: , a15 out nocopy JTF_VARCHAR2_TABLE_500
74: , a16 out nocopy JTF_VARCHAR2_TABLE_500
75: , a17 out nocopy JTF_VARCHAR2_TABLE_500
76: , a18 out nocopy JTF_VARCHAR2_TABLE_200
77: , a19 out nocopy JTF_DATE_TABLE
78: , a20 out nocopy JTF_NUMBER_TABLE
79: , a21 out nocopy JTF_NUMBER_TABLE
80: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , a51 out nocopy JTF_VARCHAR2_TABLE_2000

105: , a47 out nocopy JTF_NUMBER_TABLE
106: , a48 out nocopy JTF_NUMBER_TABLE
107: , a49 out nocopy JTF_NUMBER_TABLE
108: , a50 out nocopy JTF_VARCHAR2_TABLE_300
109: , a51 out nocopy JTF_VARCHAR2_TABLE_2000
110: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a53 out nocopy JTF_VARCHAR2_TABLE_100
112: );
113:

Line 110: , a52 out nocopy JTF_VARCHAR2_TABLE_2000

106: , a48 out nocopy JTF_NUMBER_TABLE
107: , a49 out nocopy JTF_NUMBER_TABLE
108: , a50 out nocopy JTF_VARCHAR2_TABLE_300
109: , a51 out nocopy JTF_VARCHAR2_TABLE_2000
110: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a53 out nocopy JTF_VARCHAR2_TABLE_100
112: );
113:
114: procedure insert_row(p_api_version NUMBER

Line 137: , p5_a18 JTF_VARCHAR2_TABLE_200

133: , p5_a14 JTF_VARCHAR2_TABLE_500
134: , p5_a15 JTF_VARCHAR2_TABLE_500
135: , p5_a16 JTF_VARCHAR2_TABLE_500
136: , p5_a17 JTF_VARCHAR2_TABLE_500
137: , p5_a18 JTF_VARCHAR2_TABLE_200
138: , p5_a19 JTF_DATE_TABLE
139: , p5_a20 JTF_NUMBER_TABLE
140: , p5_a21 JTF_NUMBER_TABLE
141: , p5_a22 JTF_VARCHAR2_TABLE_100

Line 170: , p5_a51 JTF_VARCHAR2_TABLE_2000

166: , p5_a47 JTF_NUMBER_TABLE
167: , p5_a48 JTF_NUMBER_TABLE
168: , p5_a49 JTF_NUMBER_TABLE
169: , p5_a50 JTF_VARCHAR2_TABLE_300
170: , p5_a51 JTF_VARCHAR2_TABLE_2000
171: , p5_a52 JTF_VARCHAR2_TABLE_2000
172: , p5_a53 JTF_VARCHAR2_TABLE_100
173: , p6_a0 out nocopy JTF_NUMBER_TABLE
174: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 171: , p5_a52 JTF_VARCHAR2_TABLE_2000

167: , p5_a48 JTF_NUMBER_TABLE
168: , p5_a49 JTF_NUMBER_TABLE
169: , p5_a50 JTF_VARCHAR2_TABLE_300
170: , p5_a51 JTF_VARCHAR2_TABLE_2000
171: , p5_a52 JTF_VARCHAR2_TABLE_2000
172: , p5_a53 JTF_VARCHAR2_TABLE_100
173: , p6_a0 out nocopy JTF_NUMBER_TABLE
174: , p6_a1 out nocopy JTF_NUMBER_TABLE
175: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 191: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200

187: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
188: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
189: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
190: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
191: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
192: , p6_a19 out nocopy JTF_DATE_TABLE
193: , p6_a20 out nocopy JTF_NUMBER_TABLE
194: , p6_a21 out nocopy JTF_NUMBER_TABLE
195: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 224: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000

220: , p6_a47 out nocopy JTF_NUMBER_TABLE
221: , p6_a48 out nocopy JTF_NUMBER_TABLE
222: , p6_a49 out nocopy JTF_NUMBER_TABLE
223: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
224: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
225: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
227: );
228: procedure update_row(p_api_version NUMBER

Line 225: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000

221: , p6_a48 out nocopy JTF_NUMBER_TABLE
222: , p6_a49 out nocopy JTF_NUMBER_TABLE
223: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
224: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
225: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
227: );
228: procedure update_row(p_api_version NUMBER
229: , p_init_msg_list VARCHAR2

Line 251: , p5_a18 JTF_VARCHAR2_TABLE_200

247: , p5_a14 JTF_VARCHAR2_TABLE_500
248: , p5_a15 JTF_VARCHAR2_TABLE_500
249: , p5_a16 JTF_VARCHAR2_TABLE_500
250: , p5_a17 JTF_VARCHAR2_TABLE_500
251: , p5_a18 JTF_VARCHAR2_TABLE_200
252: , p5_a19 JTF_DATE_TABLE
253: , p5_a20 JTF_NUMBER_TABLE
254: , p5_a21 JTF_NUMBER_TABLE
255: , p5_a22 JTF_VARCHAR2_TABLE_100

Line 284: , p5_a51 JTF_VARCHAR2_TABLE_2000

280: , p5_a47 JTF_NUMBER_TABLE
281: , p5_a48 JTF_NUMBER_TABLE
282: , p5_a49 JTF_NUMBER_TABLE
283: , p5_a50 JTF_VARCHAR2_TABLE_300
284: , p5_a51 JTF_VARCHAR2_TABLE_2000
285: , p5_a52 JTF_VARCHAR2_TABLE_2000
286: , p5_a53 JTF_VARCHAR2_TABLE_100
287: , p6_a0 out nocopy JTF_NUMBER_TABLE
288: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 285: , p5_a52 JTF_VARCHAR2_TABLE_2000

281: , p5_a48 JTF_NUMBER_TABLE
282: , p5_a49 JTF_NUMBER_TABLE
283: , p5_a50 JTF_VARCHAR2_TABLE_300
284: , p5_a51 JTF_VARCHAR2_TABLE_2000
285: , p5_a52 JTF_VARCHAR2_TABLE_2000
286: , p5_a53 JTF_VARCHAR2_TABLE_100
287: , p6_a0 out nocopy JTF_NUMBER_TABLE
288: , p6_a1 out nocopy JTF_NUMBER_TABLE
289: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 305: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200

301: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
302: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
303: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
304: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
305: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
306: , p6_a19 out nocopy JTF_DATE_TABLE
307: , p6_a20 out nocopy JTF_NUMBER_TABLE
308: , p6_a21 out nocopy JTF_NUMBER_TABLE
309: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 338: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000

334: , p6_a47 out nocopy JTF_NUMBER_TABLE
335: , p6_a48 out nocopy JTF_NUMBER_TABLE
336: , p6_a49 out nocopy JTF_NUMBER_TABLE
337: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
338: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
340: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
341: );
342: procedure delete_row(p_api_version NUMBER

Line 339: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000

335: , p6_a48 out nocopy JTF_NUMBER_TABLE
336: , p6_a49 out nocopy JTF_NUMBER_TABLE
337: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
338: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
340: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
341: );
342: procedure delete_row(p_api_version NUMBER
343: , p_init_msg_list VARCHAR2

Line 365: , p5_a18 JTF_VARCHAR2_TABLE_200

361: , p5_a14 JTF_VARCHAR2_TABLE_500
362: , p5_a15 JTF_VARCHAR2_TABLE_500
363: , p5_a16 JTF_VARCHAR2_TABLE_500
364: , p5_a17 JTF_VARCHAR2_TABLE_500
365: , p5_a18 JTF_VARCHAR2_TABLE_200
366: , p5_a19 JTF_DATE_TABLE
367: , p5_a20 JTF_NUMBER_TABLE
368: , p5_a21 JTF_NUMBER_TABLE
369: , p5_a22 JTF_VARCHAR2_TABLE_100

Line 398: , p5_a51 JTF_VARCHAR2_TABLE_2000

394: , p5_a47 JTF_NUMBER_TABLE
395: , p5_a48 JTF_NUMBER_TABLE
396: , p5_a49 JTF_NUMBER_TABLE
397: , p5_a50 JTF_VARCHAR2_TABLE_300
398: , p5_a51 JTF_VARCHAR2_TABLE_2000
399: , p5_a52 JTF_VARCHAR2_TABLE_2000
400: , p5_a53 JTF_VARCHAR2_TABLE_100
401: );
402: procedure insert_row(p_api_version NUMBER

Line 399: , p5_a52 JTF_VARCHAR2_TABLE_2000

395: , p5_a48 JTF_NUMBER_TABLE
396: , p5_a49 JTF_NUMBER_TABLE
397: , p5_a50 JTF_VARCHAR2_TABLE_300
398: , p5_a51 JTF_VARCHAR2_TABLE_2000
399: , p5_a52 JTF_VARCHAR2_TABLE_2000
400: , p5_a53 JTF_VARCHAR2_TABLE_100
401: );
402: procedure insert_row(p_api_version NUMBER
403: , p_init_msg_list VARCHAR2