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_PROCESS_RESULTS

Line 226: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,

222: p_trx_line_index IN BINARY_INTEGER,
223: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE);
224:
225: PROCEDURE get_result(
226: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,
227: p_structure_name IN VARCHAR2,
228: p_structure_index IN BINARY_INTEGER,
229: p_tax_regime_code IN ZX_RATES_B.tax_regime_Code%TYPE,
230: p_tax IN ZX_RATES_B.tax%TYPE,

Line 233: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

229: p_tax_regime_code IN ZX_RATES_B.tax_regime_Code%TYPE,
230: p_tax IN ZX_RATES_B.tax%TYPE,
231: p_tax_determine_date IN DATE,
232: p_found IN OUT NOCOPY BOOLEAN,
233: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
234: p_return_status OUT NOCOPY VARCHAR2,
235: p_error_buffer OUT NOCOPY VARCHAR2);
236:
237: PROCEDURE init_set_condition;

Line 290: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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 ,
290: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
291: p_return_status OUT NOCOPY VARCHAR2,
292: p_error_buffer OUT NOCOPY VARCHAR2);
293:
294: PROCEDURE proc_det_factor_templ(

Line 310: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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,
310: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
311: p_return_status OUT NOCOPY VARCHAR2,
312: p_error_buffer OUT NOCOPY VARCHAR2);
313:
314: PROCEDURE process_rule_code(

Line 326: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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);
329:
330:

Line 342: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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,
346: p_error_buffer OUT NOCOPY VARCHAR2);

Line 356: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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,
360: p_error_buffer OUT NOCOPY VARCHAR2);

Line 663: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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:
667: IS

Line 725: FROM ZX_PROCESS_RESULTS pr

721: AND (TAX_EVENT_CLASS_CODE = c_tax_event_class_code OR
722: TAX_EVENT_CLASS_CODE IS NULL)
723: AND Enabled_Flag = 'Y'
724: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
725: FROM ZX_PROCESS_RESULTS pr
726: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
727: AND TAX_STATUS_CODE = c_tax_status_code
728: AND pr.Enabled_Flag = 'Y'
729: AND rownum = 1

Line 771: FROM ZX_PROCESS_RESULTS pr

767: AND (TAX_EVENT_CLASS_CODE = c_tax_event_class_code OR
768: TAX_EVENT_CLASS_CODE IS NULL)
769: AND Enabled_Flag = 'Y'
770: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
771: FROM ZX_PROCESS_RESULTS pr
772: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
773: AND pr.Enabled_Flag = 'Y'
774: AND rownum = 1
775: )

Line 814: FROM ZX_PROCESS_RESULTS pr

810: AND (APPLICATION_ID = c_reference_application_id OR
811: APPLICATION_ID IS NULL)
812: AND Enabled_Flag = 'Y'
813: AND EXISTS (SELECT result_id
814: FROM ZX_PROCESS_RESULTS pr
815: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
816: AND pr.Enabled_Flag = 'Y')
817: ORDER BY TAX, PRIORITY;
818:

Line 1427: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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)
1430: IS
1431: l_det_factor_templ_cd ZX_RULES_B.DET_FACTOR_TEMPL_CODE%TYPE;

Line 1434: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;

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;
1436:
1437: l_valid BOOLEAN;
1438:

Line 1662: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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,
1666: p_error_buffer OUT NOCOPY VARCHAR2)

Line 1700: FROM ZX_PROCESS_RESULTS pr

1696: AND System_Default_Flag <> 'Y'
1697: AND EVENT_CLASS_MAPPING_ID = c_event_class_mapping_id
1698: AND Enabled_Flag = 'Y'
1699: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
1700: FROM ZX_PROCESS_RESULTS pr
1701: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
1702: AND pr.enabled_flag = 'Y'
1703: AND rownum = 1
1704: )

Line 1732: FROM ZX_PROCESS_RESULTS pr

1728: AND System_Default_Flag <> 'Y'
1729: AND TAX_EVENT_CLASS_CODE = c_tax_event_class_code
1730: AND Enabled_Flag = 'Y'
1731: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
1732: FROM ZX_PROCESS_RESULTS pr
1733: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
1734: AND pr.Enabled_Flag = 'Y'
1735: AND rownum = 1
1736: )

