1 PACKAGE JAI_AP_STND_TAX_PROCESS AS
2 --$Header: jaiapprcs.pls 120.2.12010000.1 2008/11/18 04:33:05 sshinde 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 -- PROCEDURE NAME:
81 --
82 -- Create_Tax_Lines Public
83 --
84 -- DESCRIPTION:
85 --
86 -- This procedure is to create tax invoice line and distribution line in
87 -- both standard tables of ap module and jai ap modules
88 --
89 -- PARAMETERS:
90 -- In: pn_organization_id NUMBER organization id
91 -- pv_currency VARCHAR2 currency
92 -- pn_location_id NUMBER location id
93 -- pn_invoice_id NUMBER invoice id
94 -- pn_line_number NUMBER item line number
95 -- pv_action VARCHAR2 normally it is DEFAULT_TAXES,it can
96 -- be jai_constants.recalculate_taxes
97 -- pn_tax_category_id NUMBER tax category id
98 --
99 --
100 -- Out:
101 --
102 --
103 -- PRE-COND : invoice is valid
104 --
105 -- EXCEPTIONS: defualt tax are created
106 --
107 --===========================================================================
108
109
110
111
112
113 PROCEDURE Create_Tax_Lines
114 (
115 pn_organization_id IN NUMBER
116 , pv_currency IN VARCHAR2
117 , pn_location_id IN NUMBER
118 , pn_invoice_id IN NUMBER
119 , pn_line_number IN NUMBER DEFAULT NULL
120 , pv_action IN VARCHAR2 DEFAULT jai_constants.default_taxes
121 , pn_tax_category_id IN NUMBER
122 , pv_tax_modified IN VARCHAR2
123 );
124
125 --==========================================================================
126 -- PROCEDURE NAME:
127 --
128 -- Default_Calculate_Taxes Public
129 --
130 -- DESCRIPTION:
131 --
132 -- This procedure is to invoke standard procedure to insert item
133 -- information into jai_cmn_document_taxes
134 --
135 -- PARAMETERS:
136 -- In:
137 -- pn_invoice_id IN NUMBER invoice id
138 -- pn_line_number IN NUMBER item line number
139 -- xn_tax_amount IN OUT NOCOPY NUMBER line tax amount
140 -- pn_vendor_id IN NUMBER vendor/supplier id
141 -- pn_vendor_site_id IN NUMBER vendor/supplier site id
142 -- pv_currency_code IN VARCHAR2 currency code
143 -- pn_tax_category_id IN NUMBER tax category id
144 -- pv_tax_modified IN VARCHAR2 a flag indicating whether
145 -- tax modified in line level
146 --
147 --
148 -- Out:
149 --
150 --
151 --
152 -- PRE-COND : invoice is valid
153 --
154 -- EXCEPTIONS: defualt tax are created
155 --
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 END JAI_AP_STND_TAX_PROCESS;