APPS.PER_COBRA_COV_STATUSES_PKG dependencies on PER_COBRA_COVERAGE_STATUSES

Line 33: CURSOR C IS SELECT rowid FROM per_cobra_coverage_statuses

29: X_Attribute19 VARCHAR2,
30: X_Attribute20 VARCHAR2,
31: X_Comments VARCHAR2
32: ) IS
33: CURSOR C IS SELECT rowid FROM per_cobra_coverage_statuses
34: WHERE cobra_coverage_status_id = X_Cobra_Coverage_Status_Id;
35: --
36: --
37: --

Line 39: CURSOR C2 IS SELECT per_cobra_coverage_statuses_s.nextval FROM sys.dual;

35: --
36: --
37: --
38: --
39: CURSOR C2 IS SELECT per_cobra_coverage_statuses_s.nextval FROM sys.dual;
40: BEGIN
41: --
42: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',1);
43: --

Line 56: INSERT INTO per_cobra_coverage_statuses(

52: hr_utility.set_location('per_cobra_cov_statuses_pkg hr_ccs.insert_row',3);
53: -- hr_utility.trace(X_Cobra_Coverage_Status_Id);
54: --
55: --
56: INSERT INTO per_cobra_coverage_statuses(
57: cobra_coverage_status_id,
58: business_group_id,
59: cobra_coverage_enrollment_id,
60: cobra_coverage_status_type,

Line 160: FROM per_cobra_coverage_statuses

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

Line 327: UPDATE per_cobra_coverage_statuses

323: BEGIN
324: --
325: hr_utility.set_location('per_cobra_cov_statuses_pkg update_row ccs',0);
326: --
327: UPDATE per_cobra_coverage_statuses
328: SET
329: business_group_id = X_Business_Group_Id,
330: cobra_coverage_enrollment_id = X_Cobra_Coverage_Enrollment_Id,
331: cobra_coverage_status_type = X_Cobra_Coverage_Status_Type,

Line 370: DELETE FROM per_cobra_coverage_statuses

366: BEGIN
367: --
368: hr_utility.set_location('per_cobra_cov_statuses_pkg delete_row',0);
369: --
370: DELETE FROM per_cobra_coverage_statuses
371: WHERE rowid = X_Rowid;
372:
373: if (SQL%NOTFOUND) then
374: RAISE NO_DATA_FOUND;

Line 405: FROM per_cobra_coverage_statuses ccs

401: -- declare cursor
402: --
403: CURSOR status IS
404: SELECT 'Y'
405: FROM per_cobra_coverage_statuses ccs
406: WHERE ccs.business_group_id + 0 = p_business_group_id
407: AND ccs.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
408: AND ccs.cobra_coverage_status_type = p_cobra_coverage_status_type
409: AND ( ccs.cobra_coverage_status_id <> p_cobra_coverage_status_id

Line 477: FROM per_cobra_coverage_statuses ccs

473: -- declare cursors
474: --
475: CURSOR elect_or_reject_status IS
476: SELECT 'Y'
477: FROM per_cobra_coverage_statuses ccs
478: WHERE ccs.business_group_id + 0 = p_business_group_id
479: AND ccs.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
480: AND ( ccs.cobra_coverage_status_id <> p_cobra_coverage_status_id
481: OR p_cobra_coverage_status_id IS NULL )

Line 487: FROM per_cobra_coverage_statuses ccs

483: AND ccs.effective_date <= p_effective_date;
484: --
485: CURSOR notified_status IS
486: SELECT 'Y'
487: FROM per_cobra_coverage_statuses ccs
488: WHERE ccs.business_group_id + 0 = p_business_group_id
489: AND ccs.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
490: AND ( ccs.cobra_coverage_status_id <> p_cobra_coverage_status_id
491: OR p_cobra_coverage_status_id IS NULL )

Line 591: FROM per_cobra_coverage_statuses ccs

587: -- declare cursor
588: --
589: CURSOR elect_reject IS
590: SELECT 'N'
591: FROM per_cobra_coverage_statuses ccs
592: WHERE ccs.business_group_id + 0 = p_business_group_id
593: AND ccs.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
594: AND ccs.cobra_coverage_status_type IN ('ELEC', 'REJ')
595: AND ccs.cobra_coverage_status_type = DECODE(p_cobra_coverage_status_type,