DBA Data[Home] [Help]

APPS.LNS_CUSTOM_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200

Line 48: , a45 JTF_VARCHAR2_TABLE_100

44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_VARCHAR2_TABLE_100
51: );
52: procedure rosetta_table_copy_out_p1(t lns_custom_pub.custom_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 49: , a46 JTF_VARCHAR2_TABLE_100

45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_VARCHAR2_TABLE_100
51: );
52: procedure rosetta_table_copy_out_p1(t lns_custom_pub.custom_tbl, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE

Line 50: , a47 JTF_VARCHAR2_TABLE_100

46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_100
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_VARCHAR2_TABLE_100
51: );
52: procedure rosetta_table_copy_out_p1(t lns_custom_pub.custom_tbl, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
54: , a2 out nocopy JTF_NUMBER_TABLE

Line 68: , a16 out nocopy JTF_VARCHAR2_TABLE_100

64: , a12 out nocopy JTF_NUMBER_TABLE
65: , a13 out nocopy JTF_NUMBER_TABLE
66: , a14 out nocopy JTF_NUMBER_TABLE
67: , a15 out nocopy JTF_NUMBER_TABLE
68: , a16 out nocopy JTF_VARCHAR2_TABLE_100
69: , a17 out nocopy JTF_VARCHAR2_TABLE_200
70: , a18 out nocopy JTF_VARCHAR2_TABLE_200
71: , a19 out nocopy JTF_VARCHAR2_TABLE_200
72: , a20 out nocopy JTF_VARCHAR2_TABLE_200

Line 97: , a45 out nocopy JTF_VARCHAR2_TABLE_100

93: , a41 out nocopy JTF_NUMBER_TABLE
94: , a42 out nocopy JTF_NUMBER_TABLE
95: , a43 out nocopy JTF_NUMBER_TABLE
96: , a44 out nocopy JTF_NUMBER_TABLE
97: , a45 out nocopy JTF_VARCHAR2_TABLE_100
98: , a46 out nocopy JTF_VARCHAR2_TABLE_100
99: , a47 out nocopy JTF_VARCHAR2_TABLE_100
100: );
101:

Line 98: , a46 out nocopy JTF_VARCHAR2_TABLE_100

