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