1 PACKAGE jai_ap_tds_tax_defaultation AUTHID CURRENT_USER AS
2 /* $Header: jai_ap_tds_dflt.pls 120.14 2012/05/23 09:51:41 zxin ship $ */
3
4 /* ----------------------------------------------------------------------------
5 FILENAME : jai_ap_tds_tax_defaultation_pkg_s.sql
6
7 Created By : Aparajita
8
9 Created Date : 24-dec-2004
10
11 Bug :
12
13 Purpose : Implementation of tax defaultation functionality on AP invoice.
14
15 Called from : Trigger ja_in_ap_aia_after_trg
16 Trigger ja_in_ap_aida_after_trg
17
18 CHANGE HISTORY:
19 -------------------------------------------------------------------------------
20 S.No Date Author and Details
21 -------------------------------------------------------------------------------
22 1. 24/12/2004 Aparajita for bug#4088186. version#115.0. TDS Clean Up.
23
24 Created this package for implementing the TDS tax defaultation
25 functionality onto AP invoice.
26
27 2. 08-Jun-2005 Version 116.1 jai_ap_tds_dflt -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
28 as required for CASE COMPLAINCE.
29
30 3. 21-Dec-2007 Sanjikum for Bug#6708042, Version 120.3
31 Obsoleted the changes done for verion 120.2 and rechecked in the version 120.1 as 120.3
32
33 4. 07/Jul/2009 Bgowrava for Bug#5911913 File version 120.1.12000000.4
34 Added two parameters
35 (1) p_old_input_dff_value_wct
36 (2) p_old_input_dff_value_essi
37 in procedure processs_invoice.
38
39 5. 23/Aug/2011 mmurtuza for bug12858951
40 Added parameter p_line_type_lookup_code in procedure populate_localization_inv_tax
41
42 5. 13/Mar/2011 mmurtuza for bug12858951 Post review
43 Added parameters p_po_distribution_id and p_rcv_transaction_id in procedure populate_localization_inv_tax
44
45 ---------------------------------------------------------------------------- */
46
47 procedure process_invoice
48 (
49 p_invoice_id in number,
50 p_invoice_line_number in number default null,
51 p_invoice_distribution_id in number default null,
52 p_line_type_lookup_code in varchar2,
53 p_distribution_line_number in number,
54 p_parent_reversal_id in number,
55 p_reversal_flag in varchar2,
56 p_amount in number,
57 p_invoice_currency_code in varchar2,
58 p_exchange_rate in number,
59 p_set_of_books_id in number,
60 p_po_distribution_id in number default null,
61 p_rcv_transaction_id in number default null,
62 p_vendor_id in number,
63 p_vendor_site_id in number,
64 p_input_dff_value_tds in varchar2,
65 p_input_dff_value_wct in varchar2,
66 p_old_input_dff_value_wct in varchar2, --Added by Bgowrava for Bug#5911913
67 p_input_dff_value_essi in varchar2,
68 p_old_input_dff_value_essi in varchar2, --Added by Bgowrava for Bug#5911913
69 p_org_id in number,
70 p_accounting_date in date,
71 p_call_from in varchar2,
72 p_final_tds_tax_id out nocopy number,
73 p_process_flag out nocopy varchar2,
74 p_process_message out nocopy varchar2,
75 p_codepath in out nocopy varchar2
76 );
77
78
79 procedure validate_status_for_default
80 (
81 p_invoice_id in number,
82 p_invoice_line_number in number default null,
83 p_invoice_distribution_id in number default null,
84 p_line_type_lookup_code in varchar2,
85 p_process_flag out nocopy varchar2,
86 p_process_message out nocopy varchar2,
87 p_codepath in out nocopy varchar2
88 );
89
90
91 procedure default_tds_from_receipt
92 (
93 p_invoice_id in number,
94 p_invoice_line_number in number default null,
95 p_invoice_distribution_id in number default null,
96 p_line_type_lookup_code in varchar2,
97 p_distribution_line_number in number default null, /* AP lines uptake */
98 p_rcv_transaction_id in number,
99 p_tds_section_code out nocopy varchar2,
100 p_tds_tax_id out nocopy number,
101 p_default_from out nocopy varchar2,
102 p_process_flag out nocopy varchar2,
103 P_process_message out nocopy varchar2,
104 p_codepath in out nocopy varchar2
105 );
106
107
108 procedure default_tds_from_po
109 (
110 p_invoice_id in number,
111 p_invoice_line_number in number default null,
112 p_invoice_distribution_id in number default null,
113 p_line_type_lookup_code in varchar2,
114 p_distribution_line_number in number default null, /* AP lines uptake */
115 p_po_distribution_id in number,
116 p_tds_section_code out nocopy varchar2,
117 p_tds_tax_id out nocopy number,
118 p_default_from out nocopy varchar2,
119 p_process_flag out nocopy varchar2,
120 P_process_message out nocopy varchar2,
121 p_codepath in out nocopy varchar2
122 );
123
124
125 procedure default_tds_from_setup
126 (
127 p_vendor_id in number,
128 p_vendor_site_id in number,
129 p_default_type out nocopy varchar2,
130 p_tds_section_code out nocopy varchar2,
131 p_tds_tax_id out nocopy number,
132 p_default_from out nocopy varchar2,
133 p_process_flag out nocopy varchar2,
134 P_process_message out nocopy varchar2,
135 p_codepath in out nocopy varchar2
136 );
137
138
139 procedure validate_default_tds
140 (
141 p_vendor_id in number,
142 p_vendor_site_id in number,
143 p_tds_section_code in varchar2,
144 p_tds_tax_id in number,
145 p_process_flag out nocopy varchar2,
146 P_process_message out nocopy varchar2,
147 p_codepath in out nocopy varchar2
148 );
149
150
151 procedure populate_localization_inv_tax
152 (
153 p_invoice_id in number,
154 p_invoice_line_number in number default null, /* AP lines uptake */
155 p_invoice_distribution_id in number default null, /* AP lines uptake */
156 P_distribution_line_number in number default null, /* AP lines uptake */
157 p_amount in number,
158 p_exchange_rate in number,
159 p_section_type in varchar2,
160 p_default_type in varchar2,
161 p_default_section_code in varchar2,
162 p_default_tax_id in number,
163 p_input_dff_value in varchar2,
164 p_default_from in varchar2,
165 p_vendor_id in number,
166 p_vendor_site_id in number,
167 p_org_id in number,
168 p_accounting_date in date,
169 p_line_type_lookup_code in varchar2 default null, -- mmurtuza for bug12858951
170 p_po_distribution_id in number default null, -- mmurtuza for bug12858951 Post review
171 p_rcv_transaction_id in number default null, -- mmurtuza for bug12858951 Post review
172 p_final_tds_tax_id out nocopy number,
173 p_process_flag out nocopy varchar2,
174 P_process_message out nocopy varchar2,
175 p_codepath in out nocopy varchar2
176 );
177
178 procedure get_default_tax_from_section
179 (
180 p_invoice_id in number,
181 p_invoice_line_number in number default null, /* AP lines uptake */
182 p_invoice_distribution_id in number default null, /* AP lines uptake */
183 p_vendor_id in number,
184 p_vendor_site_id in number,
185 p_amount in number,
186 p_exchange_rate in number,
187 p_tds_section_code in varchar2,
188 p_org_id in number,
189 p_accounting_date in date,
190 p_tds_tax_id out nocopy number,
191 p_threshold_grp_id out nocopy number,
192 p_cumulative_threshold_slab_id out nocopy number,
193 p_cumulative_threshold_stage out nocopy varchar2,
194 p_single_threshold_slab_id out nocopy number,
195 p_process_flag out nocopy varchar2,
196 P_process_message out nocopy varchar2,
197 p_codepath in out nocopy varchar2
198 );
199
200 procedure process_input_dff_tds
201 (
202 p_invoice_id in number,
203 p_invoice_line_number in number default null, /* AP lines uptake */
204 p_invoice_distribution_id in number default null, /* AP lines uptake */
205 p_input_tds_dff_value in varchar2,
206 p_output_tds_dff_value out nocopy varchar2,
207 p_process_flag out nocopy varchar2,
208 P_process_message out nocopy varchar2,
209 p_codepath in out nocopy varchar2
210 );
211
212
213 procedure process_delete
214 (
215 p_invoice_id in number,
216 p_invoice_line_number in number default null, /* AP lines uptake */
217 p_invoice_distribution_id in number default null,
218 p_process_flag out nocopy varchar2,
219 P_process_message out nocopy varchar2
220 );
221
222
223 procedure check_old_transaction
224 (
225 p_invoice_id in number default null,
226 p_invoice_distribution_id in number default null,
227 p_new_transaction out nocopy varchar2
228 );
229
230 END jai_ap_tds_tax_defaultation;