1996: ,p_effective_date in date
1997: ,p_datetrack_mode in varchar2
1998: ) is
1999:
2000: l_object_version_number ben_elig_org_unit_prte_f.object_version_number%TYPE;
2001: l_effective_start_date ben_elig_org_unit_prte_f.effective_start_date%TYPE;
2002: l_effective_end_date ben_elig_org_unit_prte_f.effective_end_date%TYPE;
2003:
2004: begin
1997: ,p_datetrack_mode in varchar2
1998: ) is
1999:
2000: l_object_version_number ben_elig_org_unit_prte_f.object_version_number%TYPE;
2001: l_effective_start_date ben_elig_org_unit_prte_f.effective_start_date%TYPE;
2002: l_effective_end_date ben_elig_org_unit_prte_f.effective_end_date%TYPE;
2003:
2004: begin
2005:
1998: ) is
1999:
2000: l_object_version_number ben_elig_org_unit_prte_f.object_version_number%TYPE;
2001: l_effective_start_date ben_elig_org_unit_prte_f.effective_start_date%TYPE;
2002: l_effective_end_date ben_elig_org_unit_prte_f.effective_end_date%TYPE;
2003:
2004: begin
2005:
2006: l_object_version_number := p_object_version_number;
2065: ,p_datetrack_mode in varchar2
2066: ) is
2067:
2068:
2069: l_object_version_number ben_elig_org_unit_prte_f.object_version_number%TYPE;
2070: l_effective_start_date ben_elig_org_unit_prte_f.effective_start_date%TYPE;
2071: l_effective_end_date ben_elig_org_unit_prte_f.effective_end_date%TYPE;
2072:
2073: begin
2066: ) is
2067:
2068:
2069: l_object_version_number ben_elig_org_unit_prte_f.object_version_number%TYPE;
2070: l_effective_start_date ben_elig_org_unit_prte_f.effective_start_date%TYPE;
2071: l_effective_end_date ben_elig_org_unit_prte_f.effective_end_date%TYPE;
2072:
2073: begin
2074:
2067:
2068:
2069: l_object_version_number ben_elig_org_unit_prte_f.object_version_number%TYPE;
2070: l_effective_start_date ben_elig_org_unit_prte_f.effective_start_date%TYPE;
2071: l_effective_end_date ben_elig_org_unit_prte_f.effective_end_date%TYPE;
2072:
2073: begin
2074:
2075: l_object_version_number := p_object_version_number;