[Home] [Help]
PACKAGE: APPS.ZX_SRVC_TYP_PKG
Source
1 PACKAGE ZX_SRVC_TYP_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxifsrvctypspkgs.pls 120.28.12010000.3 2009/03/11 11:36:29 tsen ship $ */
3
4 /* ======================================================================*
5 | Data Type Definitions |
6 * ======================================================================*/
7 TYPE VARCHAR2_1_tbl_type is TABLE OF VARCHAR2(1)
8 INDEX BY BINARY_INTEGER;
9
10 TYPE VARCHAR2_2_tbl_type is TABLE OF VARCHAR2(2)
11 INDEX BY BINARY_INTEGER;
12
13 TYPE VARCHAR2_30_tbl_type is TABLE OF VARCHAR2(30)
14 INDEX BY BINARY_INTEGER;
15
16 TYPE VARCHAR2_50_tbl_type is TABLE OF VARCHAR2(50)
17 INDEX BY BINARY_INTEGER;
18
19 TYPE VARCHAR2_240_tbl_type is TABLE OF VARCHAR2(240)
20 INDEX BY BINARY_INTEGER;
21
22 TYPE NUMBER_tbl_type IS TABLE OF NUMBER(15)
23 INDEX BY BINARY_INTEGER;
24
25 TYPE NUMBER_tbl_type_1 IS TABLE OF NUMBER
26 INDEX BY BINARY_INTEGER;
27
28 -- Bug 7519403 -- Added the following declaration. commented the same in pkg body
29 TYPE l_line_level_rec_type IS RECORD(
30 trx_id NUMBER);
31
32 TYPE l_line_level_tbl_type IS TABLE OF l_line_level_rec_type INDEX BY BINARY_INTEGER;
33 l_line_level_tbl l_line_level_tbl_type;
34
35 -- Bug 8265004
36 TYPE l_line_level_rec_type1 IS RECORD(
37 trx_id NUMBER);
38
39 TYPE l_line_level_tbl_type1 IS TABLE OF l_line_level_rec_type1 INDEX BY BINARY_INTEGER;
40 l_line_level_tbl1 l_line_level_tbl_type1;
41
42 /*-----------------------------------------------------------------------*
43 | PUBLIC FUNCTIONS/PROCEDURES |
44 *-----------------------------------------------------------------------*/
45
46
47
48 /* ======================================================================*
49 | PROCEDURE Calculate_Tax : Called from published service |
50 | calculate_tax |
51 * ======================================================================*/
52 PROCEDURE Calculate_Tax(
53 p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
54 x_return_status OUT NOCOPY VARCHAR2
55 );
56
57
58
59 /* ======================================================================*
60 | PROCEDURE Import : Called from published service |
61 | import_document_with_tax |
62 * ======================================================================*/
63 PROCEDURE Import(
64 p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
65 x_return_status OUT NOCOPY VARCHAR2
66 );
67
68
69 /* ======================================================================*
70 | PROCEDURE Override_Tax_Lines : Called from published service |
71 | override_tax |
72 * ======================================================================*/
73 PROCEDURE Override_Tax_Lines(
74 p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
75 p_override_level IN VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2
77 );
78
79
80 /* ======================================================================*
81 | PROCEDURE Document_Level_Changes : Called from published service |
82 | global_document_update |
83 * ======================================================================*/
84 PROCEDURE Document_Level_Changes(
85 x_return_status OUT NOCOPY VARCHAR2,
86 p_event_class_rec IN zx_api_pub.event_class_rec_type,
87 p_tax_hold_released_code IN zx_api_pub.validation_status_tbl_type
88 );
89
90 /* ======================================================================*
91 | PROCEDURE Mark_Tax_Lines_Deleted : Called from published service |
92 | mark_tax_lines_deleted |
93 * ======================================================================*/
94 PROCEDURE mark_tax_lines_deleted(
95 p_trx_line_rec IN ZX_API_PUB.TRANSACTION_LINE_REC_TYPE ,
96 x_return_status OUT NOCOPY VARCHAR2
97 );
98
99 /* ======================================================================*
100 | PROCEDURE Reverse_Document : Called from published service |
101 | reverse_document |
102 * ======================================================================*/
103 PROCEDURE reverse_document(
104 p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
105 x_return_status OUT NOCOPY VARCHAR2
106 );
107
108
109 /* ======================================================================*
110 | PROCEDURE Reverse_distributions : Called from published service |
111 | reverse_distributions |
112 * ======================================================================*/
113 PROCEDURE Reverse_Distributions(
114 x_return_status OUT NOCOPY VARCHAR2
115 );
116
117
118
119 /* ======================================================================*
120 | PROCEDURE Determine_Recovery : Called from published service |
121 | determine_recovery |
122 * ======================================================================*/
123 PROCEDURE Determine_Recovery(
124 p_event_class_rec IN zx_api_pub.event_class_rec_type,
125 x_return_status OUT NOCOPY VARCHAR2
126 );
127
128
129 /* ======================================================================*
130 | PROCEDURE Override_Recovery : Called from published service |
131 | override_recovery |
132 * ======================================================================*/
133 PROCEDURE Override_Recovery(
134 p_event_class_rec IN zx_api_pub.event_class_rec_type,
135 x_return_status OUT NOCOPY VARCHAR2
136 );
137
138
139 /* ======================================================================*
140 | PROCEDURE Freeze_Distribution_Lines : Called from published service |
141 | freeze_distribution_lines |
142 * ======================================================================*/
143 PROCEDURE Freeze_Distribution_Lines(
144 p_event_class_rec IN zx_api_pub.event_class_rec_type,
145 x_return_status OUT NOCOPY VARCHAR2
146 );
147
148
149
150 /* ======================================================================*
151 | PROCEDURE Validate_Document_for_Tax : Called from published service |
152 | validate_document_for_tax |
153 * ======================================================================*/
154 PROCEDURE Validate_Document_for_Tax(
155 p_trx_rec IN zx_api_pub.transaction_rec_type,
156 p_event_class_rec IN zx_api_pub.event_class_rec_type,
157 x_validation_status OUT NOCOPY VARCHAR2,
158 x_hold_status_code OUT NOCOPY zx_api_pub.hold_codes_tbl_type,
159 x_return_status OUT NOCOPY VARCHAR2
160 );
161
162
163 /* ======================================================================*
164 | PROCEDURE Discard_Tax_only_lines: Called from published service |
165 | discard_tax_only_lines |
166 * ======================================================================*/
167 PROCEDURE Discard_Tax_only_lines(
168 p_event_class_rec IN zx_api_pub.event_class_rec_type ,
169 x_return_status OUT NOCOPY VARCHAR2
170 );
171
172 /* ======================================================================*
173 | PROCEDURE synchronize_tax : Called from published service |
174 | synchronize_tax_repository |
175 * ======================================================================*/
176 PROCEDURE synchronize_tax(
177 p_event_class_rec IN zx_api_pub.event_class_rec_type ,
178 x_return_status OUT NOCOPY VARCHAR2
179 );
180
181 /* ======================================================================*
182 | PROCEDURE insupd_line_det_factors: Called from published service |
183 | insert_line_det_factors/ |
184 | update_line_det_factors |
185 * ======================================================================*/
186
187 PROCEDURE insupd_line_det_factors(
188 p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type ,
189 x_return_status OUT NOCOPY VARCHAR2
190 );
191
192 /* =============================================================================*
193 | PROCEDURE zx_lines_table_handler: Handles inserts/updates/deletes to zx_lines|
194 * ============================================================================*/
195 PROCEDURE zx_lines_table_handler
196 (
197 p_event_class_rec IN ZX_API_PUB.event_class_rec_type ,
198 p_event IN VARCHAR2,
199 p_tax_regime_code IN VARCHAR2,
200 p_provider_id IN NUMBER,
201 x_return_status OUT NOCOPY VARCHAR2
202 );
203
204 /* ===========================================================================*
205 | PROCEDURE Get_Tax_Profile_Ids : Populates party tax profile ids |
206 * ===========================================================================*/
207 PROCEDURE Get_Tax_Profile_Ids
208 (
209 x_return_status OUT NOCOPY VARCHAR2,
210 p_party_type_Code IN VARCHAR2,
211 p_party_id IN NUMBER,
212 p_party_loc_id IN NUMBER,
213 p_party_site_id IN NUMBER,
214 x_tax_prof_id OUT NOCOPY NUMBER
215 );
216
217
218 /* ===========================================================================*
219 | PROCEDURE Default_tax_attrs_wrapper : Overloaded procedure acts as a wrapper|
220 | to default_tax_attribs procedure to default the tax determining attributes. |
221 * ===========================================================================*/
222
223 PROCEDURE default_tax_attrs_wrapper
224 (
225 p_trx_line_index IN NUMBER,
226 p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
227 x_return_status OUT NOCOPY VARCHAR2
228 ) ;
229
230
231 /* =========================================================================*
232 | PROCEDURE get_default_tax_det_attribs : Overloaded procedure that accepts|
233 | inputs in GTT, calls the redefaulting APIs and updates the determining |
234 | attributes back to GTT |
235 * ========================================================================*/
236
237 PROCEDURE get_default_tax_det_attrs
238 (
239 p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
240 x_return_status OUT NOCOPY VARCHAR2
241 ) ;
242
243 /* =========================================================================*
244 | PROCEDURE decide_call_redefault_APIs : Determine if there is a need to |
245 | default/redefault the tax determining attributes |
246 * ========================================================================*/
247 FUNCTION decide_call_redefault_APIs
248 (
249 p_trx_line_index IN BINARY_INTEGER
250 ) RETURN BOOLEAN ;
251
252 /* =========================================================================*
253 | PROCEDURE call_redefaulting_APIs : Calls the redefaulting APIs in case of|
254 | UPDATE line level action |
255 * ========================================================================*/
256 PROCEDURE call_redefaulting_APIs
257 (p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
258 p_trx_line_index IN BINARY_INTEGER,
259 x_return_status OUT NOCOPY VARCHAR2
260 );
261
262
263 END ZX_SRVC_TYP_PKG;
264