DBA Data[Home] [Help]

APPS.OKL_QLS_PVT_W dependencies on JTF_DATE_TABLE

Line 10: , a7 JTF_DATE_TABLE

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

Line 12: , a9 JTF_DATE_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 22: , a7 out nocopy JTF_DATE_TABLE

18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_DATE_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_DATE_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );

Line 24: , a9 out nocopy JTF_DATE_TABLE

20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_DATE_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_DATE_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE

Line 35: , a7 JTF_DATE_TABLE

31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_DATE_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_DATE_TABLE
38: , a10 JTF_NUMBER_TABLE
39: );

Line 37: , a9 JTF_DATE_TABLE

33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_DATE_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_DATE_TABLE
38: , a10 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a7 out nocopy JTF_DATE_TABLE

43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_NUMBER_TABLE
51: );

Line 49: , a9 out nocopy JTF_DATE_TABLE

45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_NUMBER_TABLE
51: );
52:
53: procedure insert_row(p_api_version NUMBER

Line 93: , p5_a7 JTF_DATE_TABLE

89: , p5_a3 JTF_VARCHAR2_TABLE_100
90: , p5_a4 JTF_NUMBER_TABLE
91: , p5_a5 JTF_NUMBER_TABLE
92: , p5_a6 JTF_NUMBER_TABLE
93: , p5_a7 JTF_DATE_TABLE
94: , p5_a8 JTF_NUMBER_TABLE
95: , p5_a9 JTF_DATE_TABLE
96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 95: , p5_a9 JTF_DATE_TABLE

91: , p5_a5 JTF_NUMBER_TABLE
92: , p5_a6 JTF_NUMBER_TABLE
93: , p5_a7 JTF_DATE_TABLE
94: , p5_a8 JTF_NUMBER_TABLE
95: , p5_a9 JTF_DATE_TABLE
96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 104: , p6_a7 out nocopy JTF_DATE_TABLE

100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , p6_a4 out nocopy JTF_NUMBER_TABLE
102: , p6_a5 out nocopy JTF_NUMBER_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE
104: , p6_a7 out nocopy JTF_DATE_TABLE
105: , p6_a8 out nocopy JTF_NUMBER_TABLE
106: , p6_a9 out nocopy JTF_DATE_TABLE
107: , p6_a10 out nocopy JTF_NUMBER_TABLE
108: , p7_a0 in out nocopy JTF_NUMBER_TABLE

Line 106: , p6_a9 out nocopy JTF_DATE_TABLE

102: , p6_a5 out nocopy JTF_NUMBER_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE
104: , p6_a7 out nocopy JTF_DATE_TABLE
105: , p6_a8 out nocopy JTF_NUMBER_TABLE
106: , p6_a9 out nocopy JTF_DATE_TABLE
107: , p6_a10 out nocopy JTF_NUMBER_TABLE
108: , p7_a0 in out nocopy JTF_NUMBER_TABLE
109: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p7_a2 in out nocopy JTF_NUMBER_TABLE

Line 128: , p5_a7 JTF_DATE_TABLE

124: , p5_a3 JTF_VARCHAR2_TABLE_100
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_NUMBER_TABLE
127: , p5_a6 JTF_NUMBER_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_NUMBER_TABLE
130: , p5_a9 JTF_DATE_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 130: , p5_a9 JTF_DATE_TABLE

126: , p5_a5 JTF_NUMBER_TABLE
127: , p5_a6 JTF_NUMBER_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_NUMBER_TABLE
130: , p5_a9 JTF_DATE_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p6_a0 out nocopy JTF_NUMBER_TABLE
133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 139: , p6_a7 out nocopy JTF_DATE_TABLE

135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a4 out nocopy JTF_NUMBER_TABLE
137: , p6_a5 out nocopy JTF_NUMBER_TABLE
138: , p6_a6 out nocopy JTF_NUMBER_TABLE
139: , p6_a7 out nocopy JTF_DATE_TABLE
140: , p6_a8 out nocopy JTF_NUMBER_TABLE
141: , p6_a9 out nocopy JTF_DATE_TABLE
142: , p6_a10 out nocopy JTF_NUMBER_TABLE
143: );

Line 141: , p6_a9 out nocopy JTF_DATE_TABLE