Line 1769: FROM ZX_PROCESS_RESULTS pr

1765: AND (EVENT_CLASS_MAPPING_ID IS NULL OR
1766: EVENT_CLASS_MAPPING_ID = c_event_class_mapping_id)
1767: AND Enabled_Flag = 'Y'
1768: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
1769: FROM ZX_PROCESS_RESULTS pr
1770: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
1771: AND pr.Enabled_Flag = 'Y'
1772: AND rownum = 1
1773: )

Line 2204: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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,
2208: p_error_buffer OUT NOCOPY VARCHAR2)

Line 2251: FROM ZX_PROCESS_RESULTS pr

2247: AND (APPLICATION_ID = c_reference_application_id OR
2248: APPLICATION_ID IS NULL)
2249: AND Enabled_Flag = 'Y'
2250: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
2251: FROM ZX_PROCESS_RESULTS pr
2252: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
2253: AND pr.enabled_flag = 'Y'
2254: AND rownum = 1
2255: )

Line 2409: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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,
2409: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
2410: p_return_status OUT NOCOPY VARCHAR2,
2411: p_error_buffer OUT NOCOPY VARCHAR2)
2412: IS
2413: l_count NUMBER;

Line 2416: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;

2412: IS
2413: l_count NUMBER;
2414: l_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE;
2415: l_result BOOLEAN;
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;

Line 2600: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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 ,
2600: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
2601: p_return_status OUT NOCOPY VARCHAR2,
2602: p_error_buffer OUT NOCOPY VARCHAR2)
2603:
2604: IS

Line 2786: ZX_PROCESS_RESULTS p

2782: TAX_PARAMETER_CODE10, CHART_OF_ACCOUNTS_ID, LEDGER_ID,
2783: p.RESULT_ID,
2784: s.constraint_id
2785: FROM ZX_CONDITION_GROUPS_B s,
2786: ZX_PROCESS_RESULTS p
2787: WHERE --s.det_factor_templ_code = c_det_factor_templ_code AND
2788: s.enabled_flag = 'Y' AND
2789: --s.condition_group_code = p.condition_group_code AND
2790: s.condition_group_id = p.condition_group_id AND

Line 6981: -- The procedure gets the result from ZX_PROCESS_RESULTS table.

6977: -- get_result
6978: --
6979: -- DESCRIPTION
6980: --
6981: -- The procedure gets the result from ZX_PROCESS_RESULTS table.
6982: -- p_found being true will indicate if a result is found.
6983: --
6984:
6985: PROCEDURE get_result(

Line 6986: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,

6982: -- p_found being true will indicate if a result is found.
6983: --
6984:
6985: PROCEDURE get_result(
6986: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,
6987: p_structure_name IN VARCHAR2,
6988: p_structure_index IN BINARY_INTEGER,
6989: p_tax_regime_code IN ZX_RATES_B.tax_regime_Code%TYPE,
6990: p_tax IN ZX_RATES_B.tax%TYPE,

Line 6993: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

6989: p_tax_regime_code IN ZX_RATES_B.tax_regime_Code%TYPE,
6990: p_tax IN ZX_RATES_B.tax%TYPE,
6991: p_tax_determine_date IN DATE,
6992: p_found IN OUT NOCOPY BOOLEAN,
6993: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
6994: p_return_status OUT NOCOPY VARCHAR2,
6995: p_error_buffer OUT NOCOPY VARCHAR2)
6996:
6997: IS

Line 7025: FROM ZX_PROCESS_RESULTS

7021: CONDITION_GROUP_ID,
7022: CONDITION_SET_ID,
7023: EXCEPTION_SET_ID,
7024: TAX_RULE_ID
7025: FROM ZX_PROCESS_RESULTS
7026: WHERE RESULT_ID = p_result_id;
7027:
7028: CURSOR select_tax_status_rate_code
7029: (c_tax_regime_code VARCHAR2,

Line 7052: l_zx_result_rec_null ZX_PROCESS_RESULTS%ROWTYPE;

7048:
7049:
7050: l_condition_set_result BOOLEAN;
7051: l_exception_set_result BOOLEAN;
7052: l_zx_result_rec_null ZX_PROCESS_RESULTS%ROWTYPE;
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;