1 PACKAGE ZX_TRL_PUB_PKG AS
2 /* $Header: zxrwlnrepsrvpubs.pls 120.16 2005/05/20 22:35:44 lxzhang ship $ */
3
4 -- Start of comments
5 -- API name : Manage_TaxLines
6 -- Type : Public
7 -- Function : This will create, update, delete and cancel tax lines and summary
8 -- tax lines in the tax repository
9 -- Pre-reqs : None.
10 -- Parameters :
11 -- IN : p_event_class_details IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
12 -- OUT : x_return_status OUT VARCHAR2(1)
13 -- Version : Current version 1.0
14 -- WHO WHEN WHAT
15 -- prgoyal 22-Nov-2002 1. Removed IN parameter for lines pl/sql table
16 -- prgoyal 6-Dec-2002 Addded No COPY in spec and in body changed the code to
17 -- refer to global temporary tables.
18 -- Notes : None.
19 --
20 -- End of comments
21 PROCEDURE Manage_TaxLines
22 (
23 x_return_status OUT NOCOPY VARCHAR2 ,
24 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
25 );
26 -- Start of comments
27 -- API name : Synchronize_TaxLines
28 -- Type : Public
29 -- Function : Updates Tax Repository
30 -- Pre-reqs : None.
31 -- Parameters :
32 -- OUT : x_return_status OUT VARCHAR2(1)
33 -- Version : Current version 1.0
34 -- WHO WHEN WHAT
35 -- prgoyal 6-Dec-2002 Addded No COPY in spec
36 -- Notes : None.
37 --
38 -- End of comments
39 PROCEDURE Synchronize_TaxLines
40 (
41 x_return_status OUT NOCOPY VARCHAR2
42 );
43 -- Start of comments
44 -- API name : Document_Level_Changes
45 -- Type : Public
46 -- Function : Delete / Cancel / Purge tax lines from the tax repository
47 -- Pre-reqs : None.
48 -- Parameters :
49 -- IN : p_transaction_tbl IN ZX_API_PUB.TRANSACTION_REC_TYPE
50 -- OUT : x_return_status OUT VARCHAR2(1)
51 -- Version : Current version 1.0
52 -- WHO WHEN WHAT
53 -- prgoyal 6-Dec-2002 Addded No COPY in spec and in body changed the code to
54 -- refer to global temporary tables and also changes as per HLD.
55 -- Notes : None.
56 --
57 -- End of comments
58 PROCEDURE Document_Level_Changes
59 (x_return_status OUT NOCOPY VARCHAR2,
60 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
61 p_tax_hold_released_code IN ZX_API_PUB.VALIDATION_STATUS_TBL_TYPE);
62
63 -- Start of comments
64 -- API name : Mark_Tax_Lines_Delete
65 -- Type : Public
66 -- Function : Mark the tax lines as deleted by updating the delete flag
67 -- Pre-reqs : None.
68 -- Parameters :
69 -- IN : p_transaction_line_rec IN ZX_API_PUB.TRANSACTION_LINE_REC_TYPE
70 -- OUT : x_return_status OUT VARCHAR2(1)
71 -- Version : Current version 1.0
72 -- WHO WHEN WHAT
73 -- prgoyal 6-Dec-2002 Created as per HLD TAX RECording Phase1A
74 -- Notes : None.
75 --
76 -- End of comments
77 PROCEDURE Mark_Tax_Lines_Delete
78 (
79 x_return_status OUT NOCOPY VARCHAR2 ,
80 p_transaction_line_rec IN ZX_API_PUB.TRANSACTION_LINE_REC_TYPE
81 );
82
83 -- Start of comments
84 -- API name : Manage_TaxDistributions
85 -- Type : Public
86 -- Function : This recording service is used to create, update, delete
87 -- tax distributions lines and update tax lines and summary
88 -- tax lines in the tax repository
89 -- Pre-reqs : None.
90 -- Parameters :
91 -- IN : p_transaction_rec IN ZX_API_PUB.TRANSACTION_REC_TYPE
92 -- OUT : x_return_status OUT VARCHAR2(1)
93 -- Version : Current version 1.0
94 -- Notes : None.
95 --
96 -- End of comments
97
98 PROCEDURE Manage_TaxDistributions
99 (
100 x_return_status OUT NOCOPY VARCHAR2,
101 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
102 );
103
104 -- Start of comments
105 -- API name : Freeze_TaxDistributions
106 -- Type : Public
107 -- Function : This recording service is used to freeze tax distributions
108 -- whenever user freezes transaction distribution lines
109 -- Pre-reqs : None.
110 -- Parameters :
111 -- IN : p_event_class_details IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
112 -- OUT : x_return_status OUT VARCHAR2(1)
113 -- Version : Current version 1.0
114 -- Notes : None.
115 PROCEDURE Freeze_TaxDistributions
116 (
117 x_return_status OUT NOCOPY VARCHAR2,
118 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
119 );
120
121
122 -- Start of comments
123 -- API name : Update_Taxlines
124 -- Type : Public
125 -- Function : This recording service is used to update tax lines (ZX_LINES)
126 -- with changed status for given transaction line distributions.
127 -- Pre-reqs : None.
128 -- Parameters :
129 -- IN : p_event_class_details IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
130 -- OUT : x_return_status OUT VARCHAR2(1)
131 -- Version : Current version 1.0
132 -- Notes : None.
133
134 PROCEDURE Update_Taxlines
135 (x_return_status OUT NOCOPY VARCHAR2,
136 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE);
137
138
139 -- Start of comments
140 -- API name : Discard_Tax_Only_Lines
141 -- Type : Public.
142 -- Function : This recording service is used to discard tax lines
143 -- and tax distributions, marked with tax_only status.
144 -- This service will be called by TSRM.
145 -- Pre-reqs : None.
146 -- Parameters :
147 -- IN : x_event_class_rec_type IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
148 -- OUT : x_return_status OUT VARCHAR2(1)
149 -- Version : Current version 1.0
150 -- Notes : None.
151 --
152 -- End of comments
153
154 PROCEDURE Discard_Tax_Only_Lines
155 (x_return_status OUT NOCOPY VARCHAR2,
156 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE);
157
158 -- Start of comments
159 -- API name : Update_GL_Date
160 -- Type : Public.
161 -- Function : This recording service is used to obtain the GL Date
162 -- for the tax distributions. This service will be called
163 -- by TSRM.
164 -- Pre-reqs : None.
165 -- Parameters :
166 -- IN : GL_DATE IN DATE
167 -- OUT : x_return_status OUT NOCOPY VARCHAR2(30)
168 -- Version : Current version 1.0
169 -- Notes : None.
170 --
171 -- End of comments
172
173 PROCEDURE Update_GL_Date
174 (p_gl_date IN DATE,
175 x_return_status OUT NOCOPY VARCHAR2);
176
177 -- Start of comments
178 -- API name : Update_Exchange_Rate
179 -- Type : Public.
180 -- Function : This recordin service is used to modify the tax amounts
181 -- needed to be calculated in functional currency using
182 -- the exchange rate and rounding needs to be done too.
183 -- Pre-reqs : None.
184 -- Parameters :
185 -- IN : p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
186 -- p_functional_currency_flg IN VARCHAR2
187 -- OUT : x_return_status OUT NOCOPY VARCHAR2(30)
188 -- Version : Current version 1.0
189 -- Notes : None.
190 --
191 -- End of comments
192
193 PROCEDURE Update_Exchange_Rate
194 (p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
195 x_return_status OUT NOCOPY VARCHAR2);
196
197 --
198 -- API name : delete_tax_lines_and_dists
199 -- Type : Public
200 -- Function : Delete all the detail tax lines and distributions of the
201 -- passed-in transaction line from zx_lines and
202 -- zx_rec_nrec_dist.
203 --
204
205 PROCEDURE delete_tax_lines_and_dists
206 (
207 p_application_id IN NUMBER,
208 p_entity_code IN VARCHAR2,
209 p_event_class_code IN VARCHAR2,
210 p_trx_id IN NUMBER,
211 p_trx_line_id IN NUMBER,
212 p_trx_level_type IN VARCHAR2,
213 x_return_status OUT NOCOPY VARCHAR2
214 );
215
216 --
217 -- API name : delete_tax_dists
218 -- Type : Public
219 -- Function : Delete all the detail tax distributions of the
220 -- passed-in transaction line from zx_rec_nrec_dist.
221 --
222
223 PROCEDURE delete_tax_dists
224 (
225 p_application_id IN NUMBER,
226 p_entity_code IN VARCHAR2,
227 p_event_class_code IN VARCHAR2,
228 p_trx_id IN NUMBER,
229 p_trx_line_id IN NUMBER,
230 p_trx_level_type IN VARCHAR2,
231 x_return_status OUT NOCOPY VARCHAR2
232 );
233
234 -- bug fix begin 4381349 end
235
236 END ZX_TRL_PUB_PKG;