1 package jai_rcv_rcv_rtv_pkg AS
2 /* $Header: jai_rcv_rcv_rtv.pls 120.9.12020000.4 2013/01/30 07:30:19 mbremkum ship $ */
3 /*Bug 5527885 Start*/
4 TYPE journal_line IS RECORD(
5 line_num number(15),
6 acct_type varchar2(10),
7 acct_nature varchar2(30),
8 source_name varchar2(25),
9 category_name varchar2(25),
10 ccid number(15),
11 entered_dr number,
12 entered_cr number,
13 currency_code varchar2(15),
14 accounting_date date,
15 reference_10 varchar2(240),
16 reference_23 varchar2(240),
17 reference_24 varchar2(240),
18 reference_25 varchar2(240),
19 reference_26 varchar2(240),
20 destination varchar2(15),
21 reference_name varchar2(30),
22 reference_id number(15),
23
24 non_rnd_entered_dr number,
25 non_rnd_entered_cr number,
26 account_name varchar2(30), /*this should be used to know which account is being hit */
27 summary_jv_flag varchar2(1)
28 );
29
30 TYPE JOURNAL_LINES IS TABLE OF journal_line INDEX BY BINARY_INTEGER;
31 /*Bug 5527885 End*/
32 procedure process_transaction
33 (
34 p_transaction_id in number,
35 p_simulation in varchar2, -- default 'N', File.Sql.35
36 p_debug in varchar2, -- default 'Y', File.Sql.35
37 p_process_flag out nocopy varchar2,
38 p_process_message out nocopy varchar2,
39 p_codepath in out nocopy varchar2
40 );
41
42 procedure get_accounts
43 (
44 p_organization_id in number,
45 p_location_id in number,
46 p_receipt_source_code in varchar2,
47 p_from_organization_id in number,
48 p_to_organization_id in number,
49 p_po_distribution_id in number,
50 p_po_line_location_id in number,
51 p_debug in varchar2, -- default 'N', File.Sql.35
52 p_boe_account_id out nocopy number,
53 p_rtv_expense_account_id out nocopy number,
54 p_excise_expense_account out nocopy number,
55 p_excise_rcvble_account out nocopy number,
56 p_receiving_account_id out nocopy number,
57 p_ap_accrual_account out nocopy number,
58 p_po_accrual_account_id out nocopy number,
59 p_interorg_payables_account out nocopy number,
60 p_intransit_inv_account out nocopy number,
61 p_interorg_receivables_account out nocopy number,
62 p_intransit_type out nocopy number,
63 p_fob_point out nocopy number,
64 p_trading_to_trading_iso out nocopy varchar2, /* Bug#4171469 */
65 p_process_flag out nocopy varchar2,
66 p_process_message out nocopy varchar2,
67 p_codepath in out nocopy varchar2
68 );
69
70
71 procedure get_tax_breakup
72 (
73 p_transaction_id in number,
74 p_shipment_line_id in number,
75 p_currency_conversion_rate in number,
76 p_po_vendor_id in number,
77 p_debug in varchar2, -- default 'N', File.Sql.35
78 p_all_taxes out nocopy number,
79 p_tds_taxes out nocopy number,
80 p_modvat_recovery_taxes out nocopy number,
81 p_cvd_taxes out nocopy number,
82 p_add_cvd_taxes out nocopy number, /*5228046 Additional cvd Enhancement*/
83 p_customs_taxes out nocopy number,
84 p_third_party_taxes out nocopy number,
85 p_excise_tax out nocopy number,
86 p_service_recoverable out nocopy number, /* service */
87 p_service_not_recoverable out nocopy number, /* service */
88 /* following two params added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
89 p_vat_recoverable out nocopy number,
90 p_vat_not_recoverable out nocopy number,
91 p_excise_edu_cess out nocopy number, /* educational cess */
92 p_excise_sh_edu_cess out nocopy number,/*Bug 5989740 bduvarag*/
93 p_cvd_edu_cess out nocopy number, /* educational cess */
94 p_cvd_sh_edu_cess out nocopy number,/*Bug 5989740 bduvarag*/
95 p_customs_edu_cess out nocopy number, /* educational cess */
96 p_customs_sh_edu_cess out nocopy number,/*Bug 5989740 bduvarag*/
97 --Added by zhiwei for BOE ER bug 11684111 begin
98 -------------------------------------------------------------------
99 p_boe_other1 out nocopy number,
100 p_boe_other2 out nocopy number,
101 p_boe_other3 out nocopy number,
102 p_boe_other4 out nocopy number,
103 p_boe_other5 out nocopy number,
104 p_boe_surcharge_duty out nocopy number,
105 p_boe_add_customs out nocopy number,
106 --------------------------------------------------------------------
107 --Added by zhiwei for BOE ER bug 11684111 end
108 p_process_flag out nocopy varchar2,
109 p_process_message out nocopy varchar2,
110 p_codepath in out nocopy varchar2
111 ,
112 --POT 11936596
113 p_inclu_service_recoverable out nocopy number,
114 p_inclu_vat_recoverable out nocopy number /*Bug 14185068*/
115 );
116
117
118 procedure validate_transaction_tax_accnt
119 (
120 p_transaction_type in varchar2,
121 p_parent_transaction_type in varchar2,
122 -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category in varchar2,
123 p_receipt_source_code in varchar2,
124 p_boe_account_id in number,
125 p_rtv_expense_account_id in number,
126 p_excise_expense_account in number,
127 p_excise_rcvble_account in number,
128 p_receiving_account_id in out nocopy number,
129 p_ap_accrual_account in out nocopy number,
130 p_po_accrual_account_id in number,
131 p_interorg_payables_account in number,
132 p_intransit_inv_account in number,
133 p_interorg_receivables_account in number,
134 p_intransit_type in number,
135 p_fob_point in number,
136 p_cvd_taxes in number,
137 p_add_cvd_taxes in number,/*5228046 Additional cvd Enhancement*/
138 p_customs_taxes in number,
139 p_third_party_taxes in number,
140 p_excise_tax in number,
141 p_trading_to_trading_iso in varchar2, /* Bug#4171469 */
142 p_debug in varchar2, -- default 'N', File.Sql.35
143 p_process_flag out nocopy varchar2,
144 p_process_message out nocopy varchar2,
145 p_codepath in out nocopy varchar2
146 );
147
148 procedure apply_relieve_boe
149 (
150 p_transaction_id in number,
151 p_transaction_type in varchar2,
152 p_parent_transaction_id in number,
153 p_parent_transaction_type in varchar2,
154 p_shipment_line_id in number,
155 p_shipment_header_id in number,
156 p_organization_id in number,
157 p_inventory_item_id in number,
158 p_cvd_taxes in number,
159 p_add_cvd_taxes in number,/*5228046 Additional cvd Enhancement*/
160 p_customs_taxes in number,
161 p_cvd_edu_cess in number, /* Educational Cess */
162 p_cvd_sh_edu_cess in number, /*Bug 5989740 bduvarag*/
163 p_customs_edu_cess in number, /* Educational Cess */
164 p_customs_sh_edu_cess in number, /*Bug 5989740 bduvarag*/
165 --Added by zhiwei for BOE ER bug 11684111 begin
166 ---------------------------------------------------------------------
167 p_boe_other1 in number,
168 p_boe_other2 in number,
169 p_boe_other3 in number,
170 p_boe_other4 in number,
171 p_boe_other5 in number,
172 p_boe_surcharge_duty in number,
173 p_boe_add_customs in number,
174 ---------------------------------------------------------------------
175 --Added by zhiwei for BOE ER bug 11684111 end
176 p_simulation in varchar2,
177 p_debug in varchar2, -- default 'N', File.Sql.35
178 p_process_flag out nocopy varchar2,
179 p_process_message out nocopy varchar2,
180 p_codepath in out nocopy varchar2
181 );
182
183
184 procedure relieve_boe
185 (
186 p_shipment_header_id in number,
187 p_shipment_line_id in number,
188 p_transaction_id in number,
189 p_parent_transaction_id in number,
190 p_boe_tax in number,
191 p_simulation in varchar2,
192 p_debug in varchar2 , -- default 'N', File.Sql.35
193 p_process_flag out nocopy varchar2,
194 p_process_message out nocopy varchar2,
195 p_codepath in out nocopy varchar2
196 );
197
198
199 procedure apply_boe
200 (
201 p_shipment_header_id in number,
202 p_shipment_line_id in number,
203 p_transaction_id in number,
204 p_organization_id in number,
205 p_inventory_item_id in number,
206 p_boe_tax in number,
207 p_simulation in varchar2,
208 p_debug in varchar2, -- default 'N', File.Sql.35
209 p_process_flag out nocopy varchar2,
210 p_process_message out nocopy varchar2,
211 p_codepath in out nocopy varchar2
212 );
213
214
215 procedure post_entries
216 (
217 p_transaction_id in number,
218 p_transaction_type in varchar2,
219 p_parent_transaction_type in varchar2,
220 -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category in varchar2,
221 p_receipt_source_code in varchar2,
222 p_transaction_date in date,
223 p_receipt_num in varchar2,
224 p_receiving_account_id in number,
225 p_ap_accrual_account in number,
226 p_boe_account_id in number,
227 p_rtv_expense_account_id in number,
228 p_intransit_type in number,
229 p_fob_point in number,
230 p_intransit_inv_account in number,
231 p_interorg_receivables_account in number,
232 p_all_taxes in number,
233 p_tds_taxes in number,
234 p_modvat_recovery_taxes in number,
235 p_cvd_taxes in number,
239 p_excise_tax in number,
236 p_add_cvd_taxes in number,/*5228046 Additional cvd Enhancement*/
237 p_customs_taxes in number,
238 p_third_party_taxes in number,
240 p_service_recoverable in number, /* Service */
241 p_service_not_recoverable in number, /* Service */
242 p_account_service_interim in boolean, /* Service */
243 /* following two params added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
244 p_vat_recoverable in number,
245 p_vat_not_recoverable in number,
246 p_excise_edu_cess in number, /* Educational Cess */
247 p_excise_sh_edu_cess in number, /*Bug 5989740 bduvarag*/
248 p_cvd_edu_cess in number, /* Educational Cess */
249 p_cvd_sh_edu_cess in number, /*Bug 5989740 bduvarag*/
250 p_customs_edu_cess in number, /* Educational Cess */
251 p_customs_sh_edu_cess in number, /*Bug 5989740 bduvarag*/
252 --Added by zhiwei for BOE ER bug 11684111 begin
253 ---------------------------------------------
254 p_boe_other1 in number,
255 p_boe_other2 in number,
256 p_boe_other3 in number,
257 p_boe_other4 in number,
258 p_boe_other5 in number,
259 p_boe_surcharge_duty in number,
260 p_boe_add_customs in number,
261 ---------------------------------------------------
262 --Added by zhiwei for BOE ER bug 11684111 end
263 p_trading_to_trading_iso in varchar2, /* Bug#4171469 */
264 ptr_jv in OUT NOCOPY JOURNAL_LINES, /* 5527885 */
265 p_simulation in varchar2,
266 p_debug in varchar2, -- default 'N', File.Sql.35
267 p_process_flag out nocopy varchar2,
268 p_process_message out nocopy varchar2,
269 p_codepath in out nocopy varchar2,
270 --added the below parameter for bug#11936596
271 p_inclu_service_recoverable in number default null,
272 p_inclu_vat_recoverable in number default null /*Bug 14185068*/
273 );
274
275
276 procedure regime_tax_accounting_interim
277 (
278 p_transaction_id in number,
279 p_shipment_line_id in number,
280 p_organization_id in number,
281 p_location_id in number,
282 p_transaction_type in varchar2,
283 p_currency_conversion_rate in number,
284 p_parent_transaction_type in varchar2,
285 -- p_attribute_category in varchar2,
286 p_receipt_source_code in varchar2,
287 p_transaction_date in date,
288 p_receipt_num in varchar2,
289 p_regime_code in varchar2,
290 ptr_jv in OUT NOCOPY JOURNAL_LINES, /* 5527885 */
291 p_simulation in varchar2,
292 p_debug in varchar2, -- default 'N', File.Sql.35
293 p_process_flag out nocopy varchar2,
294 p_process_message out nocopy varchar2,
295 p_codepath in out nocopy varchar2
296 );
297
298 end jai_rcv_rcv_rtv_pkg;