[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT formula_name
,formula_text
FROM pay_shadow_formulas
WHERE template_type='T'
AND formula_name like p_formula_cat;
SELECT fff.formula_id
,fff.effective_start_date
,fff.effective_end_date
,fff.formula_type_id
,fff.formula_name
,fff.business_group_id
,fff.description
,fff.sticky_flag
,fff.compile_flag
,paf.status_processing_rule_id status_processing_rule_id
,fff.formula_text
,fff.legislation_code
FROM ff_formulas_f fff
,PAY_STATUS_PROCESSING_RULES_F paf
WHERE fff.formula_name like NVL(p_formula_name,p_formula_cat)
AND fff.formula_id=paf.formula_id
AND paf.assignment_status_type_id IS NULL
AND fff.business_group_id=paf.business_group_id
AND fff.business_group_id=fnd_global.per_business_group_id
AND SYSDATE BETWEEN fff.effective_start_date and fff.effective_end_date
ORDER BY fff.formula_id,fff.effective_start_date ;
SELECT TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
INTO l_year
FROM DUAL;
UPDATE ff_formulas_f
SET formula_name = l_formula.formula_name||'_'||l_year||'_BAK'
WHERE formula_id = l_formula.formula_id;
UPDATE ff_formulas_f_tl
SET formula_name = l_formula.formula_name||'_'||l_year||'_BAK'
WHERE formula_id = l_formula.formula_id;
INSERT INTO ff_formulas_f(
FORMULA_ID
,EFFECTIVE_START_DATE
,EFFECTIVE_END_DATE
,BUSINESS_GROUP_ID
,LEGISLATION_CODE
,FORMULA_TYPE_ID
,FORMULA_NAME
,DESCRIPTION
,FORMULA_TEXT
,STICKY_FLAG
,COMPILE_FLAG
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE )
VALUES(
ff_formulas_s.nextval
,l_formula.EFFECTIVE_START_DATE
,l_formula.EFFECTIVE_end_DATE
,l_formula.business_group_id
,l_formula.legislation_code
,l_formula.formula_type_id
,l_formula.formula_name
,l_formula.description
,l_formula_text_buffer
,l_formula.sticky_flag
,l_formula.compile_flag
,sysdate
,1
,1
,1
,sysdate
);
UPDATE pay_status_processing_rules_f
SET formula_id=ff_formulas_s.currval
WHERE status_processing_rule_id=l_formula.status_processing_rule_id
AND SYSDATE BETWEEN effective_start_date and effective_end_date;