[Home] [Help]
23: ZX_LINES.TAX_DETERMINE_DATE%TYPE,
24: p_classified_entity_id IN
25: ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
26: p_item_org_id IN NUMBER,
27: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
28: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE);
29:
30: PROCEDURE get_fc(
31: p_structure_name IN VARCHAR2,
32: p_structure_index IN BINARY_INTEGER,
33: p_condition_index IN BINARY_INTEGER,
34: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
35: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
36: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
37: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
38: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
39: p_return_status OUT NOCOPY VARCHAR2,
40: p_error_buffer OUT NOCOPY VARCHAR2);
41:
42: PROCEDURE get_registration_status(
43: p_structure_name IN VARCHAR2,
44: p_structure_index IN BINARY_INTEGER,
45: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
46: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
47: p_tax IN ZX_TAXES_B.TAX%TYPE,
48: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
49: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
125: */
126: PROCEDURE get_trx_value(
127: p_structure_name IN VARCHAR2,
128: p_structure_index IN BINARY_INTEGER,
129: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
130: p_condition_index IN BINARY_INTEGER,
131: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
132: p_tax IN ZX_TAXES_B.TAX%TYPE,
133: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
157: PROCEDURE get_user_item_type_value(
158: p_structure_name IN VARCHAR2,
159: p_structure_index IN BINARY_INTEGER,
160: p_condition_index IN BINARY_INTEGER,
161: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
162: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
163: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
164: p_return_status OUT NOCOPY VARCHAR2,
165: p_error_buffer OUT NOCOPY VARCHAR2);
167: PROCEDURE get_user_item_alphanum_value(
168: p_structure_name IN VARCHAR2,
169: p_structure_index IN BINARY_INTEGER,
170: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
171: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
172: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
173: p_return_status OUT NOCOPY VARCHAR2,
174: p_error_buffer OUT NOCOPY VARCHAR2);
175:
208: PROCEDURE check_condition_group_result(
209: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
210: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
211: p_trx_line_index IN BINARY_INTEGER,
212: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
213: p_template_evaluated OUT NOCOPY BOOLEAN,
214: p_result OUT NOCOPY BOOLEAN);
215:
216: PROCEDURE insert_condition_group_result(
217: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
218: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
219: p_result IN BOOLEAN,
220: p_trx_line_index IN BINARY_INTEGER,
221: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE);
222:
223: PROCEDURE get_result(
224: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,
225: p_structure_name IN VARCHAR2,
250:
251: PROCEDURE process_set_condition (
252: p_structure_name IN VARCHAR2,
253: p_structure_index IN BINARY_INTEGER,
254: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
255: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
256: p_tax IN ZX_TAXES_B.TAX%TYPE,
257: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
258: p_result IN OUT NOCOPY BOOLEAN,
267: PROCEDURE get_and_process_condition(
268: p_structure_name IN VARCHAR2,
269: p_structure_index IN BINARY_INTEGER,
270: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
271: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
272: p_tax IN ZX_TAXES_B.TAX%TYPE,
273: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
274: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
275: p_result IN OUT NOCOPY BOOLEAN,
285: p_structure_name IN VARCHAR2,
286: p_structure_index IN BINARY_INTEGER,
287: p_det_factor_templ_code IN
288: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
289: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
290: p_tax IN ZX_TAXES_B.TAX%TYPE,
291: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
292: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
293: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
304: p_structure_name IN VARCHAR2,
305: p_structure_index IN BINARY_INTEGER,
306: p_det_factor_templ_cd_tbl IN DET_FACTOR_TEMPL_CODE_TBL,
307: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
308: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
309: p_tax_tbl IN TAX_TBL,
310: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
311: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
312: p_found IN OUT NOCOPY BOOLEAN,
323: PROCEDURE process_rule_code(
324: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
325: p_structure_name IN VARCHAR2,
326: p_structure_index IN BINARY_INTEGER,
327: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
328: p_tax IN ZX_TAXES_B.TAX%TYPE,
329: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
330: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
331: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
342: PROCEDURE fetch_proc_det_factor_templ(
343: p_structure_name IN VARCHAR2,
344: p_structure_index IN BINARY_INTEGER,
345: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
346: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
347: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
348: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
349: p_found IN OUT NOCOPY BOOLEAN,
350: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
357: PROCEDURE get_rule_from_regime_hier(
358: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
359: p_structure_name IN VARCHAR2,
360: p_structure_index IN BINARY_INTEGER,
361: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
362: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
363: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
364: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
365: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
371: -- Bug 4166241 : Added new private procedure to process only those templates
372: -- whose determining factors are supported by the product
373: PROCEDURE check_templ_tax_parameter(
374: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
375: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
376: p_valid OUT NOCOPY BOOLEAN,
377: p_return_status OUT NOCOPY VARCHAR2,
378: p_error_buffer OUT NOCOPY VARCHAR2);
379:
381: p_structure_index IN BINARY_INTEGER,
382: p_rule_det_factor_cq IN ZX_RULES_B.determining_factor_cq_code%TYPE,
383: p_rule_geography_type IN ZX_RULES_B.geography_type%TYPE,
384: p_rule_geography_id IN ZX_RULES_B.geography_id%TYPE,
385: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
386: p_valid OUT NOCOPY BOOLEAN,
387: p_return_status OUT NOCOPY VARCHAR2,
388: p_error_buffer OUT NOCOPY VARCHAR2);
389:
617: PROCEDURE rule_base_process(
618: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
619: p_structure_name IN VARCHAR2,
620: p_structure_index IN BINARY_INTEGER,
621: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
622: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
623: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
624: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
625: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
1175: PROCEDURE process_rule_code(
1176: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1177: p_structure_name IN VARCHAR2,
1178: p_structure_index IN BINARY_INTEGER,
1179: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1180: p_tax IN ZX_TAXES_B.TAX%TYPE,
1181: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1182: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1183: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1405: PROCEDURE fetch_proc_det_factor_templ(
1406: p_structure_name IN VARCHAR2,
1407: p_structure_index IN BINARY_INTEGER,
1408: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1409: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1410: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1411: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1412: p_found IN OUT NOCOPY BOOLEAN,
1413: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1863: PROCEDURE get_rule_from_regime_hier(
1864: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1865: p_structure_name IN VARCHAR2,
1866: p_structure_index IN BINARY_INTEGER,
1867: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1868: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1869: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1870: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1871: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
2059: p_structure_name IN VARCHAR2,
2060: p_structure_index IN BINARY_INTEGER,
2061: p_det_factor_templ_cd_tbl IN det_factor_templ_code_tbl,
2062: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2063: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2064: p_tax_tbl IN TAX_TBL,
2065: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2066: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
2067: p_found IN OUT NOCOPY BOOLEAN,
2251: p_structure_name IN VARCHAR2,
2252: p_structure_index IN BINARY_INTEGER,
2253: p_det_factor_templ_code IN
2254: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
2255: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2256: p_tax IN ZX_TAXES_B.TAX%TYPE,
2257: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2258: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2259: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
3003: p_structure_index IN BINARY_INTEGER,
3004: p_condition_group_code IN
3005: ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE,
3006: p_event_class_rec IN
3007: ZX_API_PUB.EVENT_CLASS_REC_TYPE,
3008: p_tax IN ZX_TAXES_B.TAX%TYPE,
3009: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3010: p_tax_determine_date IN
3011: ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3294: PROCEDURE process_set_condition (
3295: p_structure_name IN VARCHAR2,
3296: p_structure_index IN BINARY_INTEGER,
3297: p_event_class_rec IN
3298: ZX_API_PUB.EVENT_CLASS_REC_TYPE,
3299: p_tax_determine_date IN
3300: ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3301: p_tax IN ZX_TAXES_B.TAX%TYPE,
3302: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3557:
3558: PROCEDURE get_trx_value(
3559: p_structure_name IN VARCHAR2,
3560: p_structure_index IN BINARY_INTEGER,
3561: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
3562: p_condition_index IN BINARY_INTEGER,
3563: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3564: p_tax IN ZX_TAXES_B.TAX%TYPE,
3565: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
4482: PROCEDURE get_user_item_type_value(
4483: p_structure_name IN VARCHAR2,
4484: p_structure_index IN BINARY_INTEGER,
4485: p_condition_index IN BINARY_INTEGER,
4486: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4487: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
4488: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4489: p_return_status OUT NOCOPY VARCHAR2,
4490: p_error_buffer OUT NOCOPY VARCHAR2)
4567: PROCEDURE get_user_item_alphanum_value(
4568: p_structure_name IN VARCHAR2,
4569: p_structure_index IN BINARY_INTEGER,
4570: p_parameter_code IN ZX_PARAMETERS_B.TAX_PARAMETER_CODE%TYPE,
4571: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4572: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4573: p_return_status OUT NOCOPY VARCHAR2,
4574: p_error_buffer OUT NOCOPY VARCHAR2)
4575: IS
4660: p_structure_index IN BINARY_INTEGER,
4661: p_condition_index IN BINARY_INTEGER,
4662: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
4663: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
4664: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4665: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
4666: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
4667: p_return_status OUT NOCOPY VARCHAR2,
4668: p_error_buffer OUT NOCOPY VARCHAR2)
5789: --
5790: PROCEDURE get_registration_status(
5791: p_structure_name IN VARCHAR2,
5792: p_structure_index IN BINARY_INTEGER,
5793: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5794: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
5795: p_tax IN ZX_TAXES_B.TAX%TYPE,
5796: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5797: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6959: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
6960: p_classified_entity_id IN
6961: ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
6962: p_item_org_id IN NUMBER,
6963: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
6964: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE)
6965:
6966: IS
6967: l_count NUMBER;
7031: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
7032: p_condition_group_code IN
7033: ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
7034: p_trx_line_index IN BINARY_INTEGER,
7035: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7036: p_template_evaluated OUT NOCOPY BOOLEAN,
7037: p_result OUT NOCOPY BOOLEAN)
7038: IS
7039: l_count NUMBER;
7137: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
7138: p_condition_group_code IN ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE,
7139: p_result IN BOOLEAN,
7140: p_trx_line_index IN BINARY_INTEGER,
7141: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
7142: )
7143: IS
7144: i BINARY_INTEGER;
7145: l_check_condition_group_rec ZX_TDS_CALC_SERVICES_PUB_PKG.trx_line_cond_grp_eval_rec;
7202: --
7203:
7204: PROCEDURE check_templ_tax_parameter(
7205: p_det_factor_templ_code IN ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
7206: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7207: p_valid OUT NOCOPY BOOLEAN,
7208: p_return_status OUT NOCOPY VARCHAR2,
7209: p_error_buffer OUT NOCOPY VARCHAR2)
7210:
7351: p_structure_index IN BINARY_INTEGER,
7352: p_rule_det_factor_cq IN ZX_RULES_B.determining_factor_cq_code%TYPE,
7353: p_rule_geography_type IN ZX_RULES_B.geography_type%TYPE,
7354: p_rule_geography_id IN ZX_RULES_B.geography_id%TYPE,
7355: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7356: p_valid OUT NOCOPY BOOLEAN,
7357: p_return_status OUT NOCOPY VARCHAR2,
7358: p_error_buffer OUT NOCOPY VARCHAR2)
7359: