APPS.PER_COBRA_COV_BENEFITS_PKG dependencies on PER_COBRA_COVERAGE_BENEFITS_F

Line 37: CURSOR C IS SELECT rowid FROM PER_COBRA_COVERAGE_BENEFITS_F

33: X_Attribute18 VARCHAR2,
34: X_Attribute19 VARCHAR2,
35: X_Attribute20 VARCHAR2
36: ) IS
37: CURSOR C IS SELECT rowid FROM PER_COBRA_COVERAGE_BENEFITS_F
38:
39: WHERE cobra_coverage_benefit_id = X_Cobra_Coverage_Benefit_Id;
40:
41:

Line 53: INSERT INTO PER_COBRA_COVERAGE_BENEFITS_F(

49: OPEN C2;
50: FETCH C2 INTO X_Cobra_Coverage_Benefit_Id;
51: CLOSE C2;
52: end if;
53: INSERT INTO PER_COBRA_COVERAGE_BENEFITS_F(
54: cobra_coverage_benefit_id,
55: effective_start_date,
56: effective_end_date,
57: business_group_id,

Line 160: FROM PER_COBRA_COVERAGE_BENEFITS_F

156: X_Attribute20 VARCHAR2
157: ) IS
158: CURSOR C IS
159: SELECT *
160: FROM PER_COBRA_COVERAGE_BENEFITS_F
161: WHERE rowid = X_Rowid
162: FOR UPDATE of Cobra_Coverage_Benefit_Id NOWAIT;
163: Recinfo C%ROWTYPE;
164: BEGIN

Line 340: UPDATE PER_COBRA_COVERAGE_BENEFITS_F

336: X_Attribute19 VARCHAR2,
337: X_Attribute20 VARCHAR2
338: ) IS
339: BEGIN
340: UPDATE PER_COBRA_COVERAGE_BENEFITS_F
341: SET
342: cobra_coverage_benefit_id = X_Cobra_Coverage_Benefit_Id,
343: effective_start_date = X_Effective_Start_Date,
344: effective_end_date = X_Effective_End_Date,

Line 382: DELETE FROM PER_COBRA_COVERAGE_BENEFITS_F

378: END Update_Row;
379:
380: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
381: BEGIN
382: DELETE FROM PER_COBRA_COVERAGE_BENEFITS_F
383: WHERE rowid = X_Rowid;
384:
385: if (SQL%NOTFOUND) then
386: RAISE NO_DATA_FOUND;