DBA Data[Home] [Help]

APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_FORMULA_RESULT_RULES_PKG

Line 840: pay_formula_result_rules_pkg.insert_row

836: SELECT pay_formula_result_rules_s.nextval
837: INTO l_formula_result_rule_id
838: FROM dual;
839:
840: pay_formula_result_rules_pkg.insert_row
841: (p_rowid => l_rowid
842: ,p_formula_result_rule_id => l_formula_result_rule_id
843: ,p_effective_start_date => p_scheme_start_date
844: ,p_effective_end_date => p_scheme_end_date

Line 2163: pay_formula_result_rules_pkg.delete_row(p_rowid => temp_rec.rowid);

2159: -- objects
2160: --
2161: FOR temp_rec IN c_formula_rules (p_pension_dedn_ele_type_id)
2162: LOOP
2163: pay_formula_result_rules_pkg.delete_row(p_rowid => temp_rec.rowid);
2164: END LOOP;
2165:
2166: IF l_er_dedn_ele_type_id <> -1 THEN
2167: FOR temp_rec IN c_formula_rules (l_er_dedn_ele_type_id)

Line 2169: pay_formula_result_rules_pkg.delete_row(p_rowid => temp_rec.rowid);

2165:
2166: IF l_er_dedn_ele_type_id <> -1 THEN
2167: FOR temp_rec IN c_formula_rules (l_er_dedn_ele_type_id)
2168: LOOP
2169: pay_formula_result_rules_pkg.delete_row(p_rowid => temp_rec.rowid);
2170: END LOOP;
2171: END IF;
2172:
2173: --