[Home] [Help]
280: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
281: p_tax IN ZX_TAXES_B.TAX%TYPE,
282: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
283: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
284: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
285: p_tax_rule_id IN ZX_RULES_B.TAX_RULE_ID%TYPE,
286: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
287: p_result IN OUT NOCOPY BOOLEAN,
288: p_result_id IN OUT NOCOPY NUMBER,
281: p_tax IN ZX_TAXES_B.TAX%TYPE,
282: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
283: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
284: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
285: p_tax_rule_id IN ZX_RULES_B.TAX_RULE_ID%TYPE,
286: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
287: p_result IN OUT NOCOPY BOOLEAN,
288: p_result_id IN OUT NOCOPY NUMBER,
289: p_found IN OUT NOCOPY BOOLEAN ,
298: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
299: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
300: p_tax_tbl IN TAX_TBL,
301: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
302: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
303: p_found IN OUT NOCOPY BOOLEAN,
304: p_tax_regime_code_tbl IN TAX_REGIME_CODE_TBL,
305: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
306: p_tax_rule_id_tbl IN TAX_RULE_ID_TBL,
301: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
302: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
303: p_found IN OUT NOCOPY BOOLEAN,
304: p_tax_regime_code_tbl IN TAX_REGIME_CODE_TBL,
305: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
306: p_tax_rule_id_tbl IN TAX_RULE_ID_TBL,
307: p_rule_det_factor_cq_tbl IN RULE_DET_FACTOR_CQ_TBL,
308: p_rule_geography_type_tbl IN RULE_GEOGRAPHY_TYPE_TBL,
309: p_rule_geography_id_tbl IN RULE_GEOGRAPHY_ID_TBL,
311: p_return_status OUT NOCOPY VARCHAR2,
312: p_error_buffer OUT NOCOPY VARCHAR2);
313:
314: PROCEDURE process_rule_code(
315: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
316: p_structure_name IN VARCHAR2,
317: p_structure_index IN BINARY_INTEGER,
318: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
319: p_tax IN ZX_TAXES_B.TAX%TYPE,
319: p_tax IN ZX_TAXES_B.TAX%TYPE,
320: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
321: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
322: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
323: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
324: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
325: p_found IN OUT NOCOPY BOOLEAN,
326: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
327: p_return_status OUT NOCOPY VARCHAR2,
320: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
321: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
322: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
323: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
324: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
325: p_found IN OUT NOCOPY BOOLEAN,
326: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
327: p_return_status OUT NOCOPY VARCHAR2,
328: p_error_buffer OUT NOCOPY VARCHAR2);
335: p_structure_index IN BINARY_INTEGER,
336: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
337: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
338: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
339: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
340: p_found IN OUT NOCOPY BOOLEAN,
341: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
342: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
343: p_tax IN ZX_TAXES_B.TAX%TYPE,
337: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
338: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
339: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
340: p_found IN OUT NOCOPY BOOLEAN,
341: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
342: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
343: p_tax IN ZX_TAXES_B.TAX%TYPE,
344: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
345: p_return_status OUT NOCOPY VARCHAR2,
345: p_return_status OUT NOCOPY VARCHAR2,
346: p_error_buffer OUT NOCOPY VARCHAR2);
347:
348: PROCEDURE get_rule_from_regime_hier(
349: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
350: p_structure_name IN VARCHAR2,
351: p_structure_index IN BINARY_INTEGER,
352: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
353: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
351: p_structure_index IN BINARY_INTEGER,
352: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
353: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
354: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
355: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
356: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
357: p_found IN OUT NOCOPY BOOLEAN,
358: p_parent_regime_cd_tbl IN TAX_REGIME_CODE_TBL,
359: p_return_status OUT NOCOPY VARCHAR2,
370:
371: PROCEDURE check_rule_geography(
372: p_structure_name IN VARCHAR2,
373: p_structure_index IN BINARY_INTEGER,
374: p_rule_det_factor_cq IN ZX_RULES_B.determining_factor_cq_code%TYPE,
375: p_rule_geography_type IN ZX_RULES_B.geography_type%TYPE,
376: p_rule_geography_id IN ZX_RULES_B.geography_id%TYPE,
377: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
378: p_valid OUT NOCOPY BOOLEAN,
371: PROCEDURE check_rule_geography(
372: p_structure_name IN VARCHAR2,
373: p_structure_index IN BINARY_INTEGER,
374: p_rule_det_factor_cq IN ZX_RULES_B.determining_factor_cq_code%TYPE,
375: p_rule_geography_type IN ZX_RULES_B.geography_type%TYPE,
376: p_rule_geography_id IN ZX_RULES_B.geography_id%TYPE,
377: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
378: p_valid OUT NOCOPY BOOLEAN,
379: p_return_status OUT NOCOPY VARCHAR2,
372: p_structure_name IN VARCHAR2,
373: p_structure_index IN BINARY_INTEGER,
374: p_rule_det_factor_cq IN ZX_RULES_B.determining_factor_cq_code%TYPE,
375: p_rule_geography_type IN ZX_RULES_B.geography_type%TYPE,
376: p_rule_geography_id IN ZX_RULES_B.geography_id%TYPE,
377: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
378: p_valid OUT NOCOPY BOOLEAN,
379: p_return_status OUT NOCOPY VARCHAR2,
380: p_error_buffer OUT NOCOPY VARCHAR2);
650: --
651: --
652:
653: PROCEDURE rule_base_process(
654: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
655: p_structure_name IN VARCHAR2,
656: p_structure_index IN BINARY_INTEGER,
657: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
658: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
657: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
658: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
659: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
660: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
661: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
662: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
663: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
664: p_return_status OUT NOCOPY VARCHAR2,
665: p_error_buffer OUT NOCOPY VARCHAR2)
658: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
659: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
660: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
661: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
662: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
663: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
664: p_return_status OUT NOCOPY VARCHAR2,
665: p_error_buffer OUT NOCOPY VARCHAR2)
666:
688: -- cursor for getting determining factor templates from rules
689: -- for DET_TAX_RATE process
690: --
691: CURSOR get_det_factor_templ_csr_a
692: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
693: c_tax ZX_TAXES_B.TAX%TYPE,
694: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
695: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
696: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
693: c_tax ZX_TAXES_B.TAX%TYPE,
694: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
695: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
696: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
697: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
698: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
699: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE
700: )
701: IS
694: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
695: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
696: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
697: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
698: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
699: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE
700: )
701: IS
702: SELECT TAX_RULE_ID,
695: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
696: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
697: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
698: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
699: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE
700: )
701: IS
702: SELECT TAX_RULE_ID,
703: TAX,
734: -- cursor for getting determining factor templates from rules
735: -- for DET_RECOVERY_RATE process
736: --
737: CURSOR get_det_factor_templ_csr_b
738: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
739: c_tax ZX_TAXES_B.TAX%TYPE,
740: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
741: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
742: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
738: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
739: c_tax ZX_TAXES_B.TAX%TYPE,
740: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
741: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
742: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
743: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
744: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
745: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
746: IS
739: c_tax ZX_TAXES_B.TAX%TYPE,
740: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
741: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
742: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
743: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
744: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
745: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
746: IS
747: SELECT TAX_RULE_ID,
740: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
741: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
742: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
743: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
744: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
745: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
746: IS
747: SELECT TAX_RULE_ID,
748: TAX,
741: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
742: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
743: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
744: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
745: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
746: IS
747: SELECT TAX_RULE_ID,
748: TAX,
749: TAX_REGIME_CODE,
785: new get_det_factor_templ_csr_e
786: */
787:
788: /* CURSOR get_det_factor_templ_csr_c
789: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
790: c_tax ZX_TAXES_B.TAX%TYPE,
791: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
792: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
793: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
789: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
790: c_tax ZX_TAXES_B.TAX%TYPE,
791: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
792: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
793: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
794: IS
795: SELECT TAX_RULE_ID,
796: TAX,
797: TAX_REGIME_CODE,
980: END IF; --source_event_class_mapping_id is NOT NULL
981:
982: IF p_service_type_code = 'DET_TAX_RATE' THEN
983: --
984: -- get templates from ZX_RULES_B table.
985: --
986: --Bug 13507505
987: IF l_source_event_class_code = 'INTERCOMPANY_TRANSACTION' THEN
988: OPEN get_det_factor_templ_csr_a(p_service_type_code,
1131: END IF;
1132:
1133: ELSIF p_service_type_code = 'DET_RECOVERY_RATE' THEN
1134: --
1135: -- get templates from ZX_RULES_B table.
1136: --
1137: --Bug 13507505
1138: IF l_source_event_class_code = 'INTERCOMPANY_TRANSACTION' THEN
1139: OPEN get_det_factor_templ_csr_b(p_service_type_code,
1412: -- This procedure processes rule code for recovery rate determination
1413: -- from migration
1414: --
1415: PROCEDURE process_rule_code(
1416: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1417: p_structure_name IN VARCHAR2,
1418: p_structure_index IN BINARY_INTEGER,
1419: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1420: p_tax IN ZX_TAXES_B.TAX%TYPE,
1420: p_tax IN ZX_TAXES_B.TAX%TYPE,
1421: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1422: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1423: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1424: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
1425: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1426: p_found IN OUT NOCOPY BOOLEAN,
1427: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1428: p_return_status OUT NOCOPY VARCHAR2,
1421: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1422: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1423: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1424: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
1425: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1426: p_found IN OUT NOCOPY BOOLEAN,
1427: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1428: p_return_status OUT NOCOPY VARCHAR2,
1429: p_error_buffer OUT NOCOPY VARCHAR2)
1427: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1428: p_return_status OUT NOCOPY VARCHAR2,
1429: p_error_buffer OUT NOCOPY VARCHAR2)
1430: IS
1431: l_det_factor_templ_cd ZX_RULES_B.DET_FACTOR_TEMPL_CODE%TYPE;
1432: l_condition_group_code ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE;
1433: l_result BOOLEAN;
1434: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;
1435: l_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE;
1431: l_det_factor_templ_cd ZX_RULES_B.DET_FACTOR_TEMPL_CODE%TYPE;
1432: l_condition_group_code ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE;
1433: l_result BOOLEAN;
1434: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;
1435: l_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE;
1436:
1437: l_valid BOOLEAN;
1438:
1439: --
1439: --
1440: -- cursor for getting recovery templates from rules
1441: --
1442: CURSOR get_recovery_templ_csr
1443: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1444: c_tax ZX_TAXES_B.TAX%TYPE,
1445: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1446: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1447: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1443: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1444: c_tax ZX_TAXES_B.TAX%TYPE,
1445: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1446: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1447: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1448: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1449: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
1450: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1451: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1444: c_tax ZX_TAXES_B.TAX%TYPE,
1445: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1446: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1447: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1448: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1449: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
1450: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1451: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1452: IS
1445: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1446: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1447: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1448: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1449: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
1450: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1451: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1452: IS
1453: SELECT TAX_RULE_ID,
1446: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1447: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1448: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1449: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
1450: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1451: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1452: IS
1453: SELECT TAX_RULE_ID,
1454: DET_FACTOR_TEMPL_CODE
1447: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1448: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1449: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,
1450: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1451: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1452: IS
1453: SELECT TAX_RULE_ID,
1454: DET_FACTOR_TEMPL_CODE
1455: FROM ZX_SCO_RULES_B_V r
1475: -- cursor for getting offset templates from rules
1476: --
1477: /*********************
1478: CURSOR get_offset_templ_csr
1479: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1480: c_tax ZX_TAXES_B.TAX%TYPE,
1481: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1482: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1483: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1479: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1480: c_tax ZX_TAXES_B.TAX%TYPE,
1481: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1482: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1483: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1484: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1485: IS
1486: SELECT TAX_RULE_ID,
1487: det_factor_templ_code
1480: c_tax ZX_TAXES_B.TAX%TYPE,
1481: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1482: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1483: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1484: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1485: IS
1486: SELECT TAX_RULE_ID,
1487: det_factor_templ_code
1488: FROM ZX_SCO_RULES_B_V
1514: -- determine which cursor to open
1515: --
1516: IF p_service_type_code = 'DET_RECOVERY_RATE' THEN
1517: --
1518: -- get recovery templates from ZX_RULES_B table.
1519: --
1520: OPEN get_recovery_templ_csr(p_service_type_code,
1521: p_tax,
1522: p_tax_regime_code,
1534: CLOSE get_recovery_templ_csr;
1535: /************************
1536: ELSIF p_service_type_code = 'DET_OFFSET_TAX' THEN
1537: --
1538: -- get offset templates from ZX_RULES_B table.
1539: --
1540: OPEN get_offset_templ_csr(p_service_type_code,
1541: p_tax,
1542: p_tax_regime_code,
1655: p_structure_index IN BINARY_INTEGER,
1656: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1657: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1658: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1659: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1660: p_found IN OUT NOCOPY BOOLEAN,
1661: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1662: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1663: p_tax IN ZX_TAXES_B.TAX%TYPE,
1657: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1658: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1659: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1660: p_found IN OUT NOCOPY BOOLEAN,
1661: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1662: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1663: p_tax IN ZX_TAXES_B.TAX%TYPE,
1664: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1665: p_return_status OUT NOCOPY VARCHAR2,
1672: -- for processes other than DET_RECOVERY_RATE and DET_TAX_RATE
1673: --
1674:
1675: CURSOR get_det_factor_templ_csr_c
1676: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1677: c_tax ZX_TAXES_B.TAX%TYPE,
1678: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1679: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1680: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE)
1676: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1677: c_tax ZX_TAXES_B.TAX%TYPE,
1678: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1679: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1680: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE)
1681: IS
1682: SELECT TAX_RULE_ID,
1683: TAX,
1684: TAX_REGIME_CODE,
1704: )
1705: ORDER BY PRIORITY;
1706:
1707: CURSOR get_det_factor_templ_csr_d
1708: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1709: c_tax ZX_TAXES_B.TAX%TYPE,
1710: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1711: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1712: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1708: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1709: c_tax ZX_TAXES_B.TAX%TYPE,
1710: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1711: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1712: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1713: IS
1714: SELECT TAX_RULE_ID,
1715: TAX,
1716: TAX_REGIME_CODE,
1736: )
1737: ORDER BY PRIORITY;
1738:
1739: CURSOR get_det_factor_templ_csr_e
1740: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1741: c_tax ZX_TAXES_B.TAX%TYPE,
1742: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1743: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1744: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1740: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1741: c_tax ZX_TAXES_B.TAX%TYPE,
1742: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1743: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1744: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1745: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE
1746: )
1747: IS
1748: SELECT TAX_RULE_ID,
1741: c_tax ZX_TAXES_B.TAX%TYPE,
1742: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1743: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1744: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1745: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE
1746: )
1747: IS
1748: SELECT TAX_RULE_ID,
1749: TAX,
1780: l_tax_tbl TAX_TBL;
1781: l_tax_regime_code_tbl TAX_REGIME_CODE_TBL;
1782: l_tax_rule_id_tbl TAX_RULE_ID_TBL;
1783:
1784: --Bug 4670938 - Changed the type since EVENT_CLASS_CODE is removed from zx_rules_b
1785: l_source_event_class_code ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_CODE%TYPE;
1786:
1787: --CR#4255160. Added new variables to store the Rule level Determining Factor CQ,
1788: -- Geography type and Geography Id
2193: -- Phong La 03-JUN-02 Created
2194:
2195:
2196: PROCEDURE get_rule_from_regime_hier(
2197: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2198: p_structure_name IN VARCHAR2,
2199: p_structure_index IN BINARY_INTEGER,
2200: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2201: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2199: p_structure_index IN BINARY_INTEGER,
2200: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2201: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2202: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2203: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
2204: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
2205: p_found IN OUT NOCOPY BOOLEAN,
2206: p_parent_regime_cd_tbl IN TAX_REGIME_CODE_TBL,
2207: p_return_status OUT NOCOPY VARCHAR2,
2222: l_rule_geography_id_tbl RULE_GEOGRAPHY_ID_TBL;
2223:
2224:
2225: CURSOR get_templ_from_regime_hier_csr
2226: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2227: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2228: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2229: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
2230: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2225: CURSOR get_templ_from_regime_hier_csr
2226: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2227: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2228: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2229: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
2230: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2231: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
2232: IS
2233: SELECT TAX_RULE_ID, TAX, TAX_REGIME_CODE, DET_FACTOR_TEMPL_CODE,
2227: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2228: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2229: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
2230: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2231: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
2232: IS
2233: SELECT TAX_RULE_ID, TAX, TAX_REGIME_CODE, DET_FACTOR_TEMPL_CODE,
2234: DETERMINING_FACTOR_CQ_CODE,
2235: GEOGRAPHY_TYPE,
2281: 'parent regime: ' || p_parent_regime_cd_tbl(i));
2282: END IF;
2283:
2284: --
2285: -- get templates from ZX_RULES_B table.
2286: --
2287:
2288: OPEN get_templ_from_regime_hier_csr(p_service_type_code,
2289: p_parent_regime_cd_tbl(i),
2397: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2398: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2399: p_tax_tbl IN TAX_TBL,
2400: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2401: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
2402: p_found IN OUT NOCOPY BOOLEAN,
2403: p_tax_regime_code_tbl IN TAX_REGIME_CODE_TBL,
2404: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2405: p_tax_rule_id_tbl IN TAX_RULE_ID_TBL,
2400: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2401: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
2402: p_found IN OUT NOCOPY BOOLEAN,
2403: p_tax_regime_code_tbl IN TAX_REGIME_CODE_TBL,
2404: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2405: p_tax_rule_id_tbl IN TAX_RULE_ID_TBL,
2406: p_rule_det_factor_cq_tbl IN RULE_DET_FACTOR_CQ_TBL,
2407: p_rule_geography_type_tbl IN RULE_GEOGRAPHY_TYPE_TBL,
2408: p_rule_geography_id_tbl IN RULE_GEOGRAPHY_ID_TBL,
2416: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;
2417: l_valid BOOLEAN;
2418:
2419: --CR#4255160 - Added new variables to store the Geography context related information
2420: l_rule_det_factor_cq ZX_RULES_B.DETERMINING_FACTOR_CQ_CODE%TYPE;
2421: l_rule_geography_type ZX_RULES_B.GEOGRAPHY_TYPE%TYPE;
2422: l_rule_geography_id ZX_RULES_B.GEOGRAPHY_ID%TYPE;
2423:
2424: BEGIN
2417: l_valid BOOLEAN;
2418:
2419: --CR#4255160 - Added new variables to store the Geography context related information
2420: l_rule_det_factor_cq ZX_RULES_B.DETERMINING_FACTOR_CQ_CODE%TYPE;
2421: l_rule_geography_type ZX_RULES_B.GEOGRAPHY_TYPE%TYPE;
2422: l_rule_geography_id ZX_RULES_B.GEOGRAPHY_ID%TYPE;
2423:
2424: BEGIN
2425:
2418:
2419: --CR#4255160 - Added new variables to store the Geography context related information
2420: l_rule_det_factor_cq ZX_RULES_B.DETERMINING_FACTOR_CQ_CODE%TYPE;
2421: l_rule_geography_type ZX_RULES_B.GEOGRAPHY_TYPE%TYPE;
2422: l_rule_geography_id ZX_RULES_B.GEOGRAPHY_ID%TYPE;
2423:
2424: BEGIN
2425:
2426: IF (g_level_procedure >= g_current_runtime_level ) THEN
2590: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2591: p_tax IN ZX_TAXES_B.TAX%TYPE,
2592: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2593: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2594: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2595: p_tax_rule_id IN ZX_RULES_B.TAX_RULE_ID%TYPE,
2596: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2597: p_result IN OUT NOCOPY BOOLEAN,
2598: p_result_id IN OUT NOCOPY NUMBER,
2591: p_tax IN ZX_TAXES_B.TAX%TYPE,
2592: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2593: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2594: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2595: p_tax_rule_id IN ZX_RULES_B.TAX_RULE_ID%TYPE,
2596: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2597: p_result IN OUT NOCOPY BOOLEAN,
2598: p_result_id IN OUT NOCOPY NUMBER,
2599: p_found IN OUT NOCOPY BOOLEAN ,
2734: --
2735:
2736: CURSOR get_condition_group_codes_csr
2737: (c_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
2738: c_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE,
2739: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE)
2740: IS
2741: SELECT /*+ leading(P) use_nl_with_index(s ZX_CONDITION_GROUPS_B_U1) */
2742: s.CONDITION_GROUP_ID, s.CONDITION_GROUP_CODE, More_Than_Max_Cond_Flag,
7053: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
7054: l_tax_status_Code ZX_RATES_B.tax_status_code%type;
7055: l_tax_rate_Code ZX_RATES_B.tax_rate_Code%type;
7056: l_override_tax_rate_Code ZX_RATES_B.tax_rate_code%TYPE;
7057: l_service_type_code ZX_RULES_B.service_type_code%TYPE;
7058:
7059: BEGIN
7060:
7061: IF (g_level_procedure >= g_current_runtime_level ) THEN
7106: p_found := true;
7107: END IF;
7108:
7109: select service_type_code into l_service_type_code
7110: FROM zx_rules_b
7111: where tax_rule_id = p_zx_result_rec.tax_rule_id;
7112:
7113:
7114: -- For Migrated Records, Check if Condition Set and Exception Set is populated
7880:
7881: PROCEDURE check_rule_geography(
7882: p_structure_name IN VARCHAR2,
7883: p_structure_index IN BINARY_INTEGER,
7884: p_rule_det_factor_cq IN ZX_RULES_B.determining_factor_cq_code%TYPE,
7885: p_rule_geography_type IN ZX_RULES_B.geography_type%TYPE,
7886: p_rule_geography_id IN ZX_RULES_B.geography_id%TYPE,
7887: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7888: p_valid OUT NOCOPY BOOLEAN,
7881: PROCEDURE check_rule_geography(
7882: p_structure_name IN VARCHAR2,
7883: p_structure_index IN BINARY_INTEGER,
7884: p_rule_det_factor_cq IN ZX_RULES_B.determining_factor_cq_code%TYPE,
7885: p_rule_geography_type IN ZX_RULES_B.geography_type%TYPE,
7886: p_rule_geography_id IN ZX_RULES_B.geography_id%TYPE,
7887: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7888: p_valid OUT NOCOPY BOOLEAN,
7889: p_return_status OUT NOCOPY VARCHAR2,
7882: p_structure_name IN VARCHAR2,
7883: p_structure_index IN BINARY_INTEGER,
7884: p_rule_det_factor_cq IN ZX_RULES_B.determining_factor_cq_code%TYPE,
7885: p_rule_geography_type IN ZX_RULES_B.geography_type%TYPE,
7886: p_rule_geography_id IN ZX_RULES_B.geography_id%TYPE,
7887: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7888: p_valid OUT NOCOPY BOOLEAN,
7889: p_return_status OUT NOCOPY VARCHAR2,
7890: p_error_buffer OUT NOCOPY VARCHAR2)