1523: ,p_object_version_number out nocopy number
1524: ,p_effective_date in date
1525: ) is
1526:
1527: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
1528: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1529: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1530: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1531:
1524: ,p_effective_date in date
1525: ) is
1526:
1527: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
1528: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1529: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1530: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1531:
1532: begin
1525: ) is
1526:
1527: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
1528: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1529: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1530: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1531:
1532: begin
1533:
1526:
1527: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
1528: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1529: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1530: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1531:
1532: begin
1533:
1534: ben_ELIG_OBJ_ELIG_PROFL_api.create_ELIG_OBJ_ELIG_PROFL
1590: ,p_effective_date in date
1591: ,p_datetrack_mode in varchar2
1592: ) is
1593:
1594: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1595: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1596: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1597:
1598: begin
1591: ,p_datetrack_mode in varchar2
1592: ) is
1593:
1594: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1595: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1596: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1597:
1598: begin
1599:
1592: ) is
1593:
1594: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1595: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1596: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1597:
1598: begin
1599:
1600: l_object_version_number := p_object_version_number;
1654: ,p_effective_date in date
1655: ,p_datetrack_mode in varchar2
1656: ) is
1657:
1658: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1659: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1660: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1661:
1662: begin
1655: ,p_datetrack_mode in varchar2
1656: ) is
1657:
1658: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1659: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1660: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1661:
1662: begin
1663:
1656: ) is
1657:
1658: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
1659: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
1660: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
1661:
1662: begin
1663:
1664: l_object_version_number := p_object_version_number;