137: , p6_a5 out nocopy JTF_NUMBER_TABLE
138: , p6_a6 out nocopy JTF_NUMBER_TABLE
139: , p6_a7 out nocopy JTF_DATE_TABLE
140: , p6_a8 out nocopy JTF_NUMBER_TABLE
141: , p6_a9 out nocopy JTF_DATE_TABLE
142: , p6_a10 out nocopy JTF_NUMBER_TABLE
143: );
144: procedure lock_row(p_api_version NUMBER
145: , p_init_msg_list VARCHAR2

Line 173: , p5_a7 JTF_DATE_TABLE

169: , p5_a3 JTF_VARCHAR2_TABLE_100
170: , p5_a4 JTF_NUMBER_TABLE
171: , p5_a5 JTF_NUMBER_TABLE
172: , p5_a6 JTF_NUMBER_TABLE
173: , p5_a7 JTF_DATE_TABLE
174: , p5_a8 JTF_NUMBER_TABLE
175: , p5_a9 JTF_DATE_TABLE
176: , p5_a10 JTF_NUMBER_TABLE
177: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 175: , p5_a9 JTF_DATE_TABLE

171: , p5_a5 JTF_NUMBER_TABLE
172: , p5_a6 JTF_NUMBER_TABLE
173: , p5_a7 JTF_DATE_TABLE
174: , p5_a8 JTF_NUMBER_TABLE
175: , p5_a9 JTF_DATE_TABLE
176: , p5_a10 JTF_NUMBER_TABLE
177: , p6_a0 in out nocopy JTF_NUMBER_TABLE
178: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a2 in out nocopy JTF_NUMBER_TABLE

Line 197: , p5_a7 JTF_DATE_TABLE

193: , p5_a3 JTF_VARCHAR2_TABLE_100
194: , p5_a4 JTF_NUMBER_TABLE
195: , p5_a5 JTF_NUMBER_TABLE
196: , p5_a6 JTF_NUMBER_TABLE
197: , p5_a7 JTF_DATE_TABLE
198: , p5_a8 JTF_NUMBER_TABLE
199: , p5_a9 JTF_DATE_TABLE
200: , p5_a10 JTF_NUMBER_TABLE
201: );

Line 199: , p5_a9 JTF_DATE_TABLE

195: , p5_a5 JTF_NUMBER_TABLE
196: , p5_a6 JTF_NUMBER_TABLE
197: , p5_a7 JTF_DATE_TABLE
198: , p5_a8 JTF_NUMBER_TABLE
199: , p5_a9 JTF_DATE_TABLE
200: , p5_a10 JTF_NUMBER_TABLE
201: );
202: procedure update_row(p_api_version NUMBER
203: , p_init_msg_list VARCHAR2

Line 242: , p5_a7 JTF_DATE_TABLE

238: , p5_a3 JTF_VARCHAR2_TABLE_100
239: , p5_a4 JTF_NUMBER_TABLE
240: , p5_a5 JTF_NUMBER_TABLE
241: , p5_a6 JTF_NUMBER_TABLE
242: , p5_a7 JTF_DATE_TABLE
243: , p5_a8 JTF_NUMBER_TABLE
244: , p5_a9 JTF_DATE_TABLE
245: , p5_a10 JTF_NUMBER_TABLE
246: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 244: , p5_a9 JTF_DATE_TABLE

240: , p5_a5 JTF_NUMBER_TABLE
241: , p5_a6 JTF_NUMBER_TABLE
242: , p5_a7 JTF_DATE_TABLE
243: , p5_a8 JTF_NUMBER_TABLE
244: , p5_a9 JTF_DATE_TABLE
245: , p5_a10 JTF_NUMBER_TABLE
246: , p6_a0 out nocopy JTF_NUMBER_TABLE
247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 253: , p6_a7 out nocopy JTF_DATE_TABLE

249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
250: , p6_a4 out nocopy JTF_NUMBER_TABLE
251: , p6_a5 out nocopy JTF_NUMBER_TABLE
252: , p6_a6 out nocopy JTF_NUMBER_TABLE
253: , p6_a7 out nocopy JTF_DATE_TABLE
254: , p6_a8 out nocopy JTF_NUMBER_TABLE
255: , p6_a9 out nocopy JTF_DATE_TABLE
256: , p6_a10 out nocopy JTF_NUMBER_TABLE
257: , p7_a0 in out nocopy JTF_NUMBER_TABLE

Line 255: , p6_a9 out nocopy JTF_DATE_TABLE

251: , p6_a5 out nocopy JTF_NUMBER_TABLE
252: , p6_a6 out nocopy JTF_NUMBER_TABLE
253: , p6_a7 out nocopy JTF_DATE_TABLE
254: , p6_a8 out nocopy JTF_NUMBER_TABLE
255: , p6_a9 out nocopy JTF_DATE_TABLE
256: , p6_a10 out nocopy JTF_NUMBER_TABLE
257: , p7_a0 in out nocopy JTF_NUMBER_TABLE
258: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p7_a2 in out nocopy JTF_NUMBER_TABLE

Line 277: , p5_a7 JTF_DATE_TABLE

273: , p5_a3 JTF_VARCHAR2_TABLE_100
274: , p5_a4 JTF_NUMBER_TABLE
275: , p5_a5 JTF_NUMBER_TABLE
276: , p5_a6 JTF_NUMBER_TABLE
277: , p5_a7 JTF_DATE_TABLE
278: , p5_a8 JTF_NUMBER_TABLE
279: , p5_a9 JTF_DATE_TABLE
280: , p5_a10 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 279: , p5_a9 JTF_DATE_TABLE

275: , p5_a5 JTF_NUMBER_TABLE
276: , p5_a6 JTF_NUMBER_TABLE
277: , p5_a7 JTF_DATE_TABLE
278: , p5_a8 JTF_NUMBER_TABLE
279: , p5_a9 JTF_DATE_TABLE
280: , p5_a10 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 288: , p6_a7 out nocopy JTF_DATE_TABLE

284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a4 out nocopy JTF_NUMBER_TABLE
286: , p6_a5 out nocopy JTF_NUMBER_TABLE
287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_DATE_TABLE
289: , p6_a8 out nocopy JTF_NUMBER_TABLE
290: , p6_a9 out nocopy JTF_DATE_TABLE
291: , p6_a10 out nocopy JTF_NUMBER_TABLE
292: );

