[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure bulk_insert_conditions (
X_DETERMINING_FACTOR_CODE IN t_determining_factor_code,
X_CONDITION_GROUP_CODE IN t_condition_group_code,
X_TAX_PARAMETER_CODE IN t_tax_parameter_code,
X_DATA_TYPE_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS_COD IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ_CODE IN t_determining_factor_cq,
X_OPERATOR_CODE IN t_operator,
X_RECORD_TYPE_CODE IN t_record_type,
X_IGNORE_FLAG IN t_ignore_flg,
X_NUMERIC_VALUE IN t_numeric_value,
X_DATE_VALUE IN t_date_value,
X_ALPHANUMERIC_VALUE IN t_alphanumeric_value,
X_VALUE_LOW IN t_value_low,
X_VALUE_HIGH IN t_value_high) is
l_user_id NUMBER;
INSERT INTO ZX_CONDITIONS
(condition_id,
determining_factor_code,
condition_group_code,
tax_parameter_code,
data_type_code,
determining_factor_class_code,
determining_factor_cq_code,
operator_code,
record_type_code,
ignore_flag,
numeric_value,
date_value,
alphanumeric_value,
value_low,
value_high,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
request_id,
program_application_id,
program_id,
program_login_id)
VALUES
(zx_conditions_s.nextval,
X_DETERMINING_FACTOR_CODE(i),
X_CONDITION_GROUP_CODE(i),
X_TAX_PARAMETER_CODE(i),
X_DATA_TYPE_CODE(i),
X_DETERMINING_FACTOR_CLASS_COD(i),
X_DETERMINING_FACTOR_CQ_CODE(i),
X_OPERATOR_CODE(i),
X_RECORD_TYPE_CODE(i),
X_IGNORE_FLAG(i),
X_NUMERIC_VALUE(i),
X_DATE_VALUE(i),
X_ALPHANUMERIC_VALUE(i),
X_VALUE_LOW(i),
X_VALUE_HIGH(i),
l_user_id,
sysdate,
l_user_id,
sysdate,
l_conc_login_id,
l_request_id,
l_prog_appl_id,
l_conc_program_id,
l_conc_login_id
);
END BULK_INSERT_CONDITIONS;
SELECT a.condition_group_code
INTO x_condition_group_code
FROM zx_condition_groups_b a, zx_conditions b
WHERE a.det_factor_templ_code = p_det_factor_templ_code
AND a.condition_group_id <> p_condition_group_id
AND b.condition_id <> p_condition_id
AND b.condition_group_code = a.condition_group_code
AND b.determining_factor_code = p_det_factor_code
AND b.determining_factor_class_code = p_det_factor_class_code
AND b.determining_factor_cq_code IS NULL
AND b.operator_code = p_operator_code
AND NVL(b.ignore_flag,'N') = 'N'
AND NVL(b.ALPHANUMERIC_VALUE,l_miss_char) = NVL(p_alphanumeric_value,l_miss_char)
AND NVL(b.NUMERIC_VALUE,l_miss_number) = NVL(p_numeric_value,l_miss_number)
AND NVL(b.DATE_VALUE,l_miss_date) = NVL(p_date_value,l_miss_date)
AND NVL(b.VALUE_LOW,l_miss_char) = NVL(p_value_low,l_miss_char)
AND NVL(b.VALUE_HIGH,l_miss_char) = NVL(p_value_high,l_miss_char)
AND rownum = 1;
SELECT a.condition_group_code
INTO x_condition_group_code
FROM zx_condition_groups_b a, zx_conditions b
WHERE a.det_factor_templ_code = p_det_factor_templ_code
AND a.condition_group_id <> p_condition_group_id
AND b.condition_id <> p_condition_id
AND b.condition_group_code = a.condition_group_code
AND b.determining_factor_code = p_det_factor_code
AND b.determining_factor_class_code = p_det_factor_class_code
AND b.determining_factor_cq_code = p_det_factor_cq_code
AND b.operator_code = p_operator_code
AND NVL(b.ignore_flag,'N') = 'N'
AND NVL(b.ALPHANUMERIC_VALUE,l_miss_char) = NVL(p_alphanumeric_value,l_miss_char)
AND NVL(b.NUMERIC_VALUE,l_miss_number) = NVL(p_numeric_value,l_miss_number)
AND NVL(b.DATE_VALUE,l_miss_date) = NVL(p_date_value,l_miss_date)
AND NVL(b.VALUE_LOW,l_miss_char) = NVL(p_value_low,l_miss_char)
AND NVL(b.VALUE_HIGH,l_miss_char) = NVL(p_value_high,l_miss_char)
AND rownum = 1;