DBA Data[Home] [Help]

APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_STATUS_B

Line 286: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%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,
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,

Line 298: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

294: PROCEDURE proc_det_factor_templ(
295: p_structure_name IN VARCHAR2,
296: p_structure_index IN BINARY_INTEGER,
297: p_det_factor_templ_cd_tbl IN DET_FACTOR_TEMPL_CODE_TBL,
298: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
299: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
300: p_tax_tbl IN TAX_TBL,
301: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
302: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,

Line 322: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

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,
325: p_found IN OUT NOCOPY BOOLEAN,
326: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

Line 336: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

332: -- Bugfix 4017396 Removed unwanted parameters
333: PROCEDURE fetch_proc_det_factor_templ(
334: p_structure_name IN VARCHAR2,
335: p_structure_index IN BINARY_INTEGER,
336: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
337: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
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,

Line 353: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

349: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
350: p_structure_name IN VARCHAR2,
351: p_structure_index IN BINARY_INTEGER,
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,

Line 659: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

655: p_structure_name IN VARCHAR2,
656: p_structure_index IN BINARY_INTEGER,
657: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
658: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
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,

Line 696: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

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

Line 1423: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

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,
1426: p_found IN OUT NOCOPY BOOLEAN,
1427: p_zx_result_rec OUT NOCOPY ZX_PROCESS_RESULTS%ROWTYPE,

Line 1656: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

1652:
1653: PROCEDURE fetch_proc_det_factor_templ(
1654: p_structure_name IN VARCHAR2,
1655: p_structure_index IN BINARY_INTEGER,
1656: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1657: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
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,

Line 2201: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

2197: p_service_type_code IN ZX_RULES_B.SERVICE_TYPE_CODE%TYPE,
2198: p_structure_name IN VARCHAR2,
2199: p_structure_index IN BINARY_INTEGER,
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,

Line 2230: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

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)
2232: IS
2233: SELECT TAX_RULE_ID, TAX, TAX_REGIME_CODE, DET_FACTOR_TEMPL_CODE,
2234: DETERMINING_FACTOR_CQ_CODE,

Line 2397: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

2393: PROCEDURE proc_det_factor_templ(
2394: p_structure_name IN VARCHAR2,
2395: p_structure_index IN BINARY_INTEGER,
2396: p_det_factor_templ_cd_tbl IN det_factor_templ_code_tbl,
2397: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2398: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2399: p_tax_tbl IN TAX_TBL,
2400: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2401: p_recovery_type_code IN ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE,

Line 2596: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%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,
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,

Line 2739: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE)

2735:
2736: CURSOR get_condition_group_codes_csr
2737: (c_det_factor_templ_code ZX_DET_FACTOR_TEMPL_B.det_factor_templ_code%TYPE,
2738: c_tax_rule_id ZX_RULES_B.TAX_RULE_ID%TYPE,
2739: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE)
2740: IS
2741: SELECT /*+ leading(P) use_nl_with_index(s ZX_CONDITION_GROUPS_B_U1) */
2742: s.CONDITION_GROUP_ID, s.CONDITION_GROUP_CODE, More_Than_Max_Cond_Flag,
2743: Determining_Factor_Class1_Code, Determining_Factor_Cq1_Code,