1 PACKAGE jai_ap_tds_tax_defaultation AS
2 /* $Header: jai_ap_tds_dflt.pls 120.3.12010000.1 2008/07/29 10:04:32 appldev 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 ---------------------------------------------------------------------------- */
34
35 procedure process_invoice
36 (
37 p_invoice_id in number,
38 p_invoice_line_number in number default null,
39 p_invoice_distribution_id in number default null,
40 p_line_type_lookup_code in varchar2,
41 p_distribution_line_number in number,
42 p_parent_reversal_id in number,
43 p_reversal_flag in varchar2,
44 p_amount in number,
45 p_invoice_currency_code in varchar2,
46 p_exchange_rate in number,
47 p_set_of_books_id in number,
48 p_po_distribution_id in number default null,
49 p_rcv_transaction_id in number default null,
50 p_vendor_id in number,
51 p_vendor_site_id in number,
52 p_input_dff_value_tds in varchar2,
53 p_input_dff_value_wct in varchar2,
54 p_input_dff_value_essi in varchar2,
55 p_org_id in number,
56 p_accounting_date in date,
57 p_call_from in varchar2,
58 p_final_tds_tax_id out nocopy number,
59 p_process_flag out nocopy varchar2,
60 p_process_message out nocopy varchar2,
61 p_codepath in out nocopy varchar2
62 );
63
64
65 procedure validate_status_for_default
66 (
67 p_invoice_id in number,
68 p_invoice_line_number in number default null,
69 p_invoice_distribution_id in number default null,
70 p_line_type_lookup_code in varchar2,
71 p_process_flag out nocopy varchar2,
72 p_process_message out nocopy varchar2,
73 p_codepath in out nocopy varchar2
74 );
75
76
77 procedure default_tds_from_receipt
78 (
79 p_invoice_id in number,
80 p_invoice_line_number in number default null,
81 p_invoice_distribution_id in number default null,
82 p_line_type_lookup_code in varchar2,
83 p_distribution_line_number in number default null, /* AP lines uptake */
84 p_rcv_transaction_id in number,
85 p_tds_section_code out nocopy varchar2,
86 p_tds_tax_id out nocopy number,
87 p_default_from out nocopy varchar2,
88 p_process_flag out nocopy varchar2,
89 P_process_message out nocopy varchar2,
90 p_codepath in out nocopy varchar2
91 );
92
93
94 procedure default_tds_from_po
95 (
96 p_invoice_id in number,
97 p_invoice_line_number in number default null,
98 p_invoice_distribution_id in number default null,
99 p_line_type_lookup_code in varchar2,
100 p_distribution_line_number in number default null, /* AP lines uptake */
101 p_po_distribution_id in number,
102 p_tds_section_code out nocopy varchar2,
103 p_tds_tax_id out nocopy number,
104 p_default_from out nocopy varchar2,
105 p_process_flag out nocopy varchar2,
106 P_process_message out nocopy varchar2,
107 p_codepath in out nocopy varchar2
108 );
109
110
111 procedure default_tds_from_setup
112 (
113 p_vendor_id in number,
114 p_vendor_site_id in number,
115 p_default_type out nocopy varchar2,
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 validate_default_tds
126 (
127 p_vendor_id in number,
128 p_vendor_site_id in number,
129 p_tds_section_code in varchar2,
130 p_tds_tax_id in number,
131 p_process_flag out nocopy varchar2,
132 P_process_message out nocopy varchar2,
133 p_codepath in out nocopy varchar2
134 );
135
136
137 procedure populate_localization_inv_tax
138 (
139 p_invoice_id in number,
140 p_invoice_line_number in number default null, /* AP lines uptake */
141 p_invoice_distribution_id in number default null, /* AP lines uptake */
142 P_distribution_line_number in number default null, /* AP lines uptake */
143 p_amount in number,
144 p_exchange_rate in number,
145 p_section_type in varchar2,
146 p_default_type in varchar2,
147 p_default_section_code in varchar2,
148 p_default_tax_id in number,
149 p_input_dff_value in varchar2,
150 p_default_from in varchar2,
151 p_vendor_id in number,
152 p_vendor_site_id in number,
153 p_org_id in number,
154 p_accounting_date in date,
155 p_final_tds_tax_id out nocopy number,
156 p_process_flag out nocopy varchar2,
157 P_process_message out nocopy varchar2,
158 p_codepath in out nocopy varchar2
159 );
160
161 procedure get_default_tax_from_section
162 (
163 p_invoice_id in number,
164 p_invoice_line_number in number default null, /* AP lines uptake */
165 p_invoice_distribution_id in number default null, /* AP lines uptake */
166 p_vendor_id in number,
167 p_vendor_site_id in number,
168 p_amount in number,
169 p_exchange_rate in number,
170 p_tds_section_code in varchar2,
171 p_org_id in number,
172 p_accounting_date in date,
173 p_tds_tax_id out nocopy number,
174 p_threshold_grp_id out nocopy number,
175 p_cumulative_threshold_slab_id out nocopy number,
176 p_cumulative_threshold_stage out nocopy varchar2,
177 p_single_threshold_slab_id out nocopy number,
178 p_process_flag out nocopy varchar2,
179 P_process_message out nocopy varchar2,
180 p_codepath in out nocopy varchar2
181 );
182
183 procedure process_input_dff_tds
184 (
185 p_invoice_id in number,
186 p_invoice_line_number in number default null, /* AP lines uptake */
187 p_invoice_distribution_id in number default null, /* AP lines uptake */
188 p_input_tds_dff_value in varchar2,
192 p_codepath in out nocopy varchar2
189 p_output_tds_dff_value out nocopy varchar2,
190 p_process_flag out nocopy varchar2,
191 P_process_message out nocopy varchar2,
193 );
194
195
196 procedure process_delete
197 (
198 p_invoice_id in number,
199 p_invoice_line_number in number default null, /* AP lines uptake */
200 p_invoice_distribution_id in number default null,
201 p_process_flag out nocopy varchar2,
202 P_process_message out nocopy varchar2
203 );
204
205
206 procedure check_old_transaction
207 (
208 p_invoice_id in number default null,
209 p_invoice_distribution_id in number default null,
210 p_new_transaction out nocopy varchar2
211 );
212
213 END jai_ap_tds_tax_defaultation;