APPS.BEN_BENEFICIARIES_PKG dependencies on BEN_BENEFICIARIES_F

Line 17: SELECT rowid FROM ben_beneficiaries_f

13: P_Benefit_Level VARCHAR2,
14: P_Proportion NUMBER ) IS
15: --
16: CURSOR C IS
17: SELECT rowid FROM ben_beneficiaries_f
18: WHERE beneficiary_id = P_Beneficiary_Id
19: AND element_entry_id = P_Element_Entry_Id;
20: --
21: CURSOR C2 IS

Line 37: INSERT INTO ben_beneficiaries_f(

33: CLOSE C2;
34: end if;
35: --
36: --
37: INSERT INTO ben_beneficiaries_f(
38: beneficiary_id,
39: source_type,
40: source_id,
41: element_entry_id,

Line 89: FROM ben_beneficiaries_f

85: P_Proportion NUMBER
86: ) IS
87: CURSOR C IS
88: SELECT *
89: FROM ben_beneficiaries_f
90: WHERE rowid = P_Rowid
91: FOR UPDATE of Beneficiary_Id NOWAIT;
92: --
93: Recinfo C%ROWTYPE;

Line 163: UPDATE ben_beneficiaries_f

159: P_Proportion NUMBER
160: ) IS
161: BEGIN
162: --
163: UPDATE ben_beneficiaries_f
164: SET
165: beneficiary_id = P_Beneficiary_Id,
166: source_type = P_Source_Type,
167: source_id = P_Source_Id,

Line 191: DELETE FROM ben_beneficiaries_f

187: ------------------------ Delete_Row ----------------------------
188:
189: PROCEDURE Delete_Row(P_Rowid VARCHAR2) IS
190: BEGIN
191: DELETE FROM ben_beneficiaries_f
192: WHERE rowid = P_Rowid;
193:
194: if (SQL%NOTFOUND) then
195: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');