DBA Data[Home] [Help]

APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_LINES_DET_FACTORS

Line 7919: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,

7915: x_end_index IN OUT NOCOPY BINARY_INTEGER,
7916: x_return_status OUT NOCOPY VARCHAR2) IS
7917:
7918: CURSOR get_unique_constraint_csr(
7919: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7920: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7921: IS
7922: SELECT cg.constraint_id
7923: FROM zx_condition_groups_b cg,

Line 7920: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)

7916: x_return_status OUT NOCOPY VARCHAR2) IS
7917:
7918: CURSOR get_unique_constraint_csr(
7919: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7920: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7921: IS
7922: SELECT cg.constraint_id
7923: FROM zx_condition_groups_b cg,
7924: ar_tax_conditions_all tc

Line 7933: -- (c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE)

7929: AND tc.org_id = c_internal_organization_id;
7930:
7931:
7932: -- CURSOR get_constraints_csr
7933: -- (c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE)
7934: -- IS
7935: -- SELECT cg.CONSTRAINT_ID
7936: -- FROM zx_condition_groups_b cg
7937: -- WHERE cg.CONDITION_GROUP_CODE like c_tax_classification_code||'~'||'%'

Line 7943: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,

7939: -- AND cg.constraint_id IS NOT NULL;
7940: --
7941: --
7942: -- CURSOR get_unique_constraint_csr(
7943: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7944: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7945: -- IS
7946: -- SELECT cg.constraint_id
7947: -- FROM zx_condition_groups_b cg,

Line 7944: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)

7940: --
7941: --
7942: -- CURSOR get_unique_constraint_csr(
7943: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7944: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7945: -- IS
7946: -- SELECT cg.constraint_id
7947: -- FROM zx_condition_groups_b cg,
7948: -- ar_tax_conditions tc

Line 8113: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;

8109: -- Local variables
8110: --
8111: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8112: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8113: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8114: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8115: l_cec_result BOOLEAN;
8116: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8117: l_tax_regime_code_tbl tax_regime_code_tbl;

Line 8114: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;

8110: --
8111: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8112: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8113: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8114: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8115: l_cec_result BOOLEAN;
8116: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8117: l_tax_regime_code_tbl tax_regime_code_tbl;
8118: l_tax_tbl tax_tbl;