[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ext_data_elmt_id
FROM ben_ext_data_elmt
WHERE (p_business_group_id is null
or p_business_group_id = business_group_id )
and name = (SELECT fix_name_length(p_new_extract_name||' '||name
,c_ExtName_Maxlen)
FROM ben_ext_data_elmt
WHERE ext_data_elmt_id = p_curr_data_elmt_id);
SELECT ext_data_elmt_in_rcd_id
FROM ben_ext_data_elmt_in_rcd
WHERE ext_rcd_id = p_new_ext_rcd_id
AND ext_data_elmt_id = (SELECT ext_data_elmt_id
FROM ben_ext_data_elmt
WHERE (p_business_group_id is null or
p_business_group_id = business_group_id )
and name =
(SELECT fix_name_length(p_new_extract_name||' '||De.name
,c_ExtName_Maxlen)
FROM ben_ext_data_elmt De
,ben_ext_data_elmt_in_rcd DinR
WHERE DinR.ext_data_elmt_in_rcd_id = p_curr_cond_DinR_id
AND DinR.ext_data_elmt_id = De.ext_data_elmt_id
)
);
SELECT ext_data_elmt_in_rcd_id
FROM ben_ext_data_elmt_in_rcd
WHERE ext_rcd_id = (SELECT ext_rcd_id
FROM ben_ext_rcd_in_file
WHERE ext_rcd_in_file_id = p_new_rcd_in_file_id
)
AND ext_data_elmt_id = (SELECT ext_data_elmt_id
FROM ben_ext_data_elmt
WHERE name =
(SELECT fix_name_length(p_new_extract_name||' '||De.name
,c_ExtName_Maxlen)
FROM ben_ext_data_elmt De
,ben_ext_data_elmt_in_rcd DinR
WHERE DinR.ext_data_elmt_in_rcd_id = p_curr_cond_DinR_id
AND DinR.ext_data_elmt_id = De.ext_data_elmt_id
)
);
SELECT ext_rcd_id
FROM ben_ext_rcd
WHERE (p_business_group_id is null
or p_business_group_id = business_group_id)
and name = (SELECT fix_name_length(p_new_extract_name||' '||name
,c_ExtName_Maxlen)
FROM ben_ext_rcd
WHERE ext_rcd_id = p_curr_rcd_id);
SELECT formula_id
FROM ff_formulas_f
WHERE formula_name = p_new_formula_name
AND business_group_id = p_business_group_id
AND legislation_code IS NULL;
SELECT *
FROM ff_formulas_f
WHERE formula_id = p_curr_formula_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
l_new_last_update_date DATE;
l_new_last_update_date := r_curr_formula.last_update_date;
BEGIN -- Insert into FF_FORMULAS_F using Row Handler
ff_formulas_f_pkg.insert_Row(
X_Rowid => l_new_row_id -- IN OUT
,X_Formula_Id => l_new_formula_id -- IN OUT
,X_Effective_Start_Date => r_curr_formula.effective_start_date
,X_Effective_End_Date => r_curr_formula.effective_end_date
,X_Business_Group_Id => p_business_group_id
,X_Legislation_Code => NULL
,X_Formula_Type_Id => r_curr_formula.formula_type_id
,X_Formula_Name => l_new_formula_name -- IN OUT
,X_Description => r_curr_formula.description
,X_Formula_Text => r_curr_formula.formula_text
,X_Sticky_Flag => r_curr_formula.sticky_Flag
,X_Last_Update_Date => l_new_last_update_date -- IN OUT
);
END; -- Insert into FF_FORMULAS_F using Row Handler
SELECT *
FROM ben_ext_crit_prfl
WHERE ext_crit_prfl_id = p_ext_crit_prfl_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT *
FROM ben_ext_crit_typ
WHERE ext_crit_prfl_id = p_ext_crit_prfl_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT *
FROM ben_ext_crit_val
WHERE ext_crit_typ_id = p_ext_crit_typ_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT *
FROM ben_ext_crit_cmbn
WHERE ext_crit_val_id = p_ext_crit_val_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT *
FROM ben_ext_file
WHERE ext_file_id = p_ext_file_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT RinF.*
FROM ben_ext_rcd_in_file RinF, ben_ext_rcd Rcd
WHERE RinF.ext_file_id = p_ext_file_id
AND RinF.ext_rcd_id = Rcd.ext_rcd_id
AND ((RinF.business_group_id IS NULL AND RinF.legislation_code IS NULL)
OR (RinF.legislation_code IS NOT NULL
AND RinF.legislation_code = p_legislation_code)
OR (RinF.business_group_id IS NOT NULL
AND RinF.business_group_id = p_business_group_id)
)
ORDER BY decode(Rcd.rcd_type_cd,'D',1,'H',2,'T',3)
,RinF.seq_num;
SELECT *
FROM ben_ext_rcd
WHERE ext_rcd_id = p_ext_rcd_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT *
FROM ben_ext_where_clause
WHERE ext_rcd_in_file_id = p_ext_rcd_in_file_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT * from ben_ext_incl_chg
WHERE ext_rcd_in_file_id = p_ext_rcd_in_file_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT DinR.*
FROM ben_ext_data_elmt_in_rcd DinR, ben_ext_data_elmt DElmt
WHERE DinR.ext_rcd_id = p_ext_rcd_id
AND Dinr.ext_data_elmt_id = DElmt.ext_data_elmt_id
AND ((DinR.business_group_id IS NULL AND DinR.legislation_code IS NULL)
OR (DinR.legislation_code IS NOT NULL
AND DinR.legislation_code = p_legislation_code)
OR (DinR.business_group_id IS NOT NULL
AND DinR.business_group_id = p_business_group_id)
)
ORDER BY decode(DElmt.data_elmt_typ_cd,'T',1,'C',2,0), DinR.seq_num;
SELECT *
FROM ben_ext_data_elmt
WHERE ext_data_elmt_id = p_ext_data_elmt_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT *
FROM ben_ext_data_elmt_decd
WHERE ext_data_elmt_id = p_ext_data_elmt_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT *
FROM ben_ext_where_clause
WHERE ext_data_elmt_id = p_ext_data_elmt_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT *
FROM ben_ext_where_clause
WHERE ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
SELECT * from ben_ext_incl_chg
WHERE ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);
BEGIN -- Insert into BEN_EXT_RCD using Row Handler
l_rcd_present := FALSE;
END; -- Insert into BEN_EXT_RCD using Row Handler
BEGIN -- Insert new record in BEN_EXT_DATA_ELMT with New Extract Name Prefixed
l_data_elmt_present := FALSE;
END; -- Insert into BEN_EXT_DATA_ELMT using Row Handler
-- Insert into BEN_EXT_WHERE_CLAUSE using Row Handler
ben_xwc_ins.ins
(
p_ext_where_clause_id => l_new_DinR_where_clause_id -- OUT
,p_seq_num => r_curr_DinR_where_clause.seq_num
,p_oper_cd => r_curr_DinR_where_clause.oper_cd
,p_val => r_curr_DinR_where_clause.val
,p_and_or_cd => r_curr_DinR_where_clause.and_or_cd
,p_ext_data_elmt_id => NULL -- p_ext_data_elmt_id
,p_cond_ext_data_elmt_id => l_new_cond_ext_data_elmt_id
,p_ext_rcd_in_file_id => NULL -- p_ext_rcd_in_file_id
,p_ext_data_elmt_in_rcd_id => r_DinRId.new_Id
,p_business_group_id => p_business_group_id
,p_legislation_code => NULL
,p_object_version_number => l_new_object_version_number -- OUT
,p_cond_ext_data_elmt_in_rcd_id => l_new_cond_data_elmt_in_rcd_id
,p_effective_date => trunc(p_effective_date)
);
SELECT *
FROM ben_ext_dfn
WHERE ext_dfn_id = p_extract_dfn_id
AND ((business_group_id IS NULL AND legislation_code IS NULL)
OR (legislation_code IS NOT NULL
AND legislation_code = p_legislation_code)
OR (business_group_id IS NOT NULL
AND business_group_id = p_business_group_id)
);