APPS.LNS_BILLING_BATCH_PUB_W dependencies on JTF_DATE_TABLE

Line 8: , a5 JTF_DATE_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_DATE_TABLE

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE

Line 10: , a7 JTF_DATE_TABLE

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

Line 28: , a25 JTF_DATE_TABLE

24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100

Line 46: , a5 out nocopy JTF_DATE_TABLE

42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_VARCHAR2_TABLE_100
44: , a3 out nocopy JTF_VARCHAR2_TABLE_300
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_DATE_TABLE
47: , a6 out nocopy JTF_DATE_TABLE
48: , a7 out nocopy JTF_DATE_TABLE
49: , a8 out nocopy JTF_VARCHAR2_TABLE_100
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a6 out nocopy JTF_DATE_TABLE

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

Line 48: , a7 out nocopy JTF_DATE_TABLE

44: , a3 out nocopy JTF_VARCHAR2_TABLE_300
45: , a4 out nocopy JTF_NUMBER_TABLE
46: , a5 out nocopy JTF_DATE_TABLE
47: , a6 out nocopy JTF_DATE_TABLE
48: , a7 out nocopy JTF_DATE_TABLE
49: , a8 out nocopy JTF_VARCHAR2_TABLE_100
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_NUMBER_TABLE
52: , a11 out nocopy JTF_NUMBER_TABLE

Line 66: , a25 out nocopy JTF_DATE_TABLE

62: , a21 out nocopy JTF_NUMBER_TABLE
63: , a22 out nocopy JTF_NUMBER_TABLE
64: , a23 out nocopy JTF_NUMBER_TABLE
65: , a24 out nocopy JTF_VARCHAR2_TABLE_100
66: , a25 out nocopy JTF_DATE_TABLE
67: , a26 out nocopy JTF_NUMBER_TABLE
68: , a27 out nocopy JTF_NUMBER_TABLE
69: , a28 out nocopy JTF_NUMBER_TABLE
70: , a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 102: , a3 JTF_DATE_TABLE

98:
99: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
100: , a1 JTF_NUMBER_TABLE
101: , a2 JTF_NUMBER_TABLE
102: , a3 JTF_DATE_TABLE
103: , a4 JTF_NUMBER_TABLE
104: , a5 JTF_NUMBER_TABLE
105: );
106: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 109: , a3 out nocopy JTF_DATE_TABLE

105: );
106: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_DATE_TABLE
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_NUMBER_TABLE
112: );
113:

Line 153: , a8 JTF_DATE_TABLE

149: , a4 JTF_VARCHAR2_TABLE_100
150: , a5 JTF_NUMBER_TABLE
151: , a6 JTF_NUMBER_TABLE
152: , a7 JTF_NUMBER_TABLE
153: , a8 JTF_DATE_TABLE
154: , a9 JTF_DATE_TABLE
155: , a10 JTF_DATE_TABLE
156: , a11 JTF_VARCHAR2_TABLE_100
157: , a12 JTF_VARCHAR2_TABLE_100

Line 154: , a9 JTF_DATE_TABLE

150: , a5 JTF_NUMBER_TABLE
151: , a6 JTF_NUMBER_TABLE
152: , a7 JTF_NUMBER_TABLE
153: , a8 JTF_DATE_TABLE
154: , a9 JTF_DATE_TABLE
155: , a10 JTF_DATE_TABLE
156: , a11 JTF_VARCHAR2_TABLE_100
157: , a12 JTF_VARCHAR2_TABLE_100
158: , a13 JTF_VARCHAR2_TABLE_100

Line 155: , a10 JTF_DATE_TABLE

151: , a6 JTF_NUMBER_TABLE
152: , a7 JTF_NUMBER_TABLE
153: , a8 JTF_DATE_TABLE
154: , a9 JTF_DATE_TABLE
155: , a10 JTF_DATE_TABLE
156: , a11 JTF_VARCHAR2_TABLE_100
157: , a12 JTF_VARCHAR2_TABLE_100
158: , a13 JTF_VARCHAR2_TABLE_100
159: , a14 JTF_NUMBER_TABLE

Line 169: , a8 out nocopy JTF_DATE_TABLE

165: , a4 out nocopy JTF_VARCHAR2_TABLE_100
166: , a5 out nocopy JTF_NUMBER_TABLE
167: , a6 out nocopy JTF_NUMBER_TABLE
168: , a7 out nocopy JTF_NUMBER_TABLE
169: , a8 out nocopy JTF_DATE_TABLE
170: , a9 out nocopy JTF_DATE_TABLE
171: , a10 out nocopy JTF_DATE_TABLE
172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
173: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 170: , a9 out nocopy JTF_DATE_TABLE