94: , a42 out nocopy JTF_NUMBER_TABLE
95: , a43 out nocopy JTF_NUMBER_TABLE
96: , a44 out nocopy JTF_NUMBER_TABLE
97: , a45 out nocopy JTF_VARCHAR2_TABLE_100
98: , a46 out nocopy JTF_VARCHAR2_TABLE_100
99: , a47 out nocopy JTF_VARCHAR2_TABLE_100
100: );
101:
102: procedure resetcustomschedule(p_loan_id NUMBER

Line 99: , a47 out nocopy JTF_VARCHAR2_TABLE_100

95: , a43 out nocopy JTF_NUMBER_TABLE
96: , a44 out nocopy JTF_NUMBER_TABLE
97: , a45 out nocopy JTF_VARCHAR2_TABLE_100
98: , a46 out nocopy JTF_VARCHAR2_TABLE_100
99: , a47 out nocopy JTF_VARCHAR2_TABLE_100
100: );
101:
102: procedure resetcustomschedule(p_loan_id NUMBER
103: , p_init_msg_list VARCHAR2

Line 126: , p0_a16 JTF_VARCHAR2_TABLE_100

122: , p0_a12 JTF_NUMBER_TABLE
123: , p0_a13 JTF_NUMBER_TABLE
124: , p0_a14 JTF_NUMBER_TABLE
125: , p0_a15 JTF_NUMBER_TABLE
126: , p0_a16 JTF_VARCHAR2_TABLE_100
127: , p0_a17 JTF_VARCHAR2_TABLE_200
128: , p0_a18 JTF_VARCHAR2_TABLE_200
129: , p0_a19 JTF_VARCHAR2_TABLE_200
130: , p0_a20 JTF_VARCHAR2_TABLE_200

Line 155: , p0_a45 JTF_VARCHAR2_TABLE_100

151: , p0_a41 JTF_NUMBER_TABLE
152: , p0_a42 JTF_NUMBER_TABLE
153: , p0_a43 JTF_NUMBER_TABLE
154: , p0_a44 JTF_NUMBER_TABLE
155: , p0_a45 JTF_VARCHAR2_TABLE_100
156: , p0_a46 JTF_VARCHAR2_TABLE_100
157: , p0_a47 JTF_VARCHAR2_TABLE_100
158: , p_loan_id NUMBER
159: , p_init_msg_list VARCHAR2

Line 156: , p0_a46 JTF_VARCHAR2_TABLE_100

152: , p0_a42 JTF_NUMBER_TABLE
153: , p0_a43 JTF_NUMBER_TABLE
154: , p0_a44 JTF_NUMBER_TABLE
155: , p0_a45 JTF_VARCHAR2_TABLE_100
156: , p0_a46 JTF_VARCHAR2_TABLE_100
157: , p0_a47 JTF_VARCHAR2_TABLE_100
158: , p_loan_id NUMBER
159: , p_init_msg_list VARCHAR2
160: , p_commit VARCHAR2

Line 157: , p0_a47 JTF_VARCHAR2_TABLE_100

153: , p0_a43 JTF_NUMBER_TABLE
154: , p0_a44 JTF_NUMBER_TABLE
155: , p0_a45 JTF_VARCHAR2_TABLE_100
156: , p0_a46 JTF_VARCHAR2_TABLE_100
157: , p0_a47 JTF_VARCHAR2_TABLE_100
158: , p_loan_id NUMBER
159: , p_init_msg_list VARCHAR2
160: , p_commit VARCHAR2
161: , x_return_status out nocopy VARCHAR2

Line 182: , p0_a16 JTF_VARCHAR2_TABLE_100

178: , p0_a12 JTF_NUMBER_TABLE
179: , p0_a13 JTF_NUMBER_TABLE
180: , p0_a14 JTF_NUMBER_TABLE
181: , p0_a15 JTF_NUMBER_TABLE
182: , p0_a16 JTF_VARCHAR2_TABLE_100
183: , p0_a17 JTF_VARCHAR2_TABLE_200
184: , p0_a18 JTF_VARCHAR2_TABLE_200
185: , p0_a19 JTF_VARCHAR2_TABLE_200
186: , p0_a20 JTF_VARCHAR2_TABLE_200

Line 211: , p0_a45 JTF_VARCHAR2_TABLE_100

207: , p0_a41 JTF_NUMBER_TABLE
208: , p0_a42 JTF_NUMBER_TABLE
209: , p0_a43 JTF_NUMBER_TABLE
210: , p0_a44 JTF_NUMBER_TABLE
211: , p0_a45 JTF_VARCHAR2_TABLE_100
212: , p0_a46 JTF_VARCHAR2_TABLE_100
213: , p0_a47 JTF_VARCHAR2_TABLE_100
214: , p_loan_id NUMBER
215: , p_init_msg_list VARCHAR2

Line 212: , p0_a46 JTF_VARCHAR2_TABLE_100

208: , p0_a42 JTF_NUMBER_TABLE
209: , p0_a43 JTF_NUMBER_TABLE
210: , p0_a44 JTF_NUMBER_TABLE
211: , p0_a45 JTF_VARCHAR2_TABLE_100
212: , p0_a46 JTF_VARCHAR2_TABLE_100
213: , p0_a47 JTF_VARCHAR2_TABLE_100
214: , p_loan_id NUMBER
215: , p_init_msg_list VARCHAR2
216: , p_commit VARCHAR2

Line 213: , p0_a47 JTF_VARCHAR2_TABLE_100

209: , p0_a43 JTF_NUMBER_TABLE
210: , p0_a44 JTF_NUMBER_TABLE
211: , p0_a45 JTF_VARCHAR2_TABLE_100
212: , p0_a46 JTF_VARCHAR2_TABLE_100
213: , p0_a47 JTF_VARCHAR2_TABLE_100
214: , p_loan_id NUMBER
215: , p_init_msg_list VARCHAR2
216: , p_commit VARCHAR2
217: , x_return_status out nocopy VARCHAR2

Line 343: , p0_a16 JTF_VARCHAR2_TABLE_100

339: , p0_a12 JTF_NUMBER_TABLE
340: , p0_a13 JTF_NUMBER_TABLE
341: , p0_a14 JTF_NUMBER_TABLE
342: , p0_a15 JTF_NUMBER_TABLE
343: , p0_a16 JTF_VARCHAR2_TABLE_100
344: , p0_a17 JTF_VARCHAR2_TABLE_200
345: , p0_a18 JTF_VARCHAR2_TABLE_200
346: , p0_a19 JTF_VARCHAR2_TABLE_200
347: , p0_a20 JTF_VARCHAR2_TABLE_200

Line 372: , p0_a45 JTF_VARCHAR2_TABLE_100

368: , p0_a41 JTF_NUMBER_TABLE
369: , p0_a42 JTF_NUMBER_TABLE
370: , p0_a43 JTF_NUMBER_TABLE
371: , p0_a44 JTF_NUMBER_TABLE
372: , p0_a45 JTF_VARCHAR2_TABLE_100
373: , p0_a46 JTF_VARCHAR2_TABLE_100
374: , p0_a47 JTF_VARCHAR2_TABLE_100
375: , p_loan_id NUMBER
376: , p_create_flag number

Line 373: , p0_a46 JTF_VARCHAR2_TABLE_100

369: , p0_a42 JTF_NUMBER_TABLE
370: , p0_a43 JTF_NUMBER_TABLE
371: , p0_a44 JTF_NUMBER_TABLE
372: , p0_a45 JTF_VARCHAR2_TABLE_100
373: , p0_a46 JTF_VARCHAR2_TABLE_100
374: , p0_a47 JTF_VARCHAR2_TABLE_100
375: , p_loan_id NUMBER
376: , p_create_flag number
377: , x_installment out nocopy NUMBER

Line 374: , p0_a47 JTF_VARCHAR2_TABLE_100

370: , p0_a43 JTF_NUMBER_TABLE
371: , p0_a44 JTF_NUMBER_TABLE
372: , p0_a45 JTF_VARCHAR2_TABLE_100
373: , p0_a46 JTF_VARCHAR2_TABLE_100
374: , p0_a47 JTF_VARCHAR2_TABLE_100
375: , p_loan_id NUMBER
376: , p_create_flag number
377: , x_installment out nocopy NUMBER
378: , x_return_status out nocopy VARCHAR2

Line 457: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100

453: , p7_a12 in out nocopy JTF_NUMBER_TABLE
454: , p7_a13 in out nocopy JTF_NUMBER_TABLE
455: , p7_a14 in out nocopy JTF_NUMBER_TABLE
456: , p7_a15 in out nocopy JTF_NUMBER_TABLE
457: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
458: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
459: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
460: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
461: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200

Line 486: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100

482: , p7_a41 in out nocopy JTF_NUMBER_TABLE
483: , p7_a42 in out nocopy JTF_NUMBER_TABLE
484: , p7_a43 in out nocopy JTF_NUMBER_TABLE
485: , p7_a44 in out nocopy JTF_NUMBER_TABLE
486: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
487: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
488: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
489: , x_return_status out nocopy VARCHAR2
490: , x_msg_count out nocopy NUMBER

Line 487: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100

483: , p7_a42 in out nocopy JTF_NUMBER_TABLE
484: , p7_a43 in out nocopy JTF_NUMBER_TABLE
485: , p7_a44 in out nocopy JTF_NUMBER_TABLE
486: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
487: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
488: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
489: , x_return_status out nocopy VARCHAR2
490: , x_msg_count out nocopy NUMBER
491: , x_msg_data out nocopy VARCHAR2

Line 488: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100

484: , p7_a43 in out nocopy JTF_NUMBER_TABLE
485: , p7_a44 in out nocopy JTF_NUMBER_TABLE
486: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
487: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
488: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
489: , x_return_status out nocopy VARCHAR2
490: , x_msg_count out nocopy NUMBER
491: , x_msg_data out nocopy VARCHAR2
492: );

