[Home] [Help]
PACKAGE: APPS.OKL_EC_UPTAKE_PVT_W
Source
1 package okl_ec_uptake_pvt_w as
2 /* $Header: OKLEECXS.pls 120.7 2006/03/08 11:38:00 ssdeshpa noship $ */
3 procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE);
4 procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
5
6 procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300);
7 procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
8
9 procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE);
10 procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE);
11
12 procedure rosetta_table_copy_in_p22(t out nocopy okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 JTF_VARCHAR2_TABLE_300
13 , a1 JTF_VARCHAR2_TABLE_100
14 );
15 procedure rosetta_table_copy_out_p22(t okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
16 , a1 out nocopy JTF_VARCHAR2_TABLE_100
17 );
18
19 procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE
20 , a1 JTF_NUMBER_TABLE
21 , a2 JTF_NUMBER_TABLE
22 , a3 JTF_VARCHAR2_TABLE_200
23 , a4 JTF_VARCHAR2_TABLE_2000
24 , a5 JTF_DATE_TABLE
25 , a6 JTF_DATE_TABLE
26 , a7 JTF_NUMBER_TABLE
27 , a8 JTF_VARCHAR2_TABLE_100
28 , a9 JTF_VARCHAR2_TABLE_100
29 , a10 JTF_VARCHAR2_TABLE_300
30 );
31 procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32 , a1 out nocopy JTF_NUMBER_TABLE
33 , a2 out nocopy JTF_NUMBER_TABLE
34 , a3 out nocopy JTF_VARCHAR2_TABLE_200
35 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
36 , a5 out nocopy JTF_DATE_TABLE
37 , a6 out nocopy JTF_DATE_TABLE
38 , a7 out nocopy JTF_NUMBER_TABLE
39 , a8 out nocopy JTF_VARCHAR2_TABLE_100
40 , a9 out nocopy JTF_VARCHAR2_TABLE_100
41 , a10 out nocopy JTF_VARCHAR2_TABLE_300
42 );
43
44 procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE
45 , a1 JTF_NUMBER_TABLE
46 , a2 JTF_NUMBER_TABLE
47 , a3 JTF_VARCHAR2_TABLE_300
48 , a4 JTF_VARCHAR2_TABLE_2000
49 , a5 JTF_VARCHAR2_TABLE_100
50 , a6 JTF_DATE_TABLE
51 , a7 JTF_DATE_TABLE
52 , a8 JTF_NUMBER_TABLE
53 , a9 JTF_VARCHAR2_TABLE_100
54 , a10 JTF_VARCHAR2_TABLE_100
55 , a11 JTF_VARCHAR2_TABLE_300
56 );
57 procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58 , a1 out nocopy JTF_NUMBER_TABLE
59 , a2 out nocopy JTF_NUMBER_TABLE
60 , a3 out nocopy JTF_VARCHAR2_TABLE_300
61 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62 , a5 out nocopy JTF_VARCHAR2_TABLE_100
63 , a6 out nocopy JTF_DATE_TABLE
64 , a7 out nocopy JTF_DATE_TABLE
65 , a8 out nocopy JTF_NUMBER_TABLE
66 , a9 out nocopy JTF_VARCHAR2_TABLE_100
67 , a10 out nocopy JTF_VARCHAR2_TABLE_100
68 , a11 out nocopy JTF_VARCHAR2_TABLE_300
69 );
70
71 procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE
72 , a1 JTF_VARCHAR2_TABLE_200
73 , a2 JTF_VARCHAR2_TABLE_200
74 , a3 JTF_NUMBER_TABLE
75 , a4 JTF_VARCHAR2_TABLE_2000
76 , a5 JTF_VARCHAR2_TABLE_100
77 , a6 JTF_VARCHAR2_TABLE_200
78 , a7 JTF_VARCHAR2_TABLE_4000
79 );
80 procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81 , a1 out nocopy JTF_VARCHAR2_TABLE_200
82 , a2 out nocopy JTF_VARCHAR2_TABLE_200
83 , a3 out nocopy JTF_NUMBER_TABLE
84 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
85 , a5 out nocopy JTF_VARCHAR2_TABLE_100
86 , a6 out nocopy JTF_VARCHAR2_TABLE_200
87 , a7 out nocopy JTF_VARCHAR2_TABLE_4000
88 );
89
90 procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE
91 , a1 JTF_VARCHAR2_TABLE_200
92 , a2 JTF_DATE_TABLE
93 , a3 JTF_DATE_TABLE
94 );
95 procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96 , a1 out nocopy JTF_VARCHAR2_TABLE_200
97 , a2 out nocopy JTF_DATE_TABLE
98 , a3 out nocopy JTF_DATE_TABLE
99 );
100
101 procedure populate_lease_rate_set(p_api_version NUMBER
102 , p_init_msg_list VARCHAR2
103 , p_target_id NUMBER
104 , p_target_type VARCHAR2
105 , p4_a0 out nocopy JTF_NUMBER_TABLE
106 , p4_a1 out nocopy JTF_NUMBER_TABLE
107 , p4_a2 out nocopy JTF_NUMBER_TABLE
108 , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200
109 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
110 , p4_a5 out nocopy JTF_DATE_TABLE
111 , p4_a6 out nocopy JTF_DATE_TABLE
112 , p4_a7 out nocopy JTF_NUMBER_TABLE
113 , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
114 , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
115 , p4_a10 out nocopy JTF_VARCHAR2_TABLE_300
116 , x_return_status out nocopy VARCHAR2
117 , x_msg_count out nocopy NUMBER
118 , x_msg_data out nocopy VARCHAR2
119 );
120 procedure populate_std_rate_tmpl(p_api_version NUMBER
121 , p_init_msg_list VARCHAR2
122 , p_target_id NUMBER
123 , p_target_type VARCHAR2
124 , p4_a0 out nocopy JTF_NUMBER_TABLE
125 , p4_a1 out nocopy JTF_NUMBER_TABLE
126 , p4_a2 out nocopy JTF_NUMBER_TABLE
127 , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
128 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
129 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
130 , p4_a6 out nocopy JTF_DATE_TABLE
131 , p4_a7 out nocopy JTF_DATE_TABLE
132 , p4_a8 out nocopy JTF_NUMBER_TABLE
133 , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
134 , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
135 , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
136 , x_return_status out nocopy VARCHAR2
137 , x_msg_count out nocopy NUMBER
138 , x_msg_data out nocopy VARCHAR2
139 );
140 procedure populate_lease_rate_set(p_api_version NUMBER
141 , p_init_msg_list VARCHAR2
142 , p_target_id NUMBER
143 , p_target_type VARCHAR2
144 , p_target_eff_from DATE
145 , p_term NUMBER
146 , p_territory VARCHAR2
147 , p_deal_size NUMBER
148 , p_customer_credit_class VARCHAR2
149 , p_down_payment NUMBER
150 , p_advance_rent NUMBER
151 , p_trade_in_value NUMBER
152 , p_currency_code VARCHAR2
153 , p_item_table JTF_NUMBER_TABLE
154 , p_item_categories_table JTF_NUMBER_TABLE
155 , p15_a0 out nocopy JTF_NUMBER_TABLE
156 , p15_a1 out nocopy JTF_NUMBER_TABLE
157 , p15_a2 out nocopy JTF_NUMBER_TABLE
158 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200
159 , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
160 , p15_a5 out nocopy JTF_DATE_TABLE
161 , p15_a6 out nocopy JTF_DATE_TABLE
162 , p15_a7 out nocopy JTF_NUMBER_TABLE
163 , p15_a8 out nocopy JTF_VARCHAR2_TABLE_100
164 , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
165 , p15_a10 out nocopy JTF_VARCHAR2_TABLE_300
166 , x_return_status out nocopy VARCHAR2
167 , x_msg_count out nocopy NUMBER
168 , x_msg_data out nocopy VARCHAR2
169 );
170 procedure populate_std_rate_tmpl(p_api_version NUMBER
171 , p_init_msg_list VARCHAR2
172 , p_target_id NUMBER
173 , p_target_type VARCHAR2
174 , p_target_eff_from DATE
175 , p_term NUMBER
176 , p_territory VARCHAR2
177 , p_deal_size NUMBER
178 , p_customer_credit_class VARCHAR2
179 , p_down_payment NUMBER
180 , p_advance_rent NUMBER
181 , p_trade_in_value NUMBER
182 , p_currency_code VARCHAR2
183 , p_item_table JTF_NUMBER_TABLE
184 , p_item_categories_table JTF_NUMBER_TABLE
185 , p15_a0 out nocopy JTF_NUMBER_TABLE
186 , p15_a1 out nocopy JTF_NUMBER_TABLE
187 , p15_a2 out nocopy JTF_NUMBER_TABLE
188 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_300
189 , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
190 , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100
191 , p15_a6 out nocopy JTF_DATE_TABLE
192 , p15_a7 out nocopy JTF_DATE_TABLE
193 , p15_a8 out nocopy JTF_NUMBER_TABLE
194 , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
195 , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100
196 , p15_a11 out nocopy JTF_VARCHAR2_TABLE_300
197 , x_return_status out nocopy VARCHAR2
198 , x_msg_count out nocopy NUMBER
199 , x_msg_data out nocopy VARCHAR2
200 );
201 procedure populate_product(p_api_version NUMBER
202 , p_init_msg_list VARCHAR2
203 , p_target_id NUMBER
204 , p_target_type VARCHAR2
205 , p4_a0 out nocopy JTF_NUMBER_TABLE
206 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_200
207 , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
208 , p4_a3 out nocopy JTF_NUMBER_TABLE
209 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
210 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
211 , p4_a6 out nocopy JTF_VARCHAR2_TABLE_200
212 , p4_a7 out nocopy JTF_VARCHAR2_TABLE_4000
213 , x_return_status out nocopy VARCHAR2
214 , x_msg_count out nocopy NUMBER
215 , x_msg_data out nocopy VARCHAR2
216 );
217 procedure populate_vendor_program(p_api_version NUMBER
218 , p_init_msg_list VARCHAR2
219 , p_target_id NUMBER
220 , p_target_type VARCHAR2
221 , p_target_eff_from DATE
222 , p_term NUMBER
223 , p_territory VARCHAR2
224 , p_deal_size NUMBER
225 , p_customer_credit_class VARCHAR2
226 , p_down_payment NUMBER
227 , p_advance_rent NUMBER
228 , p_trade_in_value NUMBER
229 , p_item_table JTF_NUMBER_TABLE
230 , p_item_categories_table JTF_NUMBER_TABLE
231 , p14_a0 out nocopy JTF_NUMBER_TABLE
232 , p14_a1 out nocopy JTF_VARCHAR2_TABLE_200
233 , p14_a2 out nocopy JTF_DATE_TABLE
234 , p14_a3 out nocopy JTF_DATE_TABLE
235 , x_return_status out nocopy VARCHAR2
236 , x_msg_count out nocopy NUMBER
237 , x_msg_data out nocopy VARCHAR2
238 );
239 end okl_ec_uptake_pvt_w;