APPS.PER_COBRA_ECI dependencies on PER_COBRA_COV_STATUSES_PKG

Line 795: per_cobra_cov_statuses_pkg.insert_row(l_dummy_rowid,

791: --
792: --
793: -- Insert Awaiting Notification Status
794: --
795: per_cobra_cov_statuses_pkg.insert_row(l_dummy_rowid,
796: l_Cobra_Coverage_Status_Id,
797: p_Business_Group_Id,
798: p_Cobra_Coverage_Enrollment_Id,
799: 'AWAIT',

Line 1961: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique

1957: --
1958: --
1959: -- Call to check status is unique
1960: --
1961: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique
1962: ( p_business_group_id,
1963: p_cobra_coverage_status_id,
1964: p_cobra_coverage_enrollment_id,
1965: p_cobra_coverage_status_type );

Line 1975: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej

1971: --
1972: hr_utility.trace('p_cobra_coverage_status_type = ' || p_cobra_coverage_status_type);
1973: IF (p_cobra_coverage_status_type IN ('ELEC', 'REJ'))
1974: THEN
1975: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej
1976: ( p_business_group_id,
1977: p_cobra_coverage_enrollment_id,
1978: p_cobra_coverage_status_id,
1979: p_cobra_coverage_status_type );

Line 1987: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order

1983: --
1984: --
1985: -- Call to check status inserted in correct order
1986: --
1987: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order
1988: ( p_business_group_id,
1989: p_cobra_coverage_enrollment_id,
1990: p_cobra_coverage_status_id,
1991: p_cobra_coverage_status_type,

Line 1999: per_cobra_cov_statuses_pkg.insert_row

1995: --
1996: --
1997: -- do insert
1998: --
1999: per_cobra_cov_statuses_pkg.insert_row
2000: ( p_Rowid,
2001: p_Cobra_Coverage_Status_Id,
2002: p_Business_Group_Id,
2003: p_Cobra_Coverage_Enrollment_Id,

Line 2103: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique

2099: hr_utility.set_location(l_package, 1);
2100: --
2101: -- Call to check status is unique
2102: --
2103: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique
2104: ( p_business_group_id,
2105: p_cobra_coverage_status_id,
2106: p_cobra_coverage_enrollment_id,
2107: p_cobra_coverage_status_type );

Line 2119: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej (

2115: IF( p_cobra_coverage_status_type IN ('ELEC', 'REJ'))
2116: THEN
2117: --
2118: hr_utility.set_location(l_package, 3);
2119: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej (
2120: p_business_group_id,
2121: p_cobra_coverage_enrollment_id,
2122: p_cobra_coverage_status_id,
2123: p_cobra_coverage_status_type );

Line 2131: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order(

2127: --
2128: --
2129: -- check status order
2130: --
2131: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order(
2132: p_business_group_id,
2133: p_cobra_coverage_enrollment_id,
2134: p_cobra_coverage_status_id,
2135: p_cobra_coverage_status_type,

Line 2144: per_cobra_cov_statuses_pkg.update_row(p_rowid,

2140: --
2141: --
2142: hr_utility.set_location(l_package, 5);
2143: --
2144: per_cobra_cov_statuses_pkg.update_row(p_rowid,
2145: p_Business_Group_Id,
2146: p_Cobra_Coverage_Enrollment_Id,
2147: p_Cobra_Coverage_Status_Type,
2148: p_Effective_Date,

Line 2337: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique

2333: --
2334: --
2335: -- Call to check status is unique
2336: --
2337: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique
2338: ( p_business_group_id,
2339: NULL,
2340: p_cobra_coverage_enrollment_id,
2341: p_status );

Line 2350: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej

2346: -- Call to check elect/rej not co-existing
2347: --
2348: IF (p_status IN ('ELEC', 'REJ'))
2349: THEN
2350: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej
2351: ( p_business_group_id,
2352: p_cobra_coverage_enrollment_id,
2353: NULL,
2354: p_status );

Line 2362: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order

2358: --
2359: --
2360: -- Call to check status inserted in correct order
2361: --
2362: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order
2363: ( p_business_group_id,
2364: p_cobra_coverage_enrollment_id,
2365: NULL,
2366: p_status,

Line 2374: per_cobra_cov_statuses_pkg.insert_row

2370: --
2371: --
2372: -- do insert
2373: --
2374: per_cobra_cov_statuses_pkg.insert_row
2375: ( p_dummy_rowid,
2376: p_dummy_Id,
2377: p_Business_Group_Id,
2378: p_Cobra_Coverage_Enrollment_Id,

Line 2460: per_cobra_cov_statuses_pkg.Delete_Row( p_rowid );

2456: BEGIN
2457: --
2458: -- delete row
2459: --
2460: per_cobra_cov_statuses_pkg.Delete_Row( p_rowid );
2461: --
2462: -- get current status
2463: --
2464: hr_cobra_get_current_status ( p_cobra_coverage_enrollment_id,