APPS.HRWSECI dependencies on PER_COBRA_COV_STATUSES_PKG

Line 744: per_cobra_cov_statuses_pkg.insert_row(l_dummy_rowid,

740: --
741: --
742: -- Insert Awaiting Notification Status
743: --
744: per_cobra_cov_statuses_pkg.insert_row(l_dummy_rowid,
745: l_Cobra_Coverage_Status_Id,
746: p_Business_Group_Id,
747: p_Cobra_Coverage_Enrollment_Id,
748: 'AWAIT',

Line 1471: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique

1467: --
1468: --
1469: -- Call to check status is unique
1470: --
1471: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique
1472: ( p_business_group_id,
1473: p_cobra_coverage_status_id,
1474: p_cobra_coverage_enrollment_id,
1475: p_cobra_coverage_status_type );

Line 1484: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej

1480: -- Call to check elect/rej not co-existing
1481: --
1482: IF (p_cobra_coverage_status_type IN ('ELEC', 'REJ'))
1483: THEN
1484: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej
1485: ( p_business_group_id,
1486: p_cobra_coverage_enrollment_id,
1487: p_cobra_coverage_status_id,
1488: p_cobra_coverage_status_type );

Line 1496: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order

1492: --
1493: --
1494: -- Call to check status inserted in correct order
1495: --
1496: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order
1497: ( p_business_group_id,
1498: p_cobra_coverage_enrollment_id,
1499: p_cobra_coverage_status_id,
1500: p_cobra_coverage_status_type,

Line 1508: per_cobra_cov_statuses_pkg.insert_row

1504: --
1505: --
1506: -- do insert
1507: --
1508: per_cobra_cov_statuses_pkg.insert_row
1509: ( p_Rowid,
1510: p_Cobra_Coverage_Status_Id,
1511: p_Business_Group_Id,
1512: p_Cobra_Coverage_Enrollment_Id,

Line 1610: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique

1606: hr_utility.set_location('hrwseci.hr_cobra_do_ccs_update', 1);
1607: --
1608: -- Call to check status is unique
1609: --
1610: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique
1611: ( p_business_group_id,
1612: p_cobra_coverage_status_id,
1613: p_cobra_coverage_enrollment_id,
1614: p_cobra_coverage_status_type );

Line 1626: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej (

1622: IF( p_cobra_coverage_status_type IN ('ELEC', 'REJ'))
1623: THEN
1624: --
1625: hr_utility.set_location('hrwseci.hr_cobra_chk_do_ccs_update', 4);
1626: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej (
1627: p_business_group_id,
1628: p_cobra_coverage_enrollment_id,
1629: p_cobra_coverage_status_id,
1630: p_cobra_coverage_status_type );

Line 1638: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order(

1634: --
1635: --
1636: -- check status order
1637: --
1638: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order(
1639: p_business_group_id,
1640: p_cobra_coverage_enrollment_id,
1641: p_cobra_coverage_status_id,
1642: p_cobra_coverage_status_type,

Line 1651: per_cobra_cov_statuses_pkg.update_row(p_rowid,

1647: --
1648: --
1649: hr_utility.set_location('hrwseci.hr_cobra_chk_do_ccs_update', 5);
1650: --
1651: per_cobra_cov_statuses_pkg.update_row(p_rowid,
1652: p_Business_Group_Id,
1653: p_Cobra_Coverage_Enrollment_Id,
1654: p_Cobra_Coverage_Status_Type,
1655: p_Effective_Date,

Line 1734: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique

1730: --
1731: --
1732: -- Call to check status is unique
1733: --
1734: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_unique
1735: ( p_business_group_id,
1736: NULL,
1737: p_cobra_coverage_enrollment_id,
1738: p_status );

Line 1747: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej

1743: -- Call to check elect/rej not co-existing
1744: --
1745: IF (p_status IN ('ELEC', 'REJ'))
1746: THEN
1747: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_elect_rej
1748: ( p_business_group_id,
1749: p_cobra_coverage_enrollment_id,
1750: NULL,
1751: p_status );

Line 1759: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order

1755: --
1756: --
1757: -- Call to check status inserted in correct order
1758: --
1759: per_cobra_cov_statuses_pkg.hr_cobra_chk_status_order
1760: ( p_business_group_id,
1761: p_cobra_coverage_enrollment_id,
1762: NULL,
1763: p_status,

Line 1771: per_cobra_cov_statuses_pkg.insert_row

1767: --
1768: --
1769: -- do insert
1770: --
1771: per_cobra_cov_statuses_pkg.insert_row
1772: ( p_dummy_rowid,
1773: p_dummy_Id,
1774: p_Business_Group_Id,
1775: p_Cobra_Coverage_Enrollment_Id,

Line 1841: per_cobra_cov_statuses_pkg.Delete_Row( p_rowid );

1837: BEGIN
1838: --
1839: -- delete row
1840: --
1841: per_cobra_cov_statuses_pkg.Delete_Row( p_rowid );
1842: --
1843: -- get current status
1844: --
1845: hr_cobra_get_current_status ( p_cobra_coverage_enrollment_id,