166: , a5 out nocopy JTF_NUMBER_TABLE
167: , a6 out nocopy JTF_NUMBER_TABLE
168: , a7 out nocopy JTF_NUMBER_TABLE
169: , a8 out nocopy JTF_DATE_TABLE
170: , a9 out nocopy JTF_DATE_TABLE
171: , a10 out nocopy JTF_DATE_TABLE
172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
173: , a12 out nocopy JTF_VARCHAR2_TABLE_100
174: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 171: , a10 out nocopy JTF_DATE_TABLE

167: , a6 out nocopy JTF_NUMBER_TABLE
168: , a7 out nocopy JTF_NUMBER_TABLE
169: , a8 out nocopy JTF_DATE_TABLE
170: , a9 out nocopy JTF_DATE_TABLE
171: , a10 out nocopy JTF_DATE_TABLE
172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
173: , a12 out nocopy JTF_VARCHAR2_TABLE_100
174: , a13 out nocopy JTF_VARCHAR2_TABLE_100
175: , a14 out nocopy JTF_NUMBER_TABLE

Line 182: , a4 JTF_DATE_TABLE

178: procedure rosetta_table_copy_in_p12(t out nocopy lns_billing_batch_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
179: , a1 JTF_NUMBER_TABLE
180: , a2 JTF_VARCHAR2_TABLE_100
181: , a3 JTF_NUMBER_TABLE
182: , a4 JTF_DATE_TABLE
183: , a5 JTF_VARCHAR2_TABLE_100
184: , a6 JTF_VARCHAR2_TABLE_100
185: , a7 JTF_VARCHAR2_TABLE_100
186: , a8 JTF_DATE_TABLE

Line 186: , a8 JTF_DATE_TABLE

182: , a4 JTF_DATE_TABLE
183: , a5 JTF_VARCHAR2_TABLE_100
184: , a6 JTF_VARCHAR2_TABLE_100
185: , a7 JTF_VARCHAR2_TABLE_100
186: , a8 JTF_DATE_TABLE
187: , a9 JTF_DATE_TABLE
188: );
189: procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
190: , a1 out nocopy JTF_NUMBER_TABLE

Line 187: , a9 JTF_DATE_TABLE

183: , a5 JTF_VARCHAR2_TABLE_100
184: , a6 JTF_VARCHAR2_TABLE_100
185: , a7 JTF_VARCHAR2_TABLE_100
186: , a8 JTF_DATE_TABLE
187: , a9 JTF_DATE_TABLE
188: );
189: procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
190: , a1 out nocopy JTF_NUMBER_TABLE
191: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 193: , a4 out nocopy JTF_DATE_TABLE

189: procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
190: , a1 out nocopy JTF_NUMBER_TABLE
191: , a2 out nocopy JTF_VARCHAR2_TABLE_100
192: , a3 out nocopy JTF_NUMBER_TABLE
193: , a4 out nocopy JTF_DATE_TABLE
194: , a5 out nocopy JTF_VARCHAR2_TABLE_100
195: , a6 out nocopy JTF_VARCHAR2_TABLE_100
196: , a7 out nocopy JTF_VARCHAR2_TABLE_100
197: , a8 out nocopy JTF_DATE_TABLE

Line 197: , a8 out nocopy JTF_DATE_TABLE

193: , a4 out nocopy JTF_DATE_TABLE
194: , a5 out nocopy JTF_VARCHAR2_TABLE_100
195: , a6 out nocopy JTF_VARCHAR2_TABLE_100
196: , a7 out nocopy JTF_VARCHAR2_TABLE_100
197: , a8 out nocopy JTF_DATE_TABLE
198: , a9 out nocopy JTF_DATE_TABLE
199: );
200:
201: procedure rosetta_table_copy_in_p13(t out nocopy lns_billing_batch_pub.amortization_sched_tbl, a0 JTF_NUMBER_TABLE);

Line 198: , a9 out nocopy JTF_DATE_TABLE

194: , a5 out nocopy JTF_VARCHAR2_TABLE_100
195: , a6 out nocopy JTF_VARCHAR2_TABLE_100
196: , a7 out nocopy JTF_VARCHAR2_TABLE_100
197: , a8 out nocopy JTF_DATE_TABLE
198: , a9 out nocopy JTF_DATE_TABLE
199: );
200:
201: procedure rosetta_table_copy_in_p13(t out nocopy lns_billing_batch_pub.amortization_sched_tbl, a0 JTF_NUMBER_TABLE);
202: procedure rosetta_table_copy_out_p13(t lns_billing_batch_pub.amortization_sched_tbl, a0 out nocopy JTF_NUMBER_TABLE);

