1 PACKAGE ZX_TDS_APPLICABILITY_DETM_PKG AS
2 /* $Header: zxditaxapplipkgs.pls 120.31 2006/01/28 06:20:57 hongliu ship $ */
3
4 /* TYPE classmap_rec_type is RECORD (
5 tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%TYPE,
6 normal_sign_flag zx_evnt_cls_mappings.normal_sign_flag%TYPE
7 total_tx_line_sum_template
8 zx_evnt_cls_mappings.total_tx_line_sum_template%TYPE,
9 rec_tx_line_sum_template
10 zx_evnt_cls_mappings.rec_tx_line_sum_template%TYPE,
11 nrec_tx_line_sum_template
12 zx_evnt_cls_mappings.nrec_tx_line_sum_template%TYPE,
13 application_loop1_template
14 zx_evnt_cls_mappings.application_loop1_template%TYPE);
15 g_classmap_rec classmap_rec_type; */
16
17 TYPE country_tab_type is TABLE of zx_regimes_b.country_code%TYPE
18 INDEX BY BINARY_INTEGER;
19
20 PROCEDURE get_tax_date (
21 p_trx_line_index IN BINARY_INTEGER,
22 x_tax_date OUT NOCOPY DATE,
23 x_tax_determine_date OUT NOCOPY DATE,
24 x_tax_point_date OUT NOCOPY DATE,
25 x_return_status OUT NOCOPY VARCHAR2);
26
27 PROCEDURE get_applicable_regimes (
28 p_trx_line_index IN BINARY_INTEGER,
29 p_event_class_rec IN zx_api_pub.event_class_rec_type,
30 x_return_status OUT NOCOPY VARCHAR2 );
31
32 PROCEDURE get_applicable_taxes (
33 p_tax_regime_id IN zx_regimes_b.tax_regime_id%type,
34 p_tax_regime_code IN zx_regimes_b.tax_regime_code%type,
35 p_trx_line_index IN BINARY_INTEGER,
36 -- p_sum_line_index IN BINARY_INTEGER,
37 -- p_total_trx_amount IN NUMBER,
38 p_event_class_rec IN zx_api_pub.event_class_rec_type,
39 p_tax_date IN DATE,
40 p_tax_determine_date IN DATE,
41 p_tax_point_date IN DATE,
42 x_begin_index IN OUT NOCOPY BINARY_INTEGER,
43 x_end_index IN OUT NOCOPY BINARY_INTEGER,
44 x_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE get_place_of_supply (
47 p_event_class_rec IN zx_api_pub.event_class_rec_type,
48 p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
49 p_tax_id IN zx_taxes_b.tax_id%TYPE,
50 p_tax IN zx_taxes_b.tax%TYPE,
51 p_tax_determine_date IN DATE,
52 p_def_place_of_supply_type_cd IN zx_taxes_b.def_place_of_supply_type_code%TYPE,
53 p_place_of_supply_rule_flag IN zx_taxes_b.place_of_supply_rule_flag%TYPE,
54 p_applicability_rule_flag IN zx_taxes_b.applicability_rule_flag%TYPE,
55 p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
56 p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
57 p_trx_line_index IN BINARY_INTEGER,
58 p_direct_rate_result_id IN NUMBER,
59 x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,
60 x_jurisdictions_found OUT NOCOPY VARCHAR2,
61 X_Place_Of_Supply_Type_Code OUT NOCOPY zx_taxes_b.def_place_of_supply_type_code%TYPE,
62 x_place_of_supply_result_id OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2);
64
65 FUNCTION get_pos_parameter_name (
66 p_pos_type IN zx_taxes_b.def_place_of_supply_type_code%type,
67 x_return_status OUT NOCOPY VARCHAR2
68 ) RETURN VARCHAR2;
69
70 PROCEDURE get_tax_registration_info(
71 p_structure_name IN VARCHAR2,
72 p_structure_index IN BINARY_INTEGER,
73 p_event_class_rec IN zx_api_pub.event_class_rec_type,
74 p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
75 p_tax IN zx_taxes_b.tax%TYPE,
76 p_tax_determine_date IN zx_lines.tax_determine_date%TYPE,
77 p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
78 p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
79 x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,
80 x_return_status OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE get_tax_registration (
84 p_event_class_rec IN zx_api_pub.event_class_rec_type,
85 p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
86 p_tax_id IN zx_taxes_b.tax_id%TYPE,
87 p_tax IN zx_taxes_b.tax%TYPE,
88 p_tax_determine_date IN DATE,
89 p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
90 p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
91 p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
92 p_trx_line_index IN BINARY_INTEGER,
93 x_registration_number IN OUT NOCOPY zx_registrations.registration_number%TYPE,
94 x_tax_inclusion_flag IN OUT NOCOPY zx_registrations.inclusive_tax_flag%TYPE,
95 x_self_assessment_flg IN OUT NOCOPY zx_registrations.self_assess_flag%TYPE,
96 x_tax_registration_result_id OUT NOCOPY NUMBER,
97 x_rounding_rule_code OUT NOCOPY zx_registrations.rounding_rule_code%TYPE,
98 x_registration_party_type OUT NOCOPY zx_taxes_b.def_registr_party_type_code%TYPE,
99 x_return_status OUT NOCOPY VARCHAR2);
100
101 PROCEDURE get_legal_entity_registration (
102 p_event_class_rec IN zx_api_pub.event_class_rec_type,
103 p_trx_line_index IN BINARY_INTEGER,
104 p_tax_line_index IN BINARY_INTEGER,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_error_buffer OUT NOCOPY VARCHAR2);
107
108 PROCEDURE get_det_tax_lines_from_applied(
109 p_event_class_rec IN zx_api_pub.event_class_rec_type,
110 p_trx_line_index IN BINARY_INTEGER,
111 p_tax_date IN DATE,
112 p_tax_determine_date IN DATE,
113 p_tax_point_date IN DATE,
114 x_begin_index IN OUT NOCOPY BINARY_INTEGER,
115 x_end_index IN OUT NOCOPY BINARY_INTEGER,
116 x_return_status OUT NOCOPY VARCHAR2);
117
118 PROCEDURE get_det_tax_lines_from_adjust (
119 p_event_class_rec IN zx_api_pub.event_class_rec_type,
120 p_trx_line_index IN BINARY_INTEGER,
121 p_tax_date IN DATE,
122 p_tax_determine_date IN DATE,
123 p_tax_point_date IN DATE,
124 x_begin_index IN OUT NOCOPY BINARY_INTEGER,
125 x_end_index IN OUT NOCOPY BINARY_INTEGER,
126 x_return_status OUT NOCOPY VARCHAR2);
127
128 PROCEDURE get_tax_from_account(
129 p_event_class_rec IN zx_api_pub.event_class_rec_type,
130 p_trx_line_index IN BINARY_INTEGER,
131 p_tax_date IN DATE,
132 p_tax_determine_date IN DATE,
133 p_tax_point_date IN DATE,
134 x_begin_index IN OUT NOCOPY BINARY_INTEGER,
135 x_end_index IN OUT NOCOPY BINARY_INTEGER,
136 x_return_status OUT NOCOPY VARCHAR2);
137
138 PROCEDURE fetch_tax_lines (
139 p_event_class_rec IN zx_api_pub.event_class_rec_type,
140 p_trx_line_index IN NUMBER,
141 p_tax_date IN DATE,
142 p_tax_determine_date IN DATE,
143 p_tax_point_date IN DATE,
144 x_begin_index IN OUT NOCOPY NUMBER,
145 x_end_index IN OUT NOCOPY NUMBER,
146 x_return_status OUT NOCOPY VARCHAR2);
147
148 PROCEDURE get_taxes_for_intercomp_trx (
149 p_event_class_rec IN zx_api_pub.event_class_rec_type,
150 p_trx_line_index IN NUMBER,
151 p_tax_date IN DATE,
152 p_tax_determine_date IN DATE,
153 p_tax_point_date IN DATE,
154 x_begin_index IN OUT NOCOPY NUMBER,
155 x_end_index IN OUT NOCOPY NUMBER,
156 x_return_status OUT NOCOPY VARCHAR2);
157
158 /* Begin: Added for Bug4959835 */
159 PROCEDURE get_process_results(
160 p_trx_line_index IN BINARY_INTEGER,
161 p_tax_date IN DATE,
162 p_tax_determine_date IN DATE,
163 p_tax_point_date IN DATE,
164 p_event_class_rec IN zx_api_pub.event_class_rec_type,
165 x_begin_index IN OUT NOCOPY BINARY_INTEGER,
166 x_end_index IN OUT NOCOPY BINARY_INTEGER,
167 x_return_status OUT NOCOPY VARCHAR2);
168
169 TYPE tax_regime_code_tbl IS TABLE OF
170 ZX_SCO_RULES.tax_regime_code%TYPE
171 INDEX BY BINARY_INTEGER;
172
173 TYPE tax_tbl IS TABLE OF
174 ZX_SCO_RULES.tax%TYPE
175 INDEX BY BINARY_INTEGER;
176
177 TYPE status_result_tbl IS TABLE OF
178 ZX_PROCESS_RESULTS.status_result%TYPE
179 INDEX BY BINARY_INTEGER;
180
181 TYPE rate_result_tbl IS TABLE OF
182 ZX_PROCESS_RESULTS.rate_result%TYPE
183 INDEX BY BINARY_INTEGER;
184
185 TYPE condition_set_tbl IS TABLE OF
186 ZX_PROCESS_RESULTS.condition_set_id%TYPE
187 INDEX BY BINARY_INTEGER;
188
189 TYPE exception_set_tbl IS TABLE OF
190 ZX_PROCESS_RESULTS.exception_set_id%TYPE
191 INDEX BY BINARY_INTEGER;
192
193 TYPE result_id_tbl IS TABLE OF
194 ZX_PROCESS_RESULTS.result_id%TYPE
195 INDEX BY BINARY_INTEGER;
196
197
198 c_lines_per_commit CONSTANT NUMBER := ZX_TDS_CALC_SERVICES_PUB_PKG.G_LINES_PER_COMMIT;
199
200 /* End: Added for Bug4959835 */
201
202 END ZX_TDS_APPLICABILITY_DETM_PKG;