Line 516: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

512: , p7_a12 out nocopy JTF_NUMBER_TABLE
513: , p7_a13 out nocopy JTF_NUMBER_TABLE
514: , p7_a14 out nocopy JTF_NUMBER_TABLE
515: , p7_a15 out nocopy JTF_NUMBER_TABLE
516: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
517: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
518: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_200
519: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_200
520: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_200

Line 545: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100

541: , p7_a41 out nocopy JTF_NUMBER_TABLE
542: , p7_a42 out nocopy JTF_NUMBER_TABLE
543: , p7_a43 out nocopy JTF_NUMBER_TABLE
544: , p7_a44 out nocopy JTF_NUMBER_TABLE
545: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
546: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER

Line 546: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100

542: , p7_a42 out nocopy JTF_NUMBER_TABLE
543: , p7_a43 out nocopy JTF_NUMBER_TABLE
544: , p7_a44 out nocopy JTF_NUMBER_TABLE
545: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
546: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2

Line 547: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100

543: , p7_a43 out nocopy JTF_NUMBER_TABLE
544: , p7_a44 out nocopy JTF_NUMBER_TABLE
545: , p7_a45 out nocopy JTF_VARCHAR2_TABLE_100
546: , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
551: );

Line 575: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100

571: , p7_a12 in out nocopy JTF_NUMBER_TABLE
572: , p7_a13 in out nocopy JTF_NUMBER_TABLE
573: , p7_a14 in out nocopy JTF_NUMBER_TABLE
574: , p7_a15 in out nocopy JTF_NUMBER_TABLE
575: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
576: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
577: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
578: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
579: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200

