DBA Data[Home] [Help]

APPS.OKL_RSP_PVT_W dependencies on JTF_DATE_TABLE

Line 8: , a5 JTF_DATE_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
11: , a8 JTF_NUMBER_TABLE
12: );

Line 10: , a7 JTF_DATE_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
11: , a8 JTF_NUMBER_TABLE
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

Line 18: , a5 out nocopy JTF_DATE_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
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );

Line 20: , a7 out nocopy JTF_DATE_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
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure insert_row(p_api_version NUMBER

Line 58: , p5_a5 JTF_DATE_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
61: , p5_a8 JTF_NUMBER_TABLE
62: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 60: , p5_a7 JTF_DATE_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
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

Line 67: , p6_a5 out nocopy JTF_DATE_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
70: , p6_a8 out nocopy JTF_NUMBER_TABLE
71: , p7_a0 in out nocopy JTF_NUMBER_TABLE

Line 69: , p6_a7 out nocopy JTF_DATE_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
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

Line 89: , p5_a5 JTF_DATE_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
92: , p5_a8 JTF_NUMBER_TABLE
93: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 91: , p5_a7 JTF_DATE_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
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

Line 98: , p6_a5 out nocopy JTF_DATE_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
101: , p6_a8 out nocopy JTF_NUMBER_TABLE
102: );

Line 100: , p6_a7 out nocopy JTF_DATE_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
101: , p6_a8 out nocopy JTF_NUMBER_TABLE
102: );
103: procedure lock_row(p_api_version NUMBER
104: , p_init_msg_list VARCHAR2

Line 128: , p5_a5 JTF_DATE_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
131: , p5_a8 JTF_NUMBER_TABLE
132: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 130: , p5_a7 JTF_DATE_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
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

Line 150: , p5_a5 JTF_DATE_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
153: , p5_a8 JTF_NUMBER_TABLE
154: );

Line 152: , p5_a7 JTF_DATE_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
153: , p5_a8 JTF_NUMBER_TABLE
154: );
155: procedure update_row(p_api_version NUMBER
156: , p_init_msg_list VARCHAR2

Line 189: , p5_a5 JTF_DATE_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
192: , p5_a8 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 191: , p5_a7 JTF_DATE_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
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

Line 198: , p6_a5 out nocopy JTF_DATE_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
201: , p6_a8 out nocopy JTF_NUMBER_TABLE
202: , p7_a0 in out nocopy JTF_NUMBER_TABLE

Line 200: , p6_a7 out nocopy JTF_DATE_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
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

Line 220: , p5_a5 JTF_DATE_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
223: , p5_a8 JTF_NUMBER_TABLE
224: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 222: , p5_a7 JTF_DATE_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
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

Line 229: , p6_a5 out nocopy JTF_DATE_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
232: , p6_a8 out nocopy JTF_NUMBER_TABLE
233: );

Line 231: , p6_a7 out nocopy JTF_DATE_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
232: , p6_a8 out nocopy JTF_NUMBER_TABLE
233: );
234: procedure delete_row(p_api_version NUMBER
235: , p_init_msg_list VARCHAR2

Line 259: , p5_a5 JTF_DATE_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
262: , p5_a8 JTF_NUMBER_TABLE
263: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 261: , p5_a7 JTF_DATE_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
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

Line 281: , p5_a5 JTF_DATE_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
284: , p5_a8 JTF_NUMBER_TABLE
285: );

Line 283: , p5_a7 JTF_DATE_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
284: , p5_a8 JTF_NUMBER_TABLE
285: );
286: procedure validate_row(p_api_version NUMBER
287: , p_init_msg_list VARCHAR2

Line 311: , p5_a5 JTF_DATE_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
314: , p5_a8 JTF_NUMBER_TABLE
315: , p6_a0 in out nocopy JTF_NUMBER_TABLE

Line 313: , p5_a7 JTF_DATE_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
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

Line 333: , p5_a5 JTF_DATE_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
336: , p5_a8 JTF_NUMBER_TABLE
337: );

Line 335: , p5_a7 JTF_DATE_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
336: , p5_a8 JTF_NUMBER_TABLE
337: );
338: end okl_rsp_pvt_w;