[Home] [Help]
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,
294: p_tax_rule_id IN ZX_RULES_B.TAX_RULE_ID%TYPE,
295: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
296: p_result IN OUT NOCOPY BOOLEAN,
297: p_result_id IN OUT NOCOPY NUMBER,
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,
294: p_tax_rule_id IN ZX_RULES_B.TAX_RULE_ID%TYPE,
295: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
296: p_result IN OUT NOCOPY BOOLEAN,
297: p_result_id IN OUT NOCOPY NUMBER,
298: p_found OUT NOCOPY BOOLEAN ,
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,
313: p_tax_regime_code_tbl IN TAX_REGIME_CODE_TBL,
314: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
315: p_tax_rule_id_tbl IN TAX_RULE_ID_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,
313: p_tax_regime_code_tbl IN TAX_REGIME_CODE_TBL,
314: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
315: p_tax_rule_id_tbl IN TAX_RULE_ID_TBL,
316: p_rule_det_factor_cq_tbl IN RULE_DET_FACTOR_CQ_TBL,
317: p_rule_geography_type_tbl IN RULE_GEOGRAPHY_TYPE_TBL,
318: p_rule_geography_id_tbl IN RULE_GEOGRAPHY_ID_TBL,
320: p_return_status OUT NOCOPY VARCHAR2,
321: p_error_buffer OUT NOCOPY VARCHAR2);
322:
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,
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,
332: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
333: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
334: p_found IN OUT NOCOPY BOOLEAN,
335: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
336: p_return_status OUT NOCOPY VARCHAR2,
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,
332: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
333: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
334: p_found IN OUT NOCOPY BOOLEAN,
335: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
336: p_return_status OUT NOCOPY VARCHAR2,
337: p_error_buffer OUT NOCOPY 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,
351: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
352: p_tax IN ZX_TAXES_B.TAX%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,
351: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
352: p_tax IN ZX_TAXES_B.TAX%TYPE,
353: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
354: p_return_status OUT NOCOPY VARCHAR2,
354: p_return_status OUT NOCOPY VARCHAR2,
355: p_error_buffer OUT NOCOPY VARCHAR2);
356:
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,
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,
366: p_found IN OUT NOCOPY BOOLEAN,
367: p_parent_regime_cd_tbl IN TAX_REGIME_CODE_TBL,
368: p_return_status OUT NOCOPY VARCHAR2,
378: p_error_buffer OUT NOCOPY VARCHAR2);
379:
380: PROCEDURE check_rule_geography( p_structure_name IN VARCHAR2,
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,
379:
380: PROCEDURE check_rule_geography( p_structure_name IN VARCHAR2,
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,
380: PROCEDURE check_rule_geography( p_structure_name IN VARCHAR2,
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);
614: --
615: --
616:
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,
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,
626: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
627: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
628: p_return_status OUT NOCOPY VARCHAR2,
629: p_error_buffer OUT NOCOPY VARCHAR2)
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,
626: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
627: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
628: p_return_status OUT NOCOPY VARCHAR2,
629: p_error_buffer OUT NOCOPY VARCHAR2)
630:
650: -- cursor for getting determining factor templates from rules
651: -- for DET_TAX_RATE process
652: --
653: CURSOR get_det_factor_templ_csr_a
654: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
655: c_tax ZX_TAXES_B.TAX%TYPE,
656: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
657: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
658: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
655: c_tax ZX_TAXES_B.TAX%TYPE,
656: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
657: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
658: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
659: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
660: IS
661: SELECT TAX_RULE_ID,
662: TAX,
663: TAX_REGIME_CODE,
687: -- cursor for getting determining factor templates from rules
688: -- for DET_RECOVERY_RATE process
689: --
690: CURSOR get_det_factor_templ_csr_b
691: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
692: c_tax ZX_TAXES_B.TAX%TYPE,
693: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
694: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
695: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
691: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
692: c_tax ZX_TAXES_B.TAX%TYPE,
693: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
694: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
695: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
696: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
697: IS
698: SELECT TAX_RULE_ID,
699: TAX,
692: c_tax ZX_TAXES_B.TAX%TYPE,
693: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
694: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
695: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
696: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
697: IS
698: SELECT TAX_RULE_ID,
699: TAX,
700: TAX_REGIME_CODE,
730: new get_det_factor_templ_csr_e
731: */
732:
733: /* CURSOR get_det_factor_templ_csr_c
734: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
735: c_tax ZX_TAXES_B.TAX%TYPE,
736: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
737: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
738: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
734: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
735: c_tax ZX_TAXES_B.TAX%TYPE,
736: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
737: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
738: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
739: IS
740: SELECT TAX_RULE_ID,
741: TAX,
742: TAX_REGIME_CODE,
900: END IF;
901:
902: IF p_service_type_code = 'DET_TAX_RATE' THEN
903: --
904: -- get templates from ZX_RULES_B table.
905: --
906: OPEN get_det_factor_templ_csr_a(p_service_type_code,
907: l_tax,
908: l_tax_regime_code,
971: END IF;
972:
973: ELSIF p_service_type_code = 'DET_RECOVERY_RATE' THEN
974: --
975: -- get templates from ZX_RULES_B table.
976: --
977: OPEN get_det_factor_templ_csr_b(p_service_type_code,
978: l_tax,
979: l_tax_regime_code,
1172: -- This procedure processes rule code for recovery rate determination
1173: -- from migration
1174: --
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,
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,
1184: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
1185: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1186: p_found IN OUT NOCOPY BOOLEAN,
1187: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1188: p_return_status OUT NOCOPY VARCHAR2,
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,
1184: p_tax_rule_code IN ZX_RULES_B.TAX_RULE_CODE%TYPE,
1185: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1186: p_found IN OUT NOCOPY BOOLEAN,
1187: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1188: p_return_status OUT NOCOPY VARCHAR2,
1189: p_error_buffer OUT NOCOPY VARCHAR2)
1187: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1188: p_return_status OUT NOCOPY VARCHAR2,
1189: p_error_buffer OUT NOCOPY VARCHAR2)
1190: IS
1191: l_det_factor_templ_cd ZX_RULES_B.DET_FACTOR_TEMPL_CODE%TYPE;
1192: l_condition_group_code ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE;
1193: l_result BOOLEAN;
1194: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;
1195: l_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE;
1191: l_det_factor_templ_cd ZX_RULES_B.DET_FACTOR_TEMPL_CODE%TYPE;
1192: l_condition_group_code ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE;
1193: l_result BOOLEAN;
1194: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;
1195: l_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE;
1196:
1197: l_valid BOOLEAN;
1198:
1199: --
1199: --
1200: -- cursor for getting recovery templates from rules
1201: --
1202: CURSOR get_recovery_templ_csr
1203: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1204: c_tax ZX_TAXES_B.TAX%TYPE,
1205: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1206: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1207: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1203: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1204: c_tax ZX_TAXES_B.TAX%TYPE,
1205: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1206: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1207: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1208: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1209: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1210: IS
1211: SELECT TAX_RULE_ID,
1204: c_tax ZX_TAXES_B.TAX%TYPE,
1205: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1206: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1207: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1208: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1209: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1210: IS
1211: SELECT TAX_RULE_ID,
1212: DET_FACTOR_TEMPL_CODE
1205: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1206: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1207: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1208: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1209: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1210: IS
1211: SELECT TAX_RULE_ID,
1212: DET_FACTOR_TEMPL_CODE
1213: FROM ZX_SCO_RULES_B_V r
1229: -- cursor for getting offset templates from rules
1230: --
1231: /*********************
1232: CURSOR get_offset_templ_csr
1233: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1234: c_tax ZX_TAXES_B.TAX%TYPE,
1235: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1236: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1237: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1233: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1234: c_tax ZX_TAXES_B.TAX%TYPE,
1235: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1236: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1237: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1238: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1239: IS
1240: SELECT TAX_RULE_ID,
1241: det_factor_templ_code
1234: c_tax ZX_TAXES_B.TAX%TYPE,
1235: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1236: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1237: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1238: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1239: IS
1240: SELECT TAX_RULE_ID,
1241: det_factor_templ_code
1242: FROM ZX_SCO_RULES_B_V
1268: -- determine which cursor to open
1269: --
1270: IF p_service_type_code = 'DET_RECOVERY_RATE' THEN
1271: --
1272: -- get recovery templates from ZX_RULES_B table.
1273: --
1274: OPEN get_recovery_templ_csr(p_service_type_code,
1275: p_tax,
1276: p_tax_regime_code,
1286: CLOSE get_recovery_templ_csr;
1287: /************************
1288: ELSIF p_service_type_code = 'DET_OFFSET_TAX' THEN
1289: --
1290: -- get offset templates from ZX_RULES_B table.
1291: --
1292: OPEN get_offset_templ_csr(p_service_type_code,
1293: p_tax,
1294: p_tax_regime_code,
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,
1414: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1415: p_tax IN ZX_TAXES_B.TAX%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,
1414: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
1415: p_tax IN ZX_TAXES_B.TAX%TYPE,
1416: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1417: p_return_status OUT NOCOPY VARCHAR2,
1424: -- for processes other than DET_RECOVERY_RATE and DET_TAX_RATE
1425: --
1426:
1427: CURSOR get_det_factor_templ_csr_c
1428: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1429: c_tax ZX_TAXES_B.TAX%TYPE,
1430: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1431: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1432: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE)
1428: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1429: c_tax ZX_TAXES_B.TAX%TYPE,
1430: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1431: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1432: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE)
1433: IS
1434: SELECT TAX_RULE_ID,
1435: TAX,
1436: TAX_REGIME_CODE,
1454: AND pr.enabled_flag = 'Y')
1455: ORDER BY PRIORITY;
1456:
1457: CURSOR get_det_factor_templ_csr_d
1458: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1459: c_tax ZX_TAXES_B.TAX%TYPE,
1460: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1461: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1462: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1458: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1459: c_tax ZX_TAXES_B.TAX%TYPE,
1460: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1461: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1462: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1463: IS
1464: SELECT TAX_RULE_ID,
1465: TAX,
1466: TAX_REGIME_CODE,
1484: AND pr.Enabled_Flag = 'Y')
1485: ORDER BY PRIORITY;
1486:
1487: CURSOR get_det_factor_templ_csr_e
1488: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1489: c_tax ZX_TAXES_B.TAX%TYPE,
1490: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1491: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1492: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1488: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1489: c_tax ZX_TAXES_B.TAX%TYPE,
1490: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1491: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1492: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1493: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE
1494: )
1495: IS
1496: SELECT TAX_RULE_ID,
1489: c_tax ZX_TAXES_B.TAX%TYPE,
1490: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1491: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1492: c_event_class_mapping_id ZX_RULES_B.EVENT_CLASS_MAPPING_ID%TYPE,
1493: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE
1494: )
1495: IS
1496: SELECT TAX_RULE_ID,
1497: TAX,
1526: l_tax_tbl TAX_TBL;
1527: l_tax_regime_code_tbl TAX_REGIME_CODE_TBL;
1528: l_tax_rule_id_tbl TAX_RULE_ID_TBL;
1529:
1530: --Bug 4670938 - Changed the type since EVENT_CLASS_CODE is removed from zx_rules_b
1531: l_source_event_class_code ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_CODE%TYPE;
1532:
1533: --CR#4255160. Added new variables to store the Rule level Determining Factor CQ,
1534: -- Geography type and Geography Id
1860: -- Phong La 03-JUN-02 Created
1861:
1862:
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,
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,
1872: p_found IN OUT NOCOPY BOOLEAN,
1873: p_parent_regime_cd_tbl IN TAX_REGIME_CODE_TBL,
1874: p_return_status OUT NOCOPY VARCHAR2,
1889: l_rule_geography_id_tbl RULE_GEOGRAPHY_ID_TBL;
1890:
1891:
1892: CURSOR get_templ_from_regime_hier_csr
1893: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1894: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1895: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1896: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1897: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1892: CURSOR get_templ_from_regime_hier_csr
1893: (c_service_type_code ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
1894: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1895: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1896: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1897: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1898: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1899: IS
1900: SELECT TAX_RULE_ID, TAX, TAX_REGIME_CODE, DET_FACTOR_TEMPL_CODE,
1894: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1895: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1896: c_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,
1897: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1898: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1899: IS
1900: SELECT TAX_RULE_ID, TAX, TAX_REGIME_CODE, DET_FACTOR_TEMPL_CODE,
1901: DETERMINING_FACTOR_CQ_CODE,
1902: GEOGRAPHY_TYPE,
1946: 'parent regime: ' || p_parent_regime_cd_tbl(i));
1947: END IF;
1948:
1949: --
1950: -- get templates from ZX_RULES_B table.
1951: --
1952:
1953: OPEN get_templ_from_regime_hier_csr(p_service_type_code,
1954: p_parent_regime_cd_tbl(i),
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,
2068: p_tax_regime_code_tbl IN TAX_REGIME_CODE_TBL,
2069: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2070: p_tax_rule_id_tbl IN TAX_RULE_ID_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,
2068: p_tax_regime_code_tbl IN TAX_REGIME_CODE_TBL,
2069: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2070: p_tax_rule_id_tbl IN TAX_RULE_ID_TBL,
2071: p_rule_det_factor_cq_tbl IN RULE_DET_FACTOR_CQ_TBL,
2072: p_rule_geography_type_tbl IN RULE_GEOGRAPHY_TYPE_TBL,
2073: p_rule_geography_id_tbl IN RULE_GEOGRAPHY_ID_TBL,
2081: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;
2082: l_valid BOOLEAN;
2083:
2084: --CR#4255160 - Added new variables to store the Geography context related information
2085: l_rule_det_factor_cq ZX_RULES_B.DETERMINING_FACTOR_CQ_CODE%TYPE;
2086: l_rule_geography_type ZX_RULES_B.GEOGRAPHY_TYPE%TYPE;
2087: l_rule_geography_id ZX_RULES_B.GEOGRAPHY_ID%TYPE;
2088:
2089: BEGIN
2082: l_valid BOOLEAN;
2083:
2084: --CR#4255160 - Added new variables to store the Geography context related information
2085: l_rule_det_factor_cq ZX_RULES_B.DETERMINING_FACTOR_CQ_CODE%TYPE;
2086: l_rule_geography_type ZX_RULES_B.GEOGRAPHY_TYPE%TYPE;
2087: l_rule_geography_id ZX_RULES_B.GEOGRAPHY_ID%TYPE;
2088:
2089: BEGIN
2090: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2083:
2084: --CR#4255160 - Added new variables to store the Geography context related information
2085: l_rule_det_factor_cq ZX_RULES_B.DETERMINING_FACTOR_CQ_CODE%TYPE;
2086: l_rule_geography_type ZX_RULES_B.GEOGRAPHY_TYPE%TYPE;
2087: l_rule_geography_id ZX_RULES_B.GEOGRAPHY_ID%TYPE;
2088:
2089: BEGIN
2090: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2091: IF (g_level_procedure >= g_current_runtime_level ) THEN
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,
2260: p_tax_rule_id IN ZX_RULES_B.TAX_RULE_ID%TYPE,
2261: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2262: p_result IN OUT NOCOPY BOOLEAN,
2263: p_result_id IN OUT NOCOPY NUMBER,
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,
2260: p_tax_rule_id IN ZX_RULES_B.TAX_RULE_ID%TYPE,
2261: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2262: p_result IN OUT NOCOPY BOOLEAN,
2263: p_result_id IN OUT NOCOPY NUMBER,
2264: p_found OUT NOCOPY BOOLEAN ,
2396: --
2397:
2398: CURSOR get_condition_group_codes_csr
2399: (c_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
2400: c_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE,
2401: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE)
2402: IS
2403: SELECT s.CONDITION_GROUP_ID, s.CONDITION_GROUP_CODE, More_Than_Max_Cond_Flag,
2404: Determining_Factor_Class1_Code, Determining_Factor_Cq1_Code,
6604: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
6605: l_tax_status_Code ZX_RATES_B.tax_status_code%type;
6606: l_tax_rate_Code ZX_RATES_B.tax_rate_Code%type;
6607: l_override_tax_rate_Code ZX_RATES_B.tax_rate_code%TYPE;
6608: l_service_type_code ZX_RULES_B.service_type_code%TYPE;
6609:
6610: BEGIN
6611:
6612: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6659: p_found := true;
6660: END IF;
6661:
6662: select service_type_code into l_service_type_code
6663: FROM zx_rules_b
6664: where tax_rule_id = p_zx_result_rec.tax_rule_id;
6665:
6666:
6667: -- For Migrated Records, Check if Condition Set and Exception Set is populated
7348:
7349: PROCEDURE check_rule_geography(
7350: p_structure_name IN VARCHAR2,
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,
7349: PROCEDURE check_rule_geography(
7350: p_structure_name IN VARCHAR2,
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,
7350: p_structure_name IN VARCHAR2,
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)