[Home] [Help]
13: p_error_buffer OUT NOCOPY VARCHAR2);
14:
15: PROCEDURE get_fsc_code(
16: p_found IN OUT NOCOPY BOOLEAN,
17: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
18: p_classification_category IN
19: ZX_FC_TYPES_B.Classification_Type_Categ_Code%TYPE,
20: p_classification_type IN
21: ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
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,
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,
50: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
51: p_return_status OUT NOCOPY VARCHAR2,
52: p_error_buffer OUT NOCOPY VARCHAR2);
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,
134: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
135: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
136: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
137: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
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,
259: p_chart_of_accounts_id IN
260: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
261: p_sob_id IN
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,
276: p_chart_of_accounts_id IN
277: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
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,
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,
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,
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,
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,
355: p_error_buffer OUT NOCOPY VARCHAR2);
356:
357: PROCEDURE get_rule_from_regime_hier(
632:
633: l_det_factor_templ_cd_tbl DET_FACTOR_TEMPL_CODE_TBL;
634: l_found BOOLEAN;
635: l_tax ZX_TAXES_B.TAX%TYPE;
636: l_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
637: l_tax_tbl TAX_TBL;
638: l_tax_regime_code_tbl TAX_REGIME_CODE_TBL;
639: l_parent_regime_code_tbl TAX_REGIME_CODE_TBL;
640: l_tax_rule_id_tbl TAX_RULE_ID_TBL;
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,
659: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
660: IS
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,
696: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
697: IS
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)
739: IS
740: SELECT TAX_RULE_ID,
768: --
769: -- cursor to get a parent regime code for a given tax regime
770: --
771: CURSOR get_regime_code_csr
772: (c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
773: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
774: IS
775: SELECT PARENT_REGIME_CODE
776: FROM ZX_REGIME_RELATIONS
776: FROM ZX_REGIME_RELATIONS
777: WHERE REGIME_CODE = c_tax_regime_code
778: -- AND c_tax_determine_date >= EFFECTIVE_FROM -- This effective period
779: -- AND (c_tax_determine_date <= EFFECTIVE_TO OR -- should be the same as
780: -- EFFECTIVE_TO IS NULL) -- the one in zx_regimes_b
781: ORDER BY PARENT_REG_LEVEL;
782:
783: BEGIN
784:
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,
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,
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,
1208: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1209: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
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,
1238: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1239: IS
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,
1418: p_error_buffer OUT NOCOPY VARCHAR2)
1419: IS
1420:
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)
1433: IS
1434: SELECT TAX_RULE_ID,
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)
1463: IS
1464: SELECT TAX_RULE_ID,
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,
1493: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE
1494: )
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,
1898: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
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,
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,
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,
3012: p_result IN OUT NOCOPY BOOLEAN,
3013: p_chart_of_accounts_id 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,
3303: p_result IN OUT NOCOPY BOOLEAN,
3304: p_chart_of_accounts_id IN
3305: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3306: p_sob_id IN
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,
3566: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3567: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3568: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3569: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,
4659: p_structure_name IN VARCHAR2,
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,
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,
5798: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
5799: p_return_status OUT NOCOPY VARCHAR2,
5800: p_error_buffer OUT NOCOPY VARCHAR2)
6950: -- Phong La 21-MAY-02 Created
6951: --
6952: PROCEDURE get_fsc_code(
6953: p_found IN OUT NOCOPY BOOLEAN,
6954: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
6955: p_classification_category IN
6956: ZX_FC_TYPES_B.Classification_Type_Categ_Code%TYPE,
6957: p_classification_type IN
6958: ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,