Line 239: , p4_a3 JTF_DATE_TABLE

235: , p_validation_level NUMBER
236: , p4_a0 JTF_NUMBER_TABLE
237: , p4_a1 JTF_NUMBER_TABLE
238: , p4_a2 JTF_NUMBER_TABLE
239: , p4_a3 JTF_DATE_TABLE
240: , p4_a4 JTF_NUMBER_TABLE
241: , p4_a5 JTF_NUMBER_TABLE
242: , p5_a0 JTF_NUMBER_TABLE
243: , p5_a1 JTF_NUMBER_TABLE

Line 273: , p5_a8 out nocopy JTF_DATE_TABLE

269: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
270: , p5_a5 out nocopy JTF_NUMBER_TABLE
271: , p5_a6 out nocopy JTF_NUMBER_TABLE
272: , p5_a7 out nocopy JTF_NUMBER_TABLE
273: , p5_a8 out nocopy JTF_DATE_TABLE
274: , p5_a9 out nocopy JTF_DATE_TABLE
275: , p5_a10 out nocopy JTF_DATE_TABLE
276: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
277: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 274: , p5_a9 out nocopy JTF_DATE_TABLE

270: , p5_a5 out nocopy JTF_NUMBER_TABLE
271: , p5_a6 out nocopy JTF_NUMBER_TABLE
272: , p5_a7 out nocopy JTF_NUMBER_TABLE
273: , p5_a8 out nocopy JTF_DATE_TABLE
274: , p5_a9 out nocopy JTF_DATE_TABLE
275: , p5_a10 out nocopy JTF_DATE_TABLE
276: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
277: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
278: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 275: , p5_a10 out nocopy JTF_DATE_TABLE

271: , p5_a6 out nocopy JTF_NUMBER_TABLE
272: , p5_a7 out nocopy JTF_NUMBER_TABLE
273: , p5_a8 out nocopy JTF_DATE_TABLE
274: , p5_a9 out nocopy JTF_DATE_TABLE
275: , p5_a10 out nocopy JTF_DATE_TABLE
276: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
277: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
278: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
279: , p5_a14 out nocopy JTF_NUMBER_TABLE

Line 293: , p5_a4 JTF_DATE_TABLE

289: , p5_a0 JTF_NUMBER_TABLE
290: , p5_a1 JTF_NUMBER_TABLE
291: , p5_a2 JTF_VARCHAR2_TABLE_100
292: , p5_a3 JTF_NUMBER_TABLE
293: , p5_a4 JTF_DATE_TABLE
294: , p5_a5 JTF_VARCHAR2_TABLE_100
295: , p5_a6 JTF_VARCHAR2_TABLE_100
296: , p5_a7 JTF_VARCHAR2_TABLE_100
297: , p5_a8 JTF_DATE_TABLE

Line 297: , p5_a8 JTF_DATE_TABLE

293: , p5_a4 JTF_DATE_TABLE
294: , p5_a5 JTF_VARCHAR2_TABLE_100
295: , p5_a6 JTF_VARCHAR2_TABLE_100
296: , p5_a7 JTF_VARCHAR2_TABLE_100
297: , p5_a8 JTF_DATE_TABLE
298: , p5_a9 JTF_DATE_TABLE
299: , x_return_status out nocopy VARCHAR2
300: , x_msg_count out nocopy NUMBER
301: , x_msg_data out nocopy VARCHAR2

Line 298: , p5_a9 JTF_DATE_TABLE

294: , p5_a5 JTF_VARCHAR2_TABLE_100
295: , p5_a6 JTF_VARCHAR2_TABLE_100
296: , p5_a7 JTF_VARCHAR2_TABLE_100
297: , p5_a8 JTF_DATE_TABLE
298: , p5_a9 JTF_DATE_TABLE
299: , x_return_status out nocopy VARCHAR2
300: , x_msg_count out nocopy NUMBER
301: , x_msg_data out nocopy VARCHAR2
302: );

Line 313: , p6_a4 JTF_DATE_TABLE

309: , p6_a0 JTF_NUMBER_TABLE
310: , p6_a1 JTF_NUMBER_TABLE
311: , p6_a2 JTF_VARCHAR2_TABLE_100
312: , p6_a3 JTF_NUMBER_TABLE
313: , p6_a4 JTF_DATE_TABLE
314: , p6_a5 JTF_VARCHAR2_TABLE_100
315: , p6_a6 JTF_VARCHAR2_TABLE_100
316: , p6_a7 JTF_VARCHAR2_TABLE_100
317: , p6_a8 JTF_DATE_TABLE

Line 317: , p6_a8 JTF_DATE_TABLE

