DBA Data[Home] [Help]

APPS.PER_JOB_GROUP_API dependencies on PER_JOB_GROUPS

Line 29: l_job_group_id PER_JOB_GROUPS.JOB_GROUP_ID%TYPE;

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);

Line 30: l_object_version_number PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE;

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: --

Line 160: l_job_group_id PER_JOB_GROUPS.JOB_GROUP_ID%TYPE;

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

Line 161: l_object_version_number PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE;

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);

Line 162: l_ovn PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;

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: --