1 PACKAGE JAI_AP_ST_REVERSE_PROCESS AUTHID CURRENT_USER AS
2 --$Header: jai_ap_st_reverse_process.pls 120.1.12020000.1 2012/12/21 08:44:06 qioliu noship $
3
4 /*
5 REM +======================================================================+
6 REM Created By : Chong
7 REM Creation Date : Jun 5, 2012
8 REM Bug Number/ER Name : Reverse charge service tax
9 REM SubProgram Name :
10 REM Type : Process API
11 REM Purpose : Update CCID fro reverse charge service tax line
12 REM when org_id or location changed
13 REM
14 REM TDD Reference :
15 REM
16 REM Assumptions :
17 REM
18 REM Parameter IN/OUT Type Required Description and Purpose
19 REM ----------------------- ------ ------------------ ---------- ------------------------------------
20 REM pn_invoice_id IN NUMBER Y invoice id.
21 REM pn_line_number IN NUMBER Y invoice line number
22 REM pn_org_id IN NUMBER Y organization ID
23 REM pn_location_id IN NUMBER Y location ID
24 REM
25 REM CALLED BY
26 REM JAI_AP_STND_TAX_PROCESS.UPDATE_CCID
27 REM +=====================================================================================================+
28 */
29 PROCEDURE UPDATE_CCID(pn_invoice_id IN NUMBER,
30 pn_line_number IN NUMBER,
31 pn_org_id IN NUMBER,
32 pn_location_id IN NUMBER);
33
34 /*
35 REM +======================================================================+
36 REM Created By : Chong
37 REM Creation Date : Jun 5, 2012
38 REM Bug Number/ER Name : Reverse charge service tax
39 REM SubProgram Name : Get_ST_Reverse_Ccid
40 REM Type : Process API
41 REM Purpose : Get CCID from regime by tax type and accounting type.
42 REM
43 REM
44 REM TDD Reference :
45 REM
46 REM Assumptions :
47 REM
48 REM Parameter IN/OUT Type Required Description and Purpose
49 REM ----------------------- ------ ------------------ ---------- ------------------------------------
50 REM pn_invoice_id IN NUMBER Y invoice id.
51 REM pn_item_line_number IN NUMBER Y invoice line number
52 REM pn_organization_id IN NUMBER Y organization ID
53 REM pn_location_id IN NUMBER Y location ID
54 REM pn_tax_type_code IN VARCHAR2 Y tax type
55 REM pn_tax_acct_ccid IN NUMBER Y tax CCID
56 REM pv_tax_type IN VARCHAR2 Y tax type about recoverable
57 REM pv_ac_type IN VARCHAR2 Y Accounting type in regime
58 REM
59 REM CALLED BY
60 REM JAI_AP_ST_REVERSE_PROCESS.Populate_ST_RVRS_Dist
61 REM +=====================================================================================================+
62 */
63 FUNCTION Get_ST_Reverse_Ccid
64 ( pn_invoice_id IN NUMBER
65 , pn_item_line_number IN NUMBER
66 , pn_organization_id IN NUMBER
67 , pn_location_id IN NUMBER
68 , pn_tax_type_code IN VARCHAR2
69 , pn_tax_acct_ccid IN NUMBER
70 , pv_tax_type IN VARCHAR2
71 , pv_ac_type IN VARCHAR2
72 ) RETURN NUMBER;
73
74
75 /*
76 REM +======================================================================+
77 REM Created By : Chong
78 REM Creation Date : Jun 5, 2012
79 REM Bug Number/ER Name : Reverse charge service tax
80 REM SubProgram Name : Populate_ST_RVRS_Dist
81 REM Type : Process API
82 REM Purpose : Populate tax lines for reverse charge service in stand alone invoice
83 REM
84 REM
85 REM TDD Reference :
86 REM
87 REM Assumptions :
88 REM
89 REM Parameter IN/OUT Type Required Description and Purpose
90 REM ----------------------- ------ ------------------ ---------- ------------------------------------
91 REM pn_invoice_id IN NUMBER Y invoice id.
92 REM pn_line_number IN NUMBER Y invoice line number
93 REM
94 REM CALLED BY
95 REM JAI_AP_STND_TAX_PROCESS.Create_Tax_Lines
96 REM +=====================================================================================================+
97 */
98 PROCEDURE Populate_ST_RVRS_Dist
99 ( pn_invoice_id IN NUMBER
100 , pn_line_number IN NUMBER DEFAULT NULL
101 );
102
103 /*
104 REM +======================================================================+
105 REM Created By : Chong
106 REM Creation Date : Jun 5, 2012
107 REM Bug Number/ER Name : Reverse charge service tax
108 REM SubProgram Name : Populate_MTCH_ST_RVRS_Dist
109 REM Type : Process API
110 REM Purpose : Populate reverse charge service tax lines for AP/AR match invoice line
111 REM
112 REM
113 REM TDD Reference :
114 REM
115 REM Assumptions :
116 REM
117 REM Parameter IN/OUT Type Required Description and Purpose
118 REM ----------------------- ------ ------------------ ---------- ------------------------------------
119 REM inv_id IN NUMBER Y
120 REM pn_invoice_line_number IN NUMBER Y
121 REM po_dist_id IN NUMBER Y
122 REM qty_inv IN NUMBER Y
123 REM p_shipment_header_id IN NUMBER Y
124 REM p_packing_slip_num IN VARCHAR2 Y
125 REM p_receipt_code IN VARCHAR2 Y
126 REM p_rematch IN VARCHAR2 Y
127 REM rcv_tran_id IN NUMBER Y
128 REM v_dist_amount IN NUMBER Y
129 REM v_org_id IN NUMBER Y
130 REM p_project_id IN NUMBER Y
131 REM p_task_id IN NUMBER Y
132 REM p_expenditure_type IN VARCHAR2 Y
133 REM p_expenditure_organization_id IN NUMBER Y
134 REM p_expenditure_item_date IN NUMBER Y
135 REM p_caid IN NUMBER Y
136 REM errbuf OUT VARCHAR2 Y
137 REM retcode OUT VARCHAR2 Y
138 REM
139 REM CALLED BY
140 REM JAI_AP_MATCH_TAX_PKG.process_online
141 REM +=====================================================================================================+
142 */
143 PROCEDURE Populate_MTCH_ST_RVRS_Dist
144 (
145 errbuf OUT NOCOPY VARCHAR2,
146 retcode OUT NOCOPY VARCHAR2,
147 inv_id IN NUMBER,
148 pn_invoice_line_number IN NUMBER, -- Using pn_invoice_line_number instead of dist_line_no for Bug#4445989
149 po_dist_id IN NUMBER,
150 qty_inv IN NUMBER,
151 p_shipment_header_id IN NUMBER,
152 p_packing_slip_num IN VARCHAR2,
153 p_receipt_code VARCHAR2,
154 p_rematch VARCHAR2,
155 rcv_tran_id IN NUMBER,
156 v_dist_amount IN NUMBER,
157 v_org_id IN NUMBER
158 , p_project_id NUMBER
159 , p_task_id NUMBER
160 , p_expenditure_type VARCHAR2
161 , p_expenditure_organization_id NUMBER
162 , p_expenditure_item_date DATE
163 , p_caid NUMBER
164 );
165
166 /*
167 REM +======================================================================+
168 REM Created By : Chong
169 REM Creation Date : Jun 5, 2012
170 REM Bug Number/ER Name : Reverse charge service tax
171 REM SubProgram Name : process_batch_record
172 REM Type : Process API
173 REM Purpose : Populate reverse charge service tax lines for ERS invoice
174 REM
175 REM
176 REM TDD Reference :
177 REM
178 REM Assumptions :
179 REM
180 REM Parameter IN/OUT Type Required Description and Purpose
181 REM ----------------------- ------ ------------------ ---------- ------------------------------------
182 REM inv_id IN NUMBER Y
183 REM pn_invoice_line_number IN NUMBER Y
184 REM po_dist_id IN NUMBER Y
185 REM qty_inv IN NUMBER Y
186 REM p_shipment_header_id IN NUMBER Y
187 REM p_packing_slip_num IN VARCHAR2 Y
188 REM p_receipt_code IN VARCHAR2 Y
189 REM p_rematch IN VARCHAR2 Y
190 REM rcv_tran_id IN NUMBER Y
191 REM v_dist_amount IN NUMBER Y
192 REM v_org_id IN NUMBER Y
193 REM p_project_id IN NUMBER Y
194 REM p_task_id IN NUMBER Y
195 REM p_expenditure_type IN VARCHAR2 Y
196 REM p_expenditure_organization_id IN NUMBER Y
197 REM p_expenditure_item_date IN NUMBER Y
198 REM p_caid IN NUMBER Y
199 REM err_mesg OUT VARCHAR2 Y
200 REM
201 REM CALLED BY
202 REM JAI_AP_MATCH_TAX_PKG.process_batch_record
203 REM +=====================================================================================================+
204 */
205 PROCEDURE process_batch_record (
206 err_mesg OUT NOCOPY VARCHAR2,
207 inv_id IN NUMBER,
208 pn_invoice_line_number IN NUMBER,
209 po_dist_id IN NUMBER,
210 qty_inv IN NUMBER,
211 p_shipment_header_id IN NUMBER,
212 p_packing_slip_num IN VARCHAR2,
213 p_receipt_code VARCHAR2,
214 p_rematch VARCHAR2,
215 rcv_tran_id IN NUMBER,
216 v_dist_amount IN NUMBER,
217 v_org_id IN NUMBER
218 ,p_project_id NUMBER
219 ,p_task_id NUMBER
220 ,p_expenditure_type VARCHAR2
221 ,p_expenditure_organization_id NUMBER
222 ,p_expenditure_item_date DATE
223 ,p_caid IN NUMBER
224 );
225
226 END JAI_AP_ST_REVERSE_PROCESS;