[Home] [Help]
138: -- Desciption :
139: --
140: -- Validates that JOB_ID is not null
141: --
142: -- Validates that values entered for this column exist in the PER_JOBS
143: -- table.
144: --
145: -- Validates that PER_POSITIONS.DATE_EFFECTIVE cannot be less than the
146: -- DATE_FROM value for the JOB record on PER_JOBS.
142: -- Validates that values entered for this column exist in the PER_JOBS
143: -- table.
144: --
145: -- Validates that PER_POSITIONS.DATE_EFFECTIVE cannot be less than the
146: -- DATE_FROM value for the JOB record on PER_JOBS.
147: --
148: -- Pre-conditions :
149: -- Format for p_date_effective must be correct
150: --
152: -- p_job_id
153: -- p_date_effective
154: --
155: -- Post Success :
156: -- If a row exists in per_jobs for the job id and the date conditions
157: -- are met, processing continues
158: --
159: -- Post Failure :
160: -- If a row does not exist in per_jobs for the job id or if date conditions
156: -- If a row exists in per_jobs for the job id and the date conditions
157: -- are met, processing continues
158: --
159: -- Post Failure :
160: -- If a row does not exist in per_jobs for the job id or if date conditions
161: -- are not met, an application error will be raised and processing is
162: -- terminated
163: --
164: -- Access Status :
177: l_proc varchar2(72) := g_package||'chk_job_id';
178: --
179: cursor csr_valid_job_id is
180: select 'x'
181: from per_jobs job
182: where job.job_id = p_job_id
183: and job.business_group_id + 0 = p_business_group_id;
184: --
185: cursor csr_valid_job_dates is
183: and job.business_group_id + 0 = p_business_group_id;
184: --
185: cursor csr_valid_job_dates is
186: select 'x'
187: from per_jobs job
188: where job.job_id = p_job_id
189: and p_date_effective between job.date_from
190: and nvl(job.date_to,hr_api.g_eot);
191: --