1: package lns_distributions_pub_w as
2: /* $Header: LNS_DIST_PUBJ_S.pls 120.4 2005/09/01 08:34 raverma noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_distributions_pub.distribution_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package lns_distributions_pub_w as
2: /* $Header: LNS_DIST_PUBJ_S.pls 120.4 2005/09/01 08:34 raverma noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_distributions_pub.distribution_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_distributions_pub.distribution_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_VARCHAR2_TABLE_100
16: procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_VARCHAR2_TABLE_100
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_NUMBER_TABLE
24: , a8 out nocopy JTF_VARCHAR2_TABLE_100
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_VARCHAR2_TABLE_100
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_NUMBER_TABLE
24: , a8 out nocopy JTF_VARCHAR2_TABLE_100
25: , a9 out nocopy JTF_VARCHAR2_TABLE_100
26: , a10 out nocopy JTF_NUMBER_TABLE
19: , a3 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_NUMBER_TABLE
21: , a5 out nocopy JTF_VARCHAR2_TABLE_100
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_NUMBER_TABLE
24: , a8 out nocopy JTF_VARCHAR2_TABLE_100
25: , a9 out nocopy JTF_VARCHAR2_TABLE_100
26: , a10 out nocopy JTF_NUMBER_TABLE
27: , a11 out nocopy JTF_NUMBER_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_NUMBER_TABLE
24: , a8 out nocopy JTF_VARCHAR2_TABLE_100
25: , a9 out nocopy JTF_VARCHAR2_TABLE_100
26: , a10 out nocopy JTF_NUMBER_TABLE
27: , a11 out nocopy JTF_NUMBER_TABLE
28: );
29:
30: procedure rosetta_table_copy_in_p3(t out nocopy lns_distributions_pub.default_distributions_tbl, a0 JTF_VARCHAR2_TABLE_100
23: , a7 out nocopy JTF_NUMBER_TABLE
24: , a8 out nocopy JTF_VARCHAR2_TABLE_100
25: , a9 out nocopy JTF_VARCHAR2_TABLE_100
26: , a10 out nocopy JTF_NUMBER_TABLE
27: , a11 out nocopy JTF_NUMBER_TABLE
28: );
29:
30: procedure rosetta_table_copy_in_p3(t out nocopy lns_distributions_pub.default_distributions_tbl, a0 JTF_VARCHAR2_TABLE_100
31: , a1 JTF_VARCHAR2_TABLE_100
30: procedure rosetta_table_copy_in_p3(t out nocopy lns_distributions_pub.default_distributions_tbl, a0 JTF_VARCHAR2_TABLE_100
31: , a1 JTF_VARCHAR2_TABLE_100
32: , a2 JTF_VARCHAR2_TABLE_100
33: , a3 JTF_VARCHAR2_TABLE_100
34: , a4 JTF_NUMBER_TABLE
35: , a5 JTF_VARCHAR2_TABLE_100
36: , a6 JTF_NUMBER_TABLE
37: , a7 JTF_VARCHAR2_TABLE_100
38: , a8 JTF_NUMBER_TABLE
32: , a2 JTF_VARCHAR2_TABLE_100
33: , a3 JTF_VARCHAR2_TABLE_100
34: , a4 JTF_NUMBER_TABLE
35: , a5 JTF_VARCHAR2_TABLE_100
36: , a6 JTF_NUMBER_TABLE
37: , a7 JTF_VARCHAR2_TABLE_100
38: , a8 JTF_NUMBER_TABLE
39: , a9 JTF_NUMBER_TABLE
40: , a10 JTF_VARCHAR2_TABLE_100
34: , a4 JTF_NUMBER_TABLE
35: , a5 JTF_VARCHAR2_TABLE_100
36: , a6 JTF_NUMBER_TABLE
37: , a7 JTF_VARCHAR2_TABLE_100
38: , a8 JTF_NUMBER_TABLE
39: , a9 JTF_NUMBER_TABLE
40: , a10 JTF_VARCHAR2_TABLE_100
41: , a11 JTF_VARCHAR2_TABLE_100
42: , a12 JTF_VARCHAR2_TABLE_100
35: , a5 JTF_VARCHAR2_TABLE_100
36: , a6 JTF_NUMBER_TABLE
37: , a7 JTF_VARCHAR2_TABLE_100
38: , a8 JTF_NUMBER_TABLE
39: , a9 JTF_NUMBER_TABLE
40: , a10 JTF_VARCHAR2_TABLE_100
41: , a11 JTF_VARCHAR2_TABLE_100
42: , a12 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p3(t lns_distributions_pub.default_distributions_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
45: , a1 out nocopy JTF_VARCHAR2_TABLE_100
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
52: , a8 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: );
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: );
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy lns_distributions_pub.acc_event_tbl, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_100
61: , a2 JTF_DATE_TABLE
62: , a3 JTF_VARCHAR2_TABLE_100
63: , a4 JTF_NUMBER_TABLE
59: procedure rosetta_table_copy_in_p5(t out nocopy lns_distributions_pub.acc_event_tbl, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_100
61: , a2 JTF_DATE_TABLE
62: , a3 JTF_VARCHAR2_TABLE_100
63: , a4 JTF_NUMBER_TABLE
64: );
65: procedure rosetta_table_copy_out_p5(t lns_distributions_pub.acc_event_tbl, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , a2 out nocopy JTF_DATE_TABLE
61: , a2 JTF_DATE_TABLE
62: , a3 JTF_VARCHAR2_TABLE_100
63: , a4 JTF_NUMBER_TABLE
64: );
65: procedure rosetta_table_copy_out_p5(t lns_distributions_pub.acc_event_tbl, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , a2 out nocopy JTF_DATE_TABLE
68: , a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , a4 out nocopy JTF_NUMBER_TABLE
65: procedure rosetta_table_copy_out_p5(t lns_distributions_pub.acc_event_tbl, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , a2 out nocopy JTF_DATE_TABLE
68: , a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , a4 out nocopy JTF_NUMBER_TABLE
70: );
71:
72: procedure rosetta_table_copy_in_p6(t out nocopy lns_distributions_pub.g_number_tbl, a0 JTF_NUMBER_TABLE);
73: procedure rosetta_table_copy_out_p6(t lns_distributions_pub.g_number_tbl, a0 out nocopy JTF_NUMBER_TABLE);
68: , a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , a4 out nocopy JTF_NUMBER_TABLE
70: );
71:
72: procedure rosetta_table_copy_in_p6(t out nocopy lns_distributions_pub.g_number_tbl, a0 JTF_NUMBER_TABLE);
73: procedure rosetta_table_copy_out_p6(t lns_distributions_pub.g_number_tbl, a0 out nocopy JTF_NUMBER_TABLE);
74:
75: procedure create_event(p0_a0 JTF_NUMBER_TABLE
76: , p0_a1 JTF_VARCHAR2_TABLE_100
69: , a4 out nocopy JTF_NUMBER_TABLE
70: );
71:
72: procedure rosetta_table_copy_in_p6(t out nocopy lns_distributions_pub.g_number_tbl, a0 JTF_NUMBER_TABLE);
73: procedure rosetta_table_copy_out_p6(t lns_distributions_pub.g_number_tbl, a0 out nocopy JTF_NUMBER_TABLE);
74:
75: procedure create_event(p0_a0 JTF_NUMBER_TABLE
76: , p0_a1 JTF_VARCHAR2_TABLE_100
77: , p0_a2 JTF_DATE_TABLE
71:
72: procedure rosetta_table_copy_in_p6(t out nocopy lns_distributions_pub.g_number_tbl, a0 JTF_NUMBER_TABLE);
73: procedure rosetta_table_copy_out_p6(t lns_distributions_pub.g_number_tbl, a0 out nocopy JTF_NUMBER_TABLE);
74:
75: procedure create_event(p0_a0 JTF_NUMBER_TABLE
76: , p0_a1 JTF_VARCHAR2_TABLE_100
77: , p0_a2 JTF_DATE_TABLE
78: , p0_a3 JTF_VARCHAR2_TABLE_100
79: , p0_a4 JTF_NUMBER_TABLE
75: procedure create_event(p0_a0 JTF_NUMBER_TABLE
76: , p0_a1 JTF_VARCHAR2_TABLE_100
77: , p0_a2 JTF_DATE_TABLE
78: , p0_a3 JTF_VARCHAR2_TABLE_100
79: , p0_a4 JTF_NUMBER_TABLE
80: , p_init_msg_list VARCHAR2
81: , p_commit VARCHAR2
82: , x_return_status out nocopy VARCHAR2
83: , x_msg_count out nocopy NUMBER
89: , p_loan_id NUMBER
90: , p_disb_header_id NUMBER
91: , p_include_loan_receivables VARCHAR2
92: , p_distribution_type VARCHAR2
93: , p7_a0 out nocopy JTF_NUMBER_TABLE
94: , p7_a1 out nocopy JTF_NUMBER_TABLE
95: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p7_a4 out nocopy JTF_NUMBER_TABLE
90: , p_disb_header_id NUMBER
91: , p_include_loan_receivables VARCHAR2
92: , p_distribution_type VARCHAR2
93: , p7_a0 out nocopy JTF_NUMBER_TABLE
94: , p7_a1 out nocopy JTF_NUMBER_TABLE
95: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p7_a4 out nocopy JTF_NUMBER_TABLE
98: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
93: , p7_a0 out nocopy JTF_NUMBER_TABLE
94: , p7_a1 out nocopy JTF_NUMBER_TABLE
95: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p7_a4 out nocopy JTF_NUMBER_TABLE
98: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , p7_a6 out nocopy JTF_NUMBER_TABLE
100: , p7_a7 out nocopy JTF_NUMBER_TABLE
101: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
95: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p7_a4 out nocopy JTF_NUMBER_TABLE
98: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , p7_a6 out nocopy JTF_NUMBER_TABLE
100: , p7_a7 out nocopy JTF_NUMBER_TABLE
101: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
102: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , p7_a10 out nocopy JTF_NUMBER_TABLE
96: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , p7_a4 out nocopy JTF_NUMBER_TABLE
98: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , p7_a6 out nocopy JTF_NUMBER_TABLE
100: , p7_a7 out nocopy JTF_NUMBER_TABLE
101: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
102: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , p7_a10 out nocopy JTF_NUMBER_TABLE
104: , p7_a11 out nocopy JTF_NUMBER_TABLE
99: , p7_a6 out nocopy JTF_NUMBER_TABLE
100: , p7_a7 out nocopy JTF_NUMBER_TABLE
101: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
102: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , p7_a10 out nocopy JTF_NUMBER_TABLE
104: , p7_a11 out nocopy JTF_NUMBER_TABLE
105: , x_return_status out nocopy VARCHAR2
106: , x_msg_count out nocopy NUMBER
107: , x_msg_data out nocopy VARCHAR2
100: , p7_a7 out nocopy JTF_NUMBER_TABLE
101: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
102: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , p7_a10 out nocopy JTF_NUMBER_TABLE
104: , p7_a11 out nocopy JTF_NUMBER_TABLE
105: , x_return_status out nocopy VARCHAR2
106: , x_msg_count out nocopy NUMBER
107: , x_msg_data out nocopy VARCHAR2
108: );