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.

[Home] [Help]

APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_PROCESS_RESULTS

Line 224: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,

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

Line 231: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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

Line 299: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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 ,
299: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
300: p_return_status OUT NOCOPY VARCHAR2,
301: p_error_buffer OUT NOCOPY VARCHAR2);
302:
303: PROCEDURE proc_det_factor_templ(

Line 319: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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,
319: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
320: p_return_status OUT NOCOPY VARCHAR2,
321: p_error_buffer OUT NOCOPY VARCHAR2);
322:
323: PROCEDURE process_rule_code(

Line 335: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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);
338:
339:

Line 351: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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

Line 365: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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

Line 627: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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

Line 680: FROM ZX_PROCESS_RESULTS pr

676: AND (APPLICATION_ID = c_reference_application_id OR
677: APPLICATION_ID IS NULL)
678: AND Enabled_Flag = 'Y'
679: AND EXISTS (SELECT result_id
680: FROM ZX_PROCESS_RESULTS pr
681: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
682: AND TAX_STATUS_CODE = c_tax_status_code
683: AND pr.Enabled_Flag = 'Y')
684: ORDER BY TAX, PRIORITY;

Line 717: FROM ZX_PROCESS_RESULTS pr

713: AND RECOVERY_TYPE_CODE = c_recovery_type_code
714: AND (APPLICATION_ID = c_reference_application_id OR
715: APPLICATION_ID IS NULL)
716: AND EXISTS (SELECT result_id
717: FROM ZX_PROCESS_RESULTS pr
718: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
719: AND pr.Enabled_Flag = 'Y')
720: AND Enabled_Flag = 'Y'
721: ORDER BY TAX, PRIORITY;

Line 759: FROM ZX_PROCESS_RESULTS pr

755: AND (APPLICATION_ID = c_reference_application_id OR
756: APPLICATION_ID IS NULL)
757: AND Enabled_Flag = 'Y'
758: AND EXISTS (SELECT result_id
759: FROM ZX_PROCESS_RESULTS pr
760: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
761: AND pr.Enabled_Flag = 'Y')
762: ORDER BY TAX, PRIORITY;
763:

Line 1187: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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

Line 1194: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;

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;
1196:
1197: l_valid BOOLEAN;
1198:

Line 1414: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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

Line 1452: FROM ZX_PROCESS_RESULTS pr

1448: AND System_Default_Flag <> 'Y'
1449: AND EVENT_CLASS_MAPPING_ID = c_event_class_mapping_id
1450: AND Enabled_Flag = 'Y'
1451: AND EXISTS (SELECT result_id
1452: FROM ZX_PROCESS_RESULTS pr
1453: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
1454: AND pr.enabled_flag = 'Y')
1455: ORDER BY PRIORITY;
1456:

Line 1482: FROM ZX_PROCESS_RESULTS pr

1478: AND System_Default_Flag <> 'Y'
1479: AND TAX_EVENT_CLASS_CODE = c_tax_event_class_code
1480: AND Enabled_Flag = 'Y'
1481: AND EXISTS (SELECT result_id
1482: FROM ZX_PROCESS_RESULTS pr
1483: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
1484: AND pr.Enabled_Flag = 'Y')
1485: ORDER BY PRIORITY;
1486:

Line 1517: FROM ZX_PROCESS_RESULTS pr

1513: AND (EVENT_CLASS_MAPPING_ID IS NULL OR
1514: EVENT_CLASS_MAPPING_ID = c_event_class_mapping_id)
1515: AND Enabled_Flag = 'Y'
1516: AND EXISTS (SELECT result_id
1517: FROM ZX_PROCESS_RESULTS pr
1518: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID
1519: AND pr.Enabled_Flag = 'Y')
1520: ORDER BY EVENT_CLASS_MAPPING_ID NULLS LAST,
1521: TAX_EVENT_CLASS_CODE NULLS LAST,

Line 1871: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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

Line 1918: FROM ZX_PROCESS_RESULTS pr

1914: AND (APPLICATION_ID = c_reference_application_id OR
1915: APPLICATION_ID IS NULL)
1916: AND Enabled_Flag = 'Y'
1917: AND EXISTS (SELECT result_id
1918: FROM ZX_PROCESS_RESULTS pr
1919: WHERE pr.TAX_RULE_ID = r.TAX_RULE_ID)
1920: ORDER BY PRIORITY;
1921:
1922: BEGIN

Line 2074: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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,
2074: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
2075: p_return_status OUT NOCOPY VARCHAR2,
2076: p_error_buffer OUT NOCOPY VARCHAR2)
2077: IS
2078: l_count NUMBER;

Line 2081: l_result_id ZX_PROCESS_RESULTS.RESULT_ID%TYPE;

2077: IS
2078: l_count NUMBER;
2079: l_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE;
2080: l_result BOOLEAN;
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;

Line 2265: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

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 ,
2265: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
2266: p_return_status OUT NOCOPY VARCHAR2,
2267: p_error_buffer OUT NOCOPY VARCHAR2)
2268:
2269: IS

Line 2447: ZX_PROCESS_RESULTS p

2443: TAX_PARAMETER_CODE10, CHART_OF_ACCOUNTS_ID, LEDGER_ID,
2444: p.RESULT_ID,
2445: s.constraint_id
2446: FROM ZX_CONDITION_GROUPS_B s,
2447: ZX_PROCESS_RESULTS p
2448: WHERE s.DET_FACTOR_TEMPL_CODE = c_det_factor_templ_code AND
2449: s.Enabled_Flag = 'Y' AND
2450: s.CONDITION_GROUP_CODE = p.condition_group_CODE AND
2451: p.TAX_RULE_ID = c_tax_rule_id AND

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

6528: -- get_result
6529: --
6530: -- DESCRIPTION
6531: --
6532: -- The procedure gets the result from ZX_PROCESS_RESULTS table.
6533: -- p_found being true will indicate if a result is found.
6534: --
6535:
6536: PROCEDURE get_result(

Line 6537: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,

6533: -- p_found being true will indicate if a result is found.
6534: --
6535:
6536: PROCEDURE get_result(
6537: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,
6538: p_structure_name IN VARCHAR2,
6539: p_structure_index IN BINARY_INTEGER,
6540: p_tax_regime_code IN ZX_RATES_B.tax_regime_Code%TYPE,
6541: p_tax IN ZX_RATES_B.tax%TYPE,

Line 6544: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

6540: p_tax_regime_code IN ZX_RATES_B.tax_regime_Code%TYPE,
6541: p_tax IN ZX_RATES_B.tax%TYPE,
6542: p_tax_determine_date IN DATE,
6543: p_found OUT NOCOPY BOOLEAN,
6544: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,
6545: p_return_status OUT NOCOPY VARCHAR2,
6546: p_error_buffer OUT NOCOPY VARCHAR2)
6547:
6548: IS

Line 6576: FROM ZX_PROCESS_RESULTS

6572: CONDITION_GROUP_ID,
6573: CONDITION_SET_ID,
6574: EXCEPTION_SET_ID,
6575: TAX_RULE_ID
6576: FROM ZX_PROCESS_RESULTS
6577: WHERE RESULT_ID = p_result_id;
6578:
6579: CURSOR select_tax_status_rate_code
6580: (c_tax_regime_code VARCHAR2,

Line 6603: l_zx_result_rec_null ZX_PROCESS_RESULTS%ROWTYPE;

6599:
6600:
6601: l_condition_set_result BOOLEAN;
6602: l_exception_set_result BOOLEAN;
6603: l_zx_result_rec_null ZX_PROCESS_RESULTS%ROWTYPE;
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;