APPS.PER_COBRA_COV_ENROLLMENTS_PKG dependencies on PER_COBRA_COV_ENROLLMENTS

Line 1: PACKAGE BODY PER_COBRA_COV_ENROLLMENTS_PKG as

1: PACKAGE BODY PER_COBRA_COV_ENROLLMENTS_PKG as
2: /* $Header: pecobcce.pkb 120.0 2006/04/18 18:14:28 ssouresr noship $ */
3: --
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Cobra_Coverage_Enrollment_Id IN OUT NOCOPY NUMBER,

Line 39: CURSOR C IS SELECT rowid FROM per_cobra_cov_enrollments

35: X_Attribute20 VARCHAR2,
36: X_Grace_Days NUMBER,
37: X_Comments VARCHAR2
38: ) IS
39: CURSOR C IS SELECT rowid FROM per_cobra_cov_enrollments
40: WHERE cobra_coverage_enrollment_id = X_Cobra_Coverage_Enrollment_Id;
41: --
42: --
43: --

Line 46: CURSOR C2 IS SELECT per_cobra_cov_enrollments_s.nextval FROM sys.dual;

42: --
43: --
44: --
45: --
46: CURSOR C2 IS SELECT per_cobra_cov_enrollments_s.nextval FROM sys.dual;
47: BEGIN
48: --
49: hr_utility.set_location('cce insert_row', 0);
50: --

Line 57: INSERT INTO per_cobra_cov_enrollments(

53: FETCH C2 INTO X_Cobra_Coverage_Enrollment_Id;
54: CLOSE C2;
55: end if;
56: --
57: INSERT INTO per_cobra_cov_enrollments(
58: cobra_coverage_enrollment_id,
59: business_group_id,
60: assignment_id,
61: period_type,

Line 172: FROM per_cobra_cov_enrollments

168: X_Grace_Days NUMBER,
169: X_Comments VARCHAR2) IS
170: CURSOR C IS
171: SELECT *
172: FROM per_cobra_cov_enrollments
173: WHERE rowid = X_Rowid
174: FOR UPDATE of COBRA_COVERAGE_ENROLLMENT_ID NOWAIT;
175: /* FOR UPDATE of COBRA_COVERAGE_ENROLLMENT_ID NOWAIT; */
176: Recinfo C%ROWTYPE;

Line 365: UPDATE per_cobra_cov_enrollments

361: BEGIN
362: --
363: hr_utility.set_location('cce update_row', 0);
364: --
365: UPDATE per_cobra_cov_enrollments
366: SET
367: business_group_id = X_Business_Group_Id,
368: assignment_id = X_Assignment_Id,
369: period_type = X_Period_Type,

Line 412: DELETE FROM per_cobra_cov_enrollments

408: BEGIN
409: --
410: hr_utility.set_location('cce delete_row', 0);
411: --
412: DELETE FROM per_cobra_cov_enrollments
413: WHERE rowid = X_Rowid;
414: --
415: if (SQL%NOTFOUND) then
416: RAISE NO_DATA_FOUND;

Line 455: FROM per_cobra_cov_enrollments cce

451: -- declare cursors
452: --
453: CURSOR employee_coverage IS
454: SELECT 'E'
455: FROM per_cobra_cov_enrollments cce
456: WHERE ( cce.cobra_coverage_enrollment_id <> p_cobra_coverage_enrollment_id
457: OR p_cobra_coverage_enrollment_id IS NULL)
458: AND cce.assignment_id = p_assignment_id
459: AND cce.qualifying_date = p_qualifying_date

Line 465: FROM per_cobra_cov_enrollments cce

461: AND cce.contact_relationship_id IS NULL;
462: --
463: CURSOR contact_coverage IS
464: SELECT 'C'
465: FROM per_cobra_cov_enrollments cce
466: WHERE ( cce.cobra_coverage_enrollment_id <> p_cobra_coverage_enrollment_id
467: OR p_cobra_coverage_enrollment_id IS NULL)
468: AND cce.contact_relationship_id = p_contact_relationship_id
469: AND cce.qualifying_date = p_qualifying_date

Line 542: END PER_COBRA_COV_ENROLLMENTS_PKG;

538: END hr_cobra_chk_unique_enrollment;
539: --
540: --
541: --
542: END PER_COBRA_COV_ENROLLMENTS_PKG;