[Home] [Help]
PACKAGE: APPS.OKL_SUBSIDY_PROCESS_PVT_W
Source
1 package okl_subsidy_process_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLESBPS.pls 115.0 2003/09/19 22:57:36 avsingh noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy okl_subsidy_process_pvt.asbv_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_200
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_VARCHAR2_TABLE_300
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_DATE_TABLE
22 , a19 JTF_DATE_TABLE
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_VARCHAR2_TABLE_100
28 , a25 JTF_VARCHAR2_TABLE_100
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_VARCHAR2_TABLE_100
31 , a28 JTF_VARCHAR2_TABLE_100
32 );
33 procedure rosetta_table_copy_out_p1(t okl_subsidy_process_pvt.asbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34 , a1 out nocopy JTF_NUMBER_TABLE
35 , a2 out nocopy JTF_VARCHAR2_TABLE_100
36 , a3 out nocopy JTF_VARCHAR2_TABLE_200
37 , a4 out nocopy JTF_NUMBER_TABLE
38 , a5 out nocopy JTF_NUMBER_TABLE
39 , a6 out nocopy JTF_VARCHAR2_TABLE_100
40 , a7 out nocopy JTF_NUMBER_TABLE
41 , a8 out nocopy JTF_NUMBER_TABLE
42 , a9 out nocopy JTF_NUMBER_TABLE
43 , a10 out nocopy JTF_NUMBER_TABLE
44 , a11 out nocopy JTF_NUMBER_TABLE
45 , a12 out nocopy JTF_NUMBER_TABLE
46 , a13 out nocopy JTF_VARCHAR2_TABLE_300
47 , a14 out nocopy JTF_NUMBER_TABLE
48 , a15 out nocopy JTF_NUMBER_TABLE
49 , a16 out nocopy JTF_VARCHAR2_TABLE_100
50 , a17 out nocopy JTF_VARCHAR2_TABLE_100
51 , a18 out nocopy JTF_DATE_TABLE
52 , a19 out nocopy JTF_DATE_TABLE
53 , a20 out nocopy JTF_NUMBER_TABLE
54 , a21 out nocopy JTF_VARCHAR2_TABLE_100
55 , a22 out nocopy JTF_VARCHAR2_TABLE_100
56 , a23 out nocopy JTF_VARCHAR2_TABLE_100
57 , a24 out nocopy JTF_VARCHAR2_TABLE_100
58 , a25 out nocopy JTF_VARCHAR2_TABLE_100
59 , a26 out nocopy JTF_NUMBER_TABLE
60 , a27 out nocopy JTF_VARCHAR2_TABLE_100
61 , a28 out nocopy JTF_VARCHAR2_TABLE_100
62 );
63
64 procedure get_subsidy_amount(p_api_version NUMBER
65 , p_init_msg_list VARCHAR2
66 , x_return_status out nocopy VARCHAR2
67 , x_msg_count out nocopy NUMBER
68 , x_msg_data out nocopy VARCHAR2
69 , p_subsidy_cle_id NUMBER
70 , p6_a0 out nocopy NUMBER
71 , p6_a1 out nocopy NUMBER
72 , p6_a2 out nocopy VARCHAR2
73 , p6_a3 out nocopy VARCHAR2
74 , p6_a4 out nocopy NUMBER
75 , p6_a5 out nocopy NUMBER
76 , p6_a6 out nocopy VARCHAR2
77 , p6_a7 out nocopy NUMBER
78 , p6_a8 out nocopy NUMBER
79 , p6_a9 out nocopy NUMBER
80 , p6_a10 out nocopy NUMBER
81 , p6_a11 out nocopy NUMBER
82 , p6_a12 out nocopy NUMBER
83 , p6_a13 out nocopy VARCHAR2
84 , p6_a14 out nocopy NUMBER
85 , p6_a15 out nocopy NUMBER
86 , p6_a16 out nocopy VARCHAR2
87 , p6_a17 out nocopy VARCHAR2
88 , p6_a18 out nocopy DATE
89 , p6_a19 out nocopy DATE
90 , p6_a20 out nocopy NUMBER
91 , p6_a21 out nocopy VARCHAR2
92 , p6_a22 out nocopy VARCHAR2
93 , p6_a23 out nocopy VARCHAR2
94 , p6_a24 out nocopy VARCHAR2
95 , p6_a25 out nocopy VARCHAR2
96 , p6_a26 out nocopy NUMBER
97 , p6_a27 out nocopy VARCHAR2
98 , p6_a28 out nocopy VARCHAR2
99 );
100 procedure get_asset_subsidy_amount(p_api_version NUMBER
101 , p_init_msg_list VARCHAR2
102 , x_return_status out nocopy VARCHAR2
103 , x_msg_count out nocopy NUMBER
104 , x_msg_data out nocopy VARCHAR2
105 , p_asset_cle_id NUMBER
106 , p6_a0 out nocopy JTF_NUMBER_TABLE
107 , p6_a1 out nocopy JTF_NUMBER_TABLE
108 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
109 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
110 , p6_a4 out nocopy JTF_NUMBER_TABLE
111 , p6_a5 out nocopy JTF_NUMBER_TABLE
112 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
113 , p6_a7 out nocopy JTF_NUMBER_TABLE
114 , p6_a8 out nocopy JTF_NUMBER_TABLE
115 , p6_a9 out nocopy JTF_NUMBER_TABLE
116 , p6_a10 out nocopy JTF_NUMBER_TABLE
117 , p6_a11 out nocopy JTF_NUMBER_TABLE
118 , p6_a12 out nocopy JTF_NUMBER_TABLE
119 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
120 , p6_a14 out nocopy JTF_NUMBER_TABLE
121 , p6_a15 out nocopy JTF_NUMBER_TABLE
122 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
123 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
124 , p6_a18 out nocopy JTF_DATE_TABLE
125 , p6_a19 out nocopy JTF_DATE_TABLE
126 , p6_a20 out nocopy JTF_NUMBER_TABLE
127 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
128 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
129 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
130 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
131 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
132 , p6_a26 out nocopy JTF_NUMBER_TABLE
133 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
134 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
135 );
136 procedure get_contract_subsidy_amount(p_api_version NUMBER
137 , p_init_msg_list VARCHAR2
138 , x_return_status out nocopy VARCHAR2
139 , x_msg_count out nocopy NUMBER
140 , x_msg_data out nocopy VARCHAR2
141 , p_chr_id NUMBER
142 , p6_a0 out nocopy JTF_NUMBER_TABLE
143 , p6_a1 out nocopy JTF_NUMBER_TABLE
144 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
145 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
146 , p6_a4 out nocopy JTF_NUMBER_TABLE
147 , p6_a5 out nocopy JTF_NUMBER_TABLE
148 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
149 , p6_a7 out nocopy JTF_NUMBER_TABLE
150 , p6_a8 out nocopy JTF_NUMBER_TABLE
151 , p6_a9 out nocopy JTF_NUMBER_TABLE
152 , p6_a10 out nocopy JTF_NUMBER_TABLE
153 , p6_a11 out nocopy JTF_NUMBER_TABLE
154 , p6_a12 out nocopy JTF_NUMBER_TABLE
155 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
156 , p6_a14 out nocopy JTF_NUMBER_TABLE
157 , p6_a15 out nocopy JTF_NUMBER_TABLE
158 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
159 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
160 , p6_a18 out nocopy JTF_DATE_TABLE
161 , p6_a19 out nocopy JTF_DATE_TABLE
162 , p6_a20 out nocopy JTF_NUMBER_TABLE
163 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
164 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
165 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
166 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
167 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
168 , p6_a26 out nocopy JTF_NUMBER_TABLE
169 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
170 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
171 );
172 procedure get_partial_subsidy_amount(p_api_version NUMBER
173 , p_init_msg_list VARCHAR2
174 , x_return_status out nocopy VARCHAR2
175 , x_msg_count out nocopy NUMBER
176 , x_msg_data out nocopy VARCHAR2
177 , p_asset_cle_id NUMBER
178 , p_req_fund_amount NUMBER
179 , p7_a0 out nocopy JTF_NUMBER_TABLE
180 , p7_a1 out nocopy JTF_NUMBER_TABLE
181 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
182 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
183 , p7_a4 out nocopy JTF_NUMBER_TABLE
184 , p7_a5 out nocopy JTF_NUMBER_TABLE
185 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
186 , p7_a7 out nocopy JTF_NUMBER_TABLE
187 , p7_a8 out nocopy JTF_NUMBER_TABLE
188 , p7_a9 out nocopy JTF_NUMBER_TABLE
189 , p7_a10 out nocopy JTF_NUMBER_TABLE
190 , p7_a11 out nocopy JTF_NUMBER_TABLE
191 , p7_a12 out nocopy JTF_NUMBER_TABLE
192 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_300
193 , p7_a14 out nocopy JTF_NUMBER_TABLE
194 , p7_a15 out nocopy JTF_NUMBER_TABLE
195 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
196 , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
197 , p7_a18 out nocopy JTF_DATE_TABLE
198 , p7_a19 out nocopy JTF_DATE_TABLE
199 , p7_a20 out nocopy JTF_NUMBER_TABLE
200 , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
201 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
202 , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
203 , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
204 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
205 , p7_a26 out nocopy JTF_NUMBER_TABLE
206 , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
207 , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
208 );
209 end okl_subsidy_process_pvt_w;