Line 290: , p6_a9 out nocopy JTF_DATE_TABLE

286: , p6_a5 out nocopy JTF_NUMBER_TABLE
287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_DATE_TABLE
289: , p6_a8 out nocopy JTF_NUMBER_TABLE
290: , p6_a9 out nocopy JTF_DATE_TABLE
291: , p6_a10 out nocopy JTF_NUMBER_TABLE
292: );
293: procedure delete_row(p_api_version NUMBER
294: , p_init_msg_list VARCHAR2

Line 322: , p5_a7 JTF_DATE_TABLE

318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_NUMBER_TABLE
321: , p5_a6 JTF_NUMBER_TABLE
322: , p5_a7 JTF_DATE_TABLE
323: , p5_a8 JTF_NUMBER_TABLE
324: , p5_a9 JTF_DATE_TABLE
325: , p5_a10 JTF_NUMBER_TABLE
326: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 324: , p5_a9 JTF_DATE_TABLE

320: , p5_a5 JTF_NUMBER_TABLE
321: , p5_a6 JTF_NUMBER_TABLE
322: , p5_a7 JTF_DATE_TABLE
323: , p5_a8 JTF_NUMBER_TABLE
324: , p5_a9 JTF_DATE_TABLE
325: , p5_a10 JTF_NUMBER_TABLE
326: , p6_a0 in out nocopy JTF_NUMBER_TABLE
327: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 in out nocopy JTF_NUMBER_TABLE

Line 346: , p5_a7 JTF_DATE_TABLE

342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_NUMBER_TABLE
350: );

Line 348: , p5_a9 JTF_DATE_TABLE

344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_NUMBER_TABLE
350: );
351: procedure validate_row(p_api_version NUMBER
352: , p_init_msg_list VARCHAR2

Line 380: , p5_a7 JTF_DATE_TABLE

376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_NUMBER_TABLE
378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_NUMBER_TABLE
380: , p5_a7 JTF_DATE_TABLE
381: , p5_a8 JTF_NUMBER_TABLE
382: , p5_a9 JTF_DATE_TABLE
383: , p5_a10 JTF_NUMBER_TABLE
384: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 382: , p5_a9 JTF_DATE_TABLE

378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_NUMBER_TABLE
380: , p5_a7 JTF_DATE_TABLE
381: , p5_a8 JTF_NUMBER_TABLE
382: , p5_a9 JTF_DATE_TABLE
383: , p5_a10 JTF_NUMBER_TABLE
384: , p6_a0 in out nocopy JTF_NUMBER_TABLE
385: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p6_a2 in out nocopy JTF_NUMBER_TABLE

Line 404: , p5_a7 JTF_DATE_TABLE

400: , p5_a3 JTF_VARCHAR2_TABLE_100
401: , p5_a4 JTF_NUMBER_TABLE
402: , p5_a5 JTF_NUMBER_TABLE
403: , p5_a6 JTF_NUMBER_TABLE
404: , p5_a7 JTF_DATE_TABLE
405: , p5_a8 JTF_NUMBER_TABLE
406: , p5_a9 JTF_DATE_TABLE
407: , p5_a10 JTF_NUMBER_TABLE
408: );

Line 406: , p5_a9 JTF_DATE_TABLE

402: , p5_a5 JTF_NUMBER_TABLE
403: , p5_a6 JTF_NUMBER_TABLE
404: , p5_a7 JTF_DATE_TABLE
405: , p5_a8 JTF_NUMBER_TABLE
406: , p5_a9 JTF_DATE_TABLE
407: , p5_a10 JTF_NUMBER_TABLE
408: );
409: end okl_qls_pvt_w;