1 PACKAGE JAI_AP_STND_TAX_PROCESS AUTHID CURRENT_USER AS
2 --$Header: jaiapprcs.pls 120.3 2010/09/06 10:12:06 mbremkum ship $
3
4 --+=======================================================================+
5 --| Copyright (c) 2007 Oracle Corporation
6 --| Redwood Shores, CA, USA
7 --| All rights reserved.
8 --+=======================================================================
9 --| FILENAME
10 --| jai_ap_stnd_tax_process.pls
11 --|
12 --| DESCRIPTION
13 --|
14 --| This package contains the following PL/SQL tables/procedures/functions
15 --| to process and populate tax lines for the standard lone invoices
16 --|
17 --|
18 --|
19 --|
20 --|
21 --| TYPE LIEST
22 --|
23 --|
24 --| PROCEDURE LIST
25 --| Populate_Stnd_Inv_Taxes
26 --| Create_Tax_Lines
27 --| Default_Calculate_Taxes
28 --|
29 --|
30 --| HISTORY
31 --| 23-Aug-2007 Eric Ma Created
32 --|
33 --+======================================================================*/
34
35 GV_MODULE_PREFIX VARCHAR2 (100) := 'jai.plsql.JAI_AP_STND_TAX_PROCESS';
36 GV_CONSTANT_MISCELLANEOUS VARCHAR2 (20) := 'MISCELLANEOUS';
37 GV_CONSTANT_ITEM VARCHAR2 (20) := 'ITEM';
38 GV_NOT_MATCH_TYPE VARCHAR2 (20) := 'NOT_MATCHED';
39 GV_JAI_AP_INVOICE_LINES VARCHAR2 (100) := 'JAI_AP_INVOICE_LINES';
40 GV_LINES_CREATEED VARCHAR2 (10) := 'NO';
41 --==========================================================================
42 -- PROCEDURE NAME:
43 --
44 -- Populate_Stnd_Inv_Taxes Public
45 --
46 -- DESCRIPTION:
47 --
48 -- This procedure is main entrance procedure used by form and invokes the
49 -- create_tax_line procedure
50 --
51 -- PARAMETERS:
52 -- In: pn_invoice_id NUMBER
53 -- pn_line_number NUMBER
54 -- pn_vendor_site_id NUMBER
55 -- pv_currency VARCHAR2
56 -- pn_line_amount NUMBER
57 -- pn_tax_category_id NUMBER
58 -- pv_tax_modified VARCHAR2
59 --
60 --
61 -- Out:
62 --
63 -- PRE-COND : invoice is valid
64 --
65 -- EXCEPTIONS: defualt tax are created
66 --
67 --===========================================================================
68
69 PROCEDURE Populate_Stnd_Inv_Taxes
70 ( pn_invoice_id IN NUMBER
71 , pn_line_number IN NUMBER
72 , pn_vendor_site_id IN NUMBER
73 , pv_currency IN VARCHAR2
74 , pn_line_amount IN NUMBER DEFAULT NULL
75 , pn_tax_category_id IN NUMBER DEFAULT NULL
76 , pv_tax_modified IN VARCHAR2
77 , pn_old_tax_category_id in VARCHAR2 DEFAULT NULL
78 );
79
80 --==========================================================================
81 -- PROCEDURE NAME:
82 --
83 -- Create_Tax_Lines Public
84 --
85 -- DESCRIPTION:
86 --
87 -- This procedure is to create tax invoice line and distribution line in
88 -- both standard tables of ap module and jai ap modules
89 --
90 -- PARAMETERS:
91 -- In: pn_organization_id NUMBER organization id
92 -- pv_currency VARCHAR2 currency
93 -- pn_location_id NUMBER location id
94 -- pn_invoice_id NUMBER invoice id
95 -- pn_line_number NUMBER item line number
96 -- pv_action VARCHAR2 normally it is DEFAULT_TAXES,it can
97 -- be jai_constants.recalculate_taxes
98 -- pn_tax_category_id NUMBER tax category id
99 --
100 --
101 -- Out:
102 --
103 --
104 -- PRE-COND : invoice is valid
105 --
106 -- EXCEPTIONS: defualt tax are created
107 --
108 --===========================================================================
109
110
111
112
113
114 PROCEDURE Create_Tax_Lines
115 (
116 pn_organization_id IN NUMBER
117 , pv_currency IN VARCHAR2
118 , pn_location_id IN NUMBER
119 , pn_invoice_id IN NUMBER
120 , pn_line_number IN NUMBER DEFAULT NULL
121 , pv_action IN VARCHAR2 DEFAULT jai_constants.default_taxes
122 , pn_tax_category_id IN NUMBER
123 , pv_tax_modified IN VARCHAR2
124 );
125
126 --==========================================================================
127 -- PROCEDURE NAME:
128 --
129 -- Default_Calculate_Taxes Public
130 --
131 -- DESCRIPTION:
132 --
133 -- This procedure is to invoke standard procedure to insert item
134 -- information into jai_cmn_document_taxes
135 --
136 -- PARAMETERS:
137 -- In:
138 -- pn_invoice_id IN NUMBER invoice id
139 -- pn_line_number IN NUMBER item line number
140 -- xn_tax_amount IN OUT NOCOPY NUMBER line tax amount
141 -- pn_vendor_id IN NUMBER vendor/supplier id
142 -- pn_vendor_site_id IN NUMBER vendor/supplier site id
143 -- pv_currency_code IN VARCHAR2 currency code
144 -- pn_tax_category_id IN NUMBER tax category id
145 -- pv_tax_modified IN VARCHAR2 a flag indicating whether
146 -- tax modified in line level
147 --
148 --
149 -- Out:
150 --
151 --
152 --
153 -- PRE-COND : invoice is valid
154 --
155 -- EXCEPTIONS: defualt tax are created
156 --
157 --===========================================================================
158 PROCEDURE Default_Calculate_Taxes
159 ( pn_invoice_id IN NUMBER
160 , pn_line_number IN NUMBER
161 , xn_tax_amount IN OUT NOCOPY NUMBER
162 , pn_vendor_id IN NUMBER
163 , pn_vendor_site_id IN NUMBER
164 , pv_currency_code IN VARCHAR2
165 , pn_tax_category_id IN NUMBER
166 , pv_tax_modified IN VARCHAR2
167 );
168
169 --==========================================================================
170 -- PROCEDURE NAME:
171 --
172 -- UPDATE_CCID Public
173 --
174 -- DESCRIPTION:
175 --
176 -- This procedure updates the Distribution Accounts based on Regime Setup
177 -- if Organization or Location are changed
178 --
179 -- PARAMETERS:
180 -- In: pn_invoice_id number
181 -- pn_line_number NUMBER
182 -- pn_org_id NUMBER
183 -- pn_location_id NUMBER
184 --
185 --
186 -- Out:
187 --
188 -- CHANGE HISTORY:
189 --
190 -- 1 10-Jun-2010 Created - Added for Bug 9626284
191 --===========================================================================
192
193 PROCEDURE UPDATE_CCID(pn_invoice_id IN NUMBER,
194 pn_line_number IN NUMBER,
195 pn_org_id IN NUMBER,
196 pn_location_id IN NUMBER);
197
198 END JAI_AP_STND_TAX_PROCESS;