Line 604: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100

600: , p7_a41 in out nocopy JTF_NUMBER_TABLE
601: , p7_a42 in out nocopy JTF_NUMBER_TABLE
602: , p7_a43 in out nocopy JTF_NUMBER_TABLE
603: , p7_a44 in out nocopy JTF_NUMBER_TABLE
604: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
605: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
606: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER

Line 605: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100

601: , p7_a42 in out nocopy JTF_NUMBER_TABLE
602: , p7_a43 in out nocopy JTF_NUMBER_TABLE
603: , p7_a44 in out nocopy JTF_NUMBER_TABLE
604: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
605: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
606: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2

Line 606: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100

602: , p7_a43 in out nocopy JTF_NUMBER_TABLE
603: , p7_a44 in out nocopy JTF_NUMBER_TABLE
604: , p7_a45 in out nocopy JTF_VARCHAR2_TABLE_100
605: , p7_a46 in out nocopy JTF_VARCHAR2_TABLE_100
606: , p7_a47 in out nocopy JTF_VARCHAR2_TABLE_100
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: );

Line 636: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100

632: , p9_a12 in out nocopy JTF_NUMBER_TABLE
633: , p9_a13 in out nocopy JTF_NUMBER_TABLE
634: , p9_a14 in out nocopy JTF_NUMBER_TABLE
635: , p9_a15 in out nocopy JTF_NUMBER_TABLE
636: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
638: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
639: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
640: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200

Line 665: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100

661: , p9_a41 in out nocopy JTF_NUMBER_TABLE
662: , p9_a42 in out nocopy JTF_NUMBER_TABLE
663: , p9_a43 in out nocopy JTF_NUMBER_TABLE
664: , p9_a44 in out nocopy JTF_NUMBER_TABLE
665: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
668: , x_return_status out nocopy VARCHAR2
669: , x_msg_count out nocopy NUMBER

Line 666: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100

662: , p9_a42 in out nocopy JTF_NUMBER_TABLE
663: , p9_a43 in out nocopy JTF_NUMBER_TABLE
664: , p9_a44 in out nocopy JTF_NUMBER_TABLE
665: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
668: , x_return_status out nocopy VARCHAR2
669: , x_msg_count out nocopy NUMBER
670: , x_msg_data out nocopy VARCHAR2

Line 667: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100

663: , p9_a43 in out nocopy JTF_NUMBER_TABLE
664: , p9_a44 in out nocopy JTF_NUMBER_TABLE
665: , p9_a45 in out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a46 in out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a47 in out nocopy JTF_VARCHAR2_TABLE_100
668: , x_return_status out nocopy VARCHAR2
669: , x_msg_count out nocopy NUMBER
670: , x_msg_data out nocopy VARCHAR2
671: );