25: -- Declare cursors and local variables
26: --
27: l_proc varchar2(72) := g_package||'CREATE_JOB_GROUP';
28: l_effective_date date;
29: l_job_group_id PER_JOB_GROUPS.JOB_GROUP_ID%TYPE;
30: l_object_version_number PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
31: --
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
26: --
27: l_proc varchar2(72) := g_package||'CREATE_JOB_GROUP';
28: l_effective_date date;
29: l_job_group_id PER_JOB_GROUPS.JOB_GROUP_ID%TYPE;
30: l_object_version_number PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
31: --
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
156: -- Declare cursors and local variables
157: --
158: l_proc varchar2(72) := g_package||'UPDATE_JOB_GROUP';
159: l_effective_date date;
160: l_job_group_id PER_JOB_GROUPS.JOB_GROUP_ID%TYPE;
161: l_object_version_number PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
162: l_ovn PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;
163: --
164: begin
157: --
158: l_proc varchar2(72) := g_package||'UPDATE_JOB_GROUP';
159: l_effective_date date;
160: l_job_group_id PER_JOB_GROUPS.JOB_GROUP_ID%TYPE;
161: l_object_version_number PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
162: l_ovn PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;
163: --
164: begin
165: hr_utility.set_location('Entering:'|| l_proc, 10);
158: l_proc varchar2(72) := g_package||'UPDATE_JOB_GROUP';
159: l_effective_date date;
160: l_job_group_id PER_JOB_GROUPS.JOB_GROUP_ID%TYPE;
161: l_object_version_number PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
162: l_ovn PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;
163: --
164: begin
165: hr_utility.set_location('Entering:'|| l_proc, 10);
166: --