[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
(p_sim_tax_rule_id NUMBER,
p_content_owner_id NUMBER,
p_tax_rule_code VARCHAR2,
p_tax VARCHAR2,
p_tax_regime_code VARCHAR2,
p_service_type_code VARCHAR2,
p_priority NUMBER,
p_det_factor_templ_code VARCHAR2,
p_effective_from DATE,
p_simulated_flag VARCHAR2,
p_created_by NUMBER,
p_creation_date DATE,
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER,
p_effective_to DATE,
p_application_id NUMBER,
p_recovery_type_code VARCHAR2,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_id NUMBER,
p_program_login_id NUMBER) IS
l_return_status VARCHAR2(1000);
'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
'ZX_SIM_RULES_PKG: Insert_Row (+)');
INSERT INTO ZX_SIM_RULES_B (sim_tax_rule_id,
content_owner_id,
tax_rule_code,
tax,
tax_regime_code,
service_type_code,
priority,
det_factor_templ_code,
effective_from,
simulated_flag,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
effective_to,
application_id,
recovery_type_code,
request_id,
program_application_id,
program_id,
program_login_id)
VALUES (p_sim_tax_rule_id,
p_content_owner_id,
p_tax_rule_code,
p_tax,
p_tax_regime_code,
p_service_type_code,
p_priority,
p_det_factor_templ_code,
p_effective_from,
p_simulated_flag,
p_created_by,
p_creation_date,
p_last_updated_by,
p_last_update_date,
p_last_update_login,
p_effective_to,
p_application_id,
p_recovery_type_code,
p_request_id,
p_program_application_id,
p_program_id,
p_program_login_id);
'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
'ZX_SIM_RULES_PKG: Insert_Row (-)');
END Insert_Row;
PROCEDURE Update_Row
(p_sim_tax_rule_id NUMBER,
p_content_owner_id NUMBER,
p_tax_rule_code VARCHAR2,
p_tax VARCHAR2,
p_tax_regime_code VARCHAR2,
p_service_type_code VARCHAR2,
p_priority NUMBER,
p_det_factor_templ_code VARCHAR2,
p_effective_from DATE,
p_simulated_flag VARCHAR2,
p_created_by NUMBER,
p_creation_date DATE,
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER,
p_effective_to DATE,
p_application_id NUMBER,
p_recovery_type_code VARCHAR2,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_id NUMBER,
p_program_login_id NUMBER) IS
l_return_status VARCHAR2(1000);
'ZX.PLSQL.ZX_SIM_RULES_PKG.Update_Row.BEGIN',
'ZX_SIM_RULES_PKG: Update_Row (+)');
UPDATE ZX_SIM_RULES_B
SET sim_tax_rule_id = p_sim_tax_rule_id,
content_owner_id = p_content_owner_id,
tax_rule_code = p_tax_rule_code,
tax = p_tax,
tax_regime_code = p_tax_regime_code,
service_type_code = p_service_type_code,
priority = p_priority,
det_factor_templ_code = p_det_factor_templ_code,
effective_from = p_effective_from,
simulated_flag = p_simulated_flag,
created_by = p_created_by,
creation_date = p_creation_date,
last_updated_by = p_last_updated_by,
last_update_date = p_last_update_date,
last_update_login = p_last_update_login,
effective_to = p_effective_to,
application_id = p_application_id,
recovery_type_code = p_recovery_type_code,
request_id = p_request_id,
program_application_id = p_program_application_id,
program_id = p_program_id,
program_login_id = p_program_login_id
WHERE sim_tax_rule_id = p_sim_tax_rule_id
AND content_owner_id = p_content_owner_id
AND application_id = p_application_id;
'ZX.PLSQL.ZX_SIM_RULES_PKG.Update_Row.BEGIN',
'ZX_SIM_RULES_PKG: Update_Row (-)');
END Update_Row;
PROCEDURE Delete_Row
(p_sim_tax_rule_id NUMBER,
p_content_owner_id NUMBER,
p_tax_rule_code VARCHAR2,
p_tax VARCHAR2,
p_tax_regime_code VARCHAR2,
p_service_type_code VARCHAR2,
p_priority NUMBER,
p_det_factor_templ_code VARCHAR2,
p_effective_from DATE,
p_simulated_flag VARCHAR2,
p_created_by NUMBER,
p_creation_date DATE,
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER,
p_effective_to DATE,
p_application_id NUMBER,
p_recovery_type_code VARCHAR2,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_id NUMBER,
p_program_login_id NUMBER) IS
l_return_status VARCHAR2(1000);
'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
'ZX_SIM_RULES_PKG: Delete_Row (+)');
'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
'ZX_SIM_RULES_PKG: Delete_Row (-)');
END Delete_Row;
p_last_updated_by NUMBER,
p_last_update_date DATE,
p_last_update_login NUMBER,
p_effective_to DATE,
p_application_id NUMBER,
p_recovery_type_code VARCHAR2,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_id NUMBER,
p_program_login_id NUMBER) IS
l_return_status VARCHAR2(1000);
SELECT sim_tax_rule_id,
content_owner_id,
tax_rule_code,
tax,
tax_regime_code,
service_type_code,
priority,
det_factor_templ_code,
effective_from,
simulated_flag,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
effective_to,
application_id,
recovery_type_code,
request_id,
program_application_id,
program_id,
program_login_id
FROM ZX_SIM_RULES_B
WHERE SIM_TAX_RULE_ID = p_sim_tax_rule_id
AND CONTENT_OWNER_ID = p_content_owner_id
AND APPLICATION_ID = p_application_id;
'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
'ZX_SIM_RULES_PKG: Lock_Row (+)');
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
(Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY) AND
(Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE) AND
((Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN) OR
((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND
(p_LAST_UPDATE_LOGIN IS NULL))) AND
((Recinfo.EFFECTIVE_TO = p_EFFECTIVE_TO) OR
((Recinfo.EFFECTIVE_TO IS NULL) AND
(p_EFFECTIVE_TO IS NULL))) AND
((Recinfo.APPLICATION_ID = p_APPLICATION_ID) OR
((Recinfo.APPLICATION_ID IS NULL) AND
(p_APPLICATION_ID IS NULL))) AND
((Recinfo.RECOVERY_TYPE_CODE = p_RECOVERY_TYPE_CODE) OR
((Recinfo.RECOVERY_TYPE_CODE IS NULL) AND
(p_RECOVERY_TYPE_CODE IS NULL))) AND
((Recinfo.REQUEST_ID = p_REQUEST_ID) OR
((Recinfo.REQUEST_ID IS NULL) AND
(p_REQUEST_ID IS NULL))) AND
((Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID) OR
((Recinfo.PROGRAM_APPLICATION_ID IS NULL) AND
(p_PROGRAM_APPLICATION_ID IS NULL))) AND
((Recinfo.PROGRAM_ID = p_PROGRAM_ID) OR
((Recinfo.PROGRAM_ID IS NULL) AND
(p_PROGRAM_ID IS NULL))) AND
((Recinfo.PROGRAM_LOGIN_ID = p_PROGRAM_LOGIN_ID) OR
((Recinfo.PROGRAM_LOGIN_ID IS NULL) AND
(p_PROGRAM_LOGIN_ID IS NULL))) ) THEN
RETURN;
'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
'ZX_SIM_RULES_PKG: Lock_Row (-)');
delete from ZX_SIM_RULES_TL T
where not exists
(select NULL
from ZX_SIM_RULES_B B
where B.SIM_TAX_RULE_ID = T.SIM_TAX_RULE_ID);
update ZX_SIM_RULES_TL T set (
TAX_RULE_NAME
) = (select B.TAX_RULE_NAME
from ZX_SIM_RULES_TL B
where B.SIM_TAX_RULE_ID = T.SIM_TAX_RULE_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (T.SIM_TAX_RULE_ID, T.LANGUAGE) in
(select SUBT.SIM_TAX_RULE_ID,
SUBT.LANGUAGE
from ZX_SIM_RULES_TL SUBB, ZX_SIM_RULES_TL SUBT
where SUBB.SIM_TAX_RULE_ID = SUBT.SIM_TAX_RULE_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.TAX_RULE_NAME <> SUBT.TAX_RULE_NAME
));
insert into ZX_SIM_RULES_TL (
SIM_TAX_RULE_ID,
TAX_RULE_NAME,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LANGUAGE,
SOURCE_LANG)
select
B.SIM_TAX_RULE_ID,
B.TAX_RULE_NAME,
B.CREATION_DATE,
B.CREATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_LOGIN,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from ZX_SIM_RULES_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select NULL
from ZX_SIM_RULES_TL T
where T.SIM_TAX_RULE_ID = B.SIM_TAX_RULE_ID
and T.LANGUAGE = L.LANGUAGE_CODE);