[Home] [Help]
PACKAGE: APPS.JAI_RCV_RCV_RTV_PKG
Source
1 package jai_rcv_rcv_rtv_pkg AS
2 /* $Header: jai_rcv_rcv_rtv.pls 120.5 2007/04/24 06:35:00 bduvarag 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 parameters 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 p_process_flag out nocopy varchar2,
98 p_process_message out nocopy varchar2,
99 p_codepath in out nocopy varchar2
100 );
101
102
103 procedure validate_transaction_tax_accnt
104 (
105 p_transaction_type in varchar2,
106 p_parent_transaction_type in varchar2,
107 -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category in varchar2,
108 p_receipt_source_code in varchar2,
109 p_boe_account_id in number,
110 p_rtv_expense_account_id in number,
111 p_excise_expense_account in number,
112 p_excise_rcvble_account in number,
113 p_receiving_account_id in out nocopy number,
114 p_ap_accrual_account in out nocopy number,
115 p_po_accrual_account_id in number,
116 p_interorg_payables_account in number,
117 p_intransit_inv_account in number,
118 p_interorg_receivables_account in number,
119 p_intransit_type in number,
120 p_fob_point in number,
121 p_cvd_taxes in number,
122 p_add_cvd_taxes in number,/*5228046 Additional cvd Enhancement*/
123 p_customs_taxes in number,
124 p_third_party_taxes in number,
125 p_excise_tax in number,
126 p_trading_to_trading_iso in varchar2, /* Bug#4171469 */
127 p_debug in varchar2, -- default 'N', File.Sql.35
128 p_process_flag out nocopy varchar2,
129 p_process_message out nocopy varchar2,
130 p_codepath in out nocopy varchar2
131 );
132
133 procedure apply_relieve_boe
134 (
135 p_transaction_id in number,
136 p_transaction_type in varchar2,
137 p_parent_transaction_id in number,
138 p_parent_transaction_type in varchar2,
139 p_shipment_line_id in number,
140 p_shipment_header_id in number,
141 p_organization_id in number,
142 p_inventory_item_id in number,
143 p_cvd_taxes in number,
144 p_add_cvd_taxes in number,/*5228046 Additional cvd Enhancement*/
145 p_customs_taxes in number,
146 p_cvd_edu_cess in number, /* Educational Cess */
147 p_cvd_sh_edu_cess in number,/*Bug 5989740 bduvarag*/
148 p_customs_edu_cess in number, /* Educational Cess */
149 p_customs_sh_edu_cess in number,/*Bug 5989740 bduvarag*/
150 p_simulation in varchar2,
151 p_debug in varchar2, -- default 'N', File.Sql.35
152 p_process_flag out nocopy varchar2,
153 p_process_message out nocopy varchar2,
154 p_codepath in out nocopy varchar2
155 ) ;
156
157
158 procedure relieve_boe
159 (
160 p_shipment_header_id in number,
161 p_shipment_line_id in number,
162 p_transaction_id in number,
163 p_parent_transaction_id in number,
164 p_boe_tax in number,
165 p_simulation in varchar2,
166 p_debug in varchar2 , -- default 'N', File.Sql.35
167 p_process_flag out nocopy varchar2,
168 p_process_message out nocopy varchar2,
169 p_codepath in out nocopy varchar2
170 );
171
172
173 procedure apply_boe
174 (
175 p_shipment_header_id in number,
176 p_shipment_line_id in number,
177 p_transaction_id in number,
178 p_organization_id in number,
179 p_inventory_item_id in number,
180 p_boe_tax in number,
181 p_simulation in varchar2,
182 p_debug in varchar2, -- default 'N', File.Sql.35
183 p_process_flag out nocopy varchar2,
184 p_process_message out nocopy varchar2,
185 p_codepath in out nocopy varchar2
186 );
187
188
189 procedure post_entries
190 (
191 p_transaction_id in number,
192 p_transaction_type in varchar2,
193 p_parent_transaction_type in varchar2,
194 -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category in varchar2,
195 p_receipt_source_code in varchar2,
196 p_transaction_date in date,
197 p_receipt_num in varchar2,
198 p_receiving_account_id in number,
199 p_ap_accrual_account in number,
200 p_boe_account_id in number,
201 p_rtv_expense_account_id in number,
202 p_intransit_type in number,
203 p_fob_point in number,
204 p_intransit_inv_account in number,
205 p_interorg_receivables_account in number,
206 p_all_taxes in number,
207 p_tds_taxes in number,
208 p_modvat_recovery_taxes in number,
209 p_cvd_taxes in number,
210 p_add_cvd_taxes in number, /*5228046 Additional cvd Enhancement*/
211 p_customs_taxes in number,
212 p_third_party_taxes in number,
213 p_excise_tax in number,
214 p_service_recoverable in number, /* Service */
215 p_service_not_recoverable in number, /* Service */
216 /* following two variable added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
217 p_account_service_interim in boolean,
218 p_vat_recoverable in number,
219 p_vat_not_recoverable in number, /* Service */
220 p_excise_edu_cess in number, /* Educational Cess */
221 p_excise_sh_edu_cess in number,/*Bug 5989740 bduvarag*/
222 p_cvd_edu_cess in number, /* Educational Cess */
223 p_cvd_sh_edu_cess in number,/*Bug 5989740 bduvarag*/
224 p_customs_edu_cess in number, /* Educational Cess */
225 p_customs_sh_edu_cess in number,/*Bug 5989740 bduvarag*/
226 p_trading_to_trading_iso in varchar2, /* Bug#4171469 */
227 ptr_jv in OUT NOCOPY JOURNAL_LINES, /* 5527885 */
228 p_simulation in varchar2,
229 p_debug in varchar2, -- default 'N', File.Sql.35
230 p_process_flag out nocopy varchar2,
231 p_process_message out nocopy varchar2,
232 p_codepath in out nocopy varchar2
233 );
234
235
236 procedure regime_tax_accounting_interim
237 (
238 p_transaction_id in number,
239 p_shipment_line_id in number,
240 p_organization_id in number,
241 p_location_id in number,
242 p_transaction_type in varchar2,
243 p_currency_conversion_rate in number,
244 p_parent_transaction_type in varchar2,
245 -- p_attribute_category in varchar2,
246 p_receipt_source_code in varchar2,
247 p_transaction_date in date,
248 p_receipt_num in varchar2,
249 p_regime_code in varchar2,
250 ptr_jv in OUT NOCOPY JOURNAL_LINES, /* 5527885 */
251 p_simulation in varchar2,
252 p_debug in varchar2, -- default 'N', File.Sql.35
253 p_process_flag out nocopy varchar2,
254 p_process_message out nocopy varchar2,
255 p_codepath in out nocopy varchar2
256 );
257
258 end jai_rcv_rcv_rtv_pkg;