[Home] [Help]
PACKAGE: APPS.LNS_BILLING_BATCH_PUB_W
Source
1 package lns_billing_batch_pub_w as
2 /* $Header: LNS_BILL_PUBJ_S.pls 120.2 2005/07/13 13:47 scherkas noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy lns_billing_batch_pub.loans_to_bill_tbl, a0 JTF_NUMBER_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
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_NUMBER_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
33 );
34 procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
35 , a1 out nocopy JTF_NUMBER_TABLE
36 , a2 out nocopy JTF_VARCHAR2_TABLE_100
37 , a3 out nocopy JTF_VARCHAR2_TABLE_300
38 , a4 out nocopy JTF_NUMBER_TABLE
39 , a5 out nocopy JTF_DATE_TABLE
40 , a6 out nocopy JTF_DATE_TABLE
41 , a7 out nocopy JTF_DATE_TABLE
42 , a8 out nocopy JTF_VARCHAR2_TABLE_100
43 , a9 out nocopy JTF_VARCHAR2_TABLE_100
44 , a10 out nocopy JTF_NUMBER_TABLE
45 , a11 out nocopy JTF_NUMBER_TABLE
46 , a12 out nocopy JTF_VARCHAR2_TABLE_100
47 , a13 out nocopy JTF_NUMBER_TABLE
48 , a14 out nocopy JTF_VARCHAR2_TABLE_100
49 , a15 out nocopy JTF_VARCHAR2_TABLE_100
50 , a16 out nocopy JTF_NUMBER_TABLE
51 , a17 out nocopy JTF_NUMBER_TABLE
52 , a18 out nocopy JTF_NUMBER_TABLE
53 , a19 out nocopy JTF_NUMBER_TABLE
54 , a20 out nocopy JTF_NUMBER_TABLE
55 , a21 out nocopy JTF_NUMBER_TABLE
56 , a22 out nocopy JTF_NUMBER_TABLE
57 , a23 out nocopy JTF_NUMBER_TABLE
58 , a24 out nocopy JTF_VARCHAR2_TABLE_100
59 , a25 out nocopy JTF_DATE_TABLE
60 , a26 out nocopy JTF_NUMBER_TABLE
61 , a27 out nocopy JTF_NUMBER_TABLE
62 , a28 out nocopy JTF_NUMBER_TABLE
63 , a29 out nocopy JTF_VARCHAR2_TABLE_100
64 );
65
66 procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
67 , a1 JTF_NUMBER_TABLE
68 , a2 JTF_NUMBER_TABLE
69 , a3 JTF_NUMBER_TABLE
70 , a4 JTF_VARCHAR2_TABLE_100
71 , a5 JTF_NUMBER_TABLE
72 , a6 JTF_NUMBER_TABLE
73 , a7 JTF_NUMBER_TABLE
74 );
75 procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
76 , a1 out nocopy JTF_NUMBER_TABLE
77 , a2 out nocopy JTF_NUMBER_TABLE
78 , a3 out nocopy JTF_NUMBER_TABLE
79 , a4 out nocopy JTF_VARCHAR2_TABLE_100
80 , a5 out nocopy JTF_NUMBER_TABLE
81 , a6 out nocopy JTF_NUMBER_TABLE
82 , a7 out nocopy JTF_NUMBER_TABLE
83 );
84
85 procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
86 , a1 JTF_NUMBER_TABLE
87 , a2 JTF_NUMBER_TABLE
88 , a3 JTF_DATE_TABLE
89 );
90 procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
91 , a1 out nocopy JTF_NUMBER_TABLE
92 , a2 out nocopy JTF_NUMBER_TABLE
93 , a3 out nocopy JTF_DATE_TABLE
94 );
95
96 procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
97 , a1 JTF_NUMBER_TABLE
98 , a2 JTF_NUMBER_TABLE
99 , a3 JTF_NUMBER_TABLE
100 , a4 JTF_NUMBER_TABLE
101 , a5 JTF_NUMBER_TABLE
102 , a6 JTF_NUMBER_TABLE
103 , a7 JTF_VARCHAR2_TABLE_100
104 , a8 JTF_VARCHAR2_TABLE_300
105 , a9 JTF_NUMBER_TABLE
106 , a10 JTF_NUMBER_TABLE
107 , a11 JTF_NUMBER_TABLE
108 , a12 JTF_NUMBER_TABLE
109 );
110 procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
111 , a1 out nocopy JTF_NUMBER_TABLE
112 , a2 out nocopy JTF_NUMBER_TABLE
113 , a3 out nocopy JTF_NUMBER_TABLE
114 , a4 out nocopy JTF_NUMBER_TABLE
115 , a5 out nocopy JTF_NUMBER_TABLE
116 , a6 out nocopy JTF_NUMBER_TABLE
117 , a7 out nocopy JTF_VARCHAR2_TABLE_100
118 , a8 out nocopy JTF_VARCHAR2_TABLE_300
119 , a9 out nocopy JTF_NUMBER_TABLE
120 , a10 out nocopy JTF_NUMBER_TABLE
121 , a11 out nocopy JTF_NUMBER_TABLE
122 , a12 out nocopy JTF_NUMBER_TABLE
123 );
124
125 procedure create_single_offcycle_bill(p_api_version NUMBER
126 , p_init_msg_list VARCHAR2
127 , p_commit VARCHAR2
128 , p_validation_level NUMBER
129 , p4_a0 NUMBER
130 , p4_a1 NUMBER
131 , p4_a2 NUMBER
132 , p4_a3 DATE
133 , p5_a0 JTF_NUMBER_TABLE
134 , p5_a1 JTF_NUMBER_TABLE
135 , p5_a2 JTF_NUMBER_TABLE
136 , p5_a3 JTF_NUMBER_TABLE
137 , p5_a4 JTF_NUMBER_TABLE
138 , p5_a5 JTF_NUMBER_TABLE
139 , p5_a6 JTF_NUMBER_TABLE
140 , p5_a7 JTF_VARCHAR2_TABLE_100
141 , p5_a8 JTF_VARCHAR2_TABLE_300
142 , p5_a9 JTF_NUMBER_TABLE
143 , p5_a10 JTF_NUMBER_TABLE
144 , p5_a11 JTF_NUMBER_TABLE
145 , p5_a12 JTF_NUMBER_TABLE
146 , x_return_status out nocopy VARCHAR2
147 , x_msg_count out nocopy NUMBER
148 , x_msg_data out nocopy VARCHAR2
149 );
150 procedure create_offcycle_bills(p_api_version NUMBER
151 , p_init_msg_list VARCHAR2
152 , p_commit VARCHAR2
153 , p_validation_level NUMBER
154 , p4_a0 JTF_NUMBER_TABLE
155 , p4_a1 JTF_NUMBER_TABLE
156 , p4_a2 JTF_NUMBER_TABLE
157 , p4_a3 JTF_DATE_TABLE
158 , p5_a0 JTF_NUMBER_TABLE
159 , p5_a1 JTF_NUMBER_TABLE
160 , p5_a2 JTF_NUMBER_TABLE
161 , p5_a3 JTF_NUMBER_TABLE
162 , p5_a4 JTF_NUMBER_TABLE
163 , p5_a5 JTF_NUMBER_TABLE
164 , p5_a6 JTF_NUMBER_TABLE
165 , p5_a7 JTF_VARCHAR2_TABLE_100
166 , p5_a8 JTF_VARCHAR2_TABLE_300
167 , p5_a9 JTF_NUMBER_TABLE
168 , p5_a10 JTF_NUMBER_TABLE
169 , p5_a11 JTF_NUMBER_TABLE
170 , p5_a12 JTF_NUMBER_TABLE
171 , x_return_status out nocopy VARCHAR2
172 , x_msg_count out nocopy NUMBER
173 , x_msg_data out nocopy VARCHAR2
174 );
175 end lns_billing_batch_pub_w;