313: , p6_a4 JTF_DATE_TABLE
314: , p6_a5 JTF_VARCHAR2_TABLE_100
315: , p6_a6 JTF_VARCHAR2_TABLE_100
316: , p6_a7 JTF_VARCHAR2_TABLE_100
317: , p6_a8 JTF_DATE_TABLE
318: , p6_a9 JTF_DATE_TABLE
319: , x_return_status out nocopy VARCHAR2
320: , x_msg_count out nocopy NUMBER
321: , x_msg_data out nocopy VARCHAR2

Line 318: , p6_a9 JTF_DATE_TABLE

314: , p6_a5 JTF_VARCHAR2_TABLE_100
315: , p6_a6 JTF_VARCHAR2_TABLE_100
316: , p6_a7 JTF_VARCHAR2_TABLE_100
317: , p6_a8 JTF_DATE_TABLE
318: , p6_a9 JTF_DATE_TABLE
319: , x_return_status out nocopy VARCHAR2
320: , x_msg_count out nocopy NUMBER
321: , x_msg_data out nocopy VARCHAR2
322: );

Line 340: , p6_a8 out nocopy JTF_DATE_TABLE

336: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a5 out nocopy JTF_NUMBER_TABLE
338: , p6_a6 out nocopy JTF_NUMBER_TABLE
339: , p6_a7 out nocopy JTF_NUMBER_TABLE
340: , p6_a8 out nocopy JTF_DATE_TABLE
341: , p6_a9 out nocopy JTF_DATE_TABLE
342: , p6_a10 out nocopy JTF_DATE_TABLE
343: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 341: , p6_a9 out nocopy JTF_DATE_TABLE

337: , p6_a5 out nocopy JTF_NUMBER_TABLE
338: , p6_a6 out nocopy JTF_NUMBER_TABLE
339: , p6_a7 out nocopy JTF_NUMBER_TABLE
340: , p6_a8 out nocopy JTF_DATE_TABLE
341: , p6_a9 out nocopy JTF_DATE_TABLE
342: , p6_a10 out nocopy JTF_DATE_TABLE
343: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 342: , p6_a10 out nocopy JTF_DATE_TABLE

338: , p6_a6 out nocopy JTF_NUMBER_TABLE
339: , p6_a7 out nocopy JTF_NUMBER_TABLE
340: , p6_a8 out nocopy JTF_DATE_TABLE
341: , p6_a9 out nocopy JTF_DATE_TABLE
342: , p6_a10 out nocopy JTF_DATE_TABLE
343: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 359: , p5_a3 JTF_DATE_TABLE

355: , p_loan_id NUMBER
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_DATE_TABLE
360: , p5_a4 JTF_NUMBER_TABLE
361: , p5_a5 JTF_NUMBER_TABLE
362: , p6_a0 JTF_NUMBER_TABLE
363: , p6_a1 JTF_NUMBER_TABLE

Line 380: , p7_a4 JTF_DATE_TABLE

376: , p7_a0 JTF_NUMBER_TABLE
377: , p7_a1 JTF_NUMBER_TABLE
378: , p7_a2 JTF_VARCHAR2_TABLE_100
379: , p7_a3 JTF_NUMBER_TABLE
380: , p7_a4 JTF_DATE_TABLE
381: , p7_a5 JTF_VARCHAR2_TABLE_100
382: , p7_a6 JTF_VARCHAR2_TABLE_100
383: , p7_a7 JTF_VARCHAR2_TABLE_100
384: , p7_a8 JTF_DATE_TABLE

Line 384: , p7_a8 JTF_DATE_TABLE

380: , p7_a4 JTF_DATE_TABLE
381: , p7_a5 JTF_VARCHAR2_TABLE_100
382: , p7_a6 JTF_VARCHAR2_TABLE_100
383: , p7_a7 JTF_VARCHAR2_TABLE_100
384: , p7_a8 JTF_DATE_TABLE
385: , p7_a9 JTF_DATE_TABLE
386: , x_return_status out nocopy VARCHAR2
387: , x_msg_count out nocopy NUMBER
388: , x_msg_data out nocopy VARCHAR2

Line 385: , p7_a9 JTF_DATE_TABLE

381: , p7_a5 JTF_VARCHAR2_TABLE_100
382: , p7_a6 JTF_VARCHAR2_TABLE_100
383: , p7_a7 JTF_VARCHAR2_TABLE_100
384: , p7_a8 JTF_DATE_TABLE
385: , p7_a9 JTF_DATE_TABLE
386: , x_return_status out nocopy VARCHAR2
387: , x_msg_count out nocopy NUMBER
388: , x_msg_data out nocopy VARCHAR2
389: );