eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_REGIMES_B

Line 17: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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,

Line 37: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

33: p_structure_name IN VARCHAR2,
34: p_structure_index IN BINARY_INTEGER,
35: p_condition_index IN BINARY_INTEGER,
36: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
37: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
38: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
39: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
40: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
41: p_return_status OUT NOCOPY VARCHAR2,

Line 50: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

46: p_structure_index IN BINARY_INTEGER,
47: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
48: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
49: p_tax IN ZX_TAXES_B.TAX%TYPE,
50: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
51: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
52: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
53: p_return_status OUT NOCOPY VARCHAR2,
54: p_error_buffer OUT NOCOPY VARCHAR2);

Line 135: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

131: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
132: p_condition_index IN BINARY_INTEGER,
133: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
134: p_tax IN ZX_TAXES_B.TAX%TYPE,
135: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
136: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
137: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
138: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
139: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,

Line 248: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

244: p_structure_index IN BINARY_INTEGER,
245: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
246: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
247: p_tax IN ZX_TAXES_B.TAX%TYPE,
248: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
249: p_result IN OUT NOCOPY BOOLEAN,
250: p_chart_of_accounts_id IN
251: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
252: p_sob_id IN

Line 264: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

260: p_structure_index IN BINARY_INTEGER,
261: p_condition_group_code IN ZX_CONDITION_GROUPS_B.CONDITION_GROUP_CODE%TYPE,
262: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
263: p_tax IN ZX_TAXES_B.TAX%TYPE,
264: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
265: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
266: p_result IN OUT NOCOPY BOOLEAN,
267: p_chart_of_accounts_id IN
268: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,

Line 282: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

278: p_det_factor_templ_code IN
279: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
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,

Line 320: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_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,
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,

Line 344: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_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,
346: p_error_buffer OUT NOCOPY VARCHAR2);
347:
348: PROCEDURE get_rule_from_regime_hier(

Line 672: l_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;

668:
669: l_det_factor_templ_cd_tbl DET_FACTOR_TEMPL_CODE_TBL;
670: l_found BOOLEAN;
671: l_tax ZX_TAXES_B.TAX%TYPE;
672: l_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
673: l_tax_tbl TAX_TBL;
674: l_tax_regime_code_tbl TAX_REGIME_CODE_TBL;
675: l_parent_regime_code_tbl TAX_REGIME_CODE_TBL;
676: l_tax_rule_id_tbl TAX_RULE_ID_TBL;

Line 694: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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,
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,

Line 740: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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,
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,

Line 791: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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)
794: IS
795: SELECT TAX_RULE_ID,

Line 827: (c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

823: --
824: -- cursor to get a parent regime code for a given tax regime
825: --
826: CURSOR get_regime_code_csr
827: (c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
828: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
829: IS
830: SELECT PARENT_REGIME_CODE
831: FROM ZX_REGIME_RELATIONS

Line 835: -- EFFECTIVE_TO IS NULL) -- the one in zx_regimes_b

831: FROM ZX_REGIME_RELATIONS
832: WHERE REGIME_CODE = c_tax_regime_code
833: -- AND c_tax_determine_date >= EFFECTIVE_FROM -- This effective period
834: -- AND (c_tax_determine_date <= EFFECTIVE_TO OR -- should be the same as
835: -- EFFECTIVE_TO IS NULL) -- the one in zx_regimes_b
836: ORDER BY PARENT_REG_LEVEL;
837:
838: BEGIN
839:

Line 1421: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_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,
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,

Line 1445: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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,
1448: c_tax_rule_code ZX_RULES_B.TAX_RULE_CODE%TYPE,
1449: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE,

Line 1481: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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,
1484: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1485: IS

Line 1664: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_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,
1666: p_error_buffer OUT NOCOPY VARCHAR2)
1667: IS
1668:

Line 1678: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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)
1681: IS
1682: SELECT TAX_RULE_ID,

Line 1710: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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)
1713: IS
1714: SELECT TAX_RULE_ID,

Line 1742: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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,
1745: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE
1746: )

Line 2227: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

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,
2231: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)

Line 2592: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

2588: p_det_factor_templ_code IN
2589: ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
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,

Line 3252: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

3248: ZX_CONDITION_GROUPS_B.condition_group_CODE%TYPE,
3249: p_event_class_rec IN
3250: ZX_API_PUB.EVENT_CLASS_REC_TYPE,
3251: p_tax IN ZX_TAXES_B.TAX%TYPE,
3252: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3253: p_tax_determine_date IN
3254: ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3255: p_result IN OUT NOCOPY BOOLEAN,
3256: p_chart_of_accounts_id IN

Line 3640: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

3636: ZX_API_PUB.EVENT_CLASS_REC_TYPE,
3637: p_tax_determine_date IN
3638: ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3639: p_tax IN ZX_TAXES_B.TAX%TYPE,
3640: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3641: p_result IN OUT NOCOPY BOOLEAN,
3642: p_chart_of_accounts_id IN
3643: ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
3644: p_sob_id IN

Line 3914: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

3910: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
3911: p_condition_index IN BINARY_INTEGER,
3912: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
3913: p_tax IN ZX_TAXES_B.TAX%TYPE,
3914: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
3915: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
3916: p_numeric_value OUT NOCOPY ZX_CONDITIONS.NUMERIC_VALUE%TYPE,
3917: p_alphanum_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
3918: p_date_value OUT NOCOPY ZX_CONDITIONS.DATE_VALUE%TYPE,

Line 5004: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

5000: p_structure_name IN VARCHAR2,
5001: p_structure_index IN BINARY_INTEGER,
5002: p_condition_index IN BINARY_INTEGER,
5003: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
5004: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5005: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5006: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
5007: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
5008: p_return_status OUT NOCOPY VARCHAR2,

Line 6247: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

6243: p_structure_index IN BINARY_INTEGER,
6244: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
6245: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
6246: p_tax IN ZX_TAXES_B.TAX%TYPE,
6247: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
6248: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6249: p_Determining_Factor_Cq_Code IN ZX_CONDITIONS.Determining_Factor_Cq_Code%TYPE,
6250: p_return_status OUT NOCOPY VARCHAR2,
6251: p_error_buffer OUT NOCOPY VARCHAR2)

Line 7415: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

7411: -- Phong La 21-MAY-02 Created
7412: --
7413: PROCEDURE get_fsc_code(
7414: p_found IN OUT NOCOPY BOOLEAN,
7415: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
7416: p_classification_category IN
7417: ZX_FC_TYPES_B.Classification_Type_Categ_Code%TYPE,
7418: p_classification_type IN
7419: ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,