166: where analysis_criteria_id = l_analysis_criteria_id;
167: --
168: begin
169: --
170: hr_utility.set_location('Entering:'|| l_proc, 5);
171: --
172: -- Issue a savepoint.
173: --
174: savepoint create_job_requirement;
179: (p_api_name => l_proc,
180: p_argument => 'job_id',
181: p_argument_value => p_job_id);
182: --
183: hr_utility.set_location(l_proc, 15);
184: --
185: open csr_job_bg;
186: fetch csr_job_bg
187: into l_business_group_id;
188: --
189: if csr_job_bg%notfound
190: then
191: close csr_job_bg;
192: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
193: hr_utility.raise_error;
194: else
195: close csr_job_bg;
196: end if;
189: if csr_job_bg%notfound
190: then
191: close csr_job_bg;
192: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
193: hr_utility.raise_error;
194: else
195: close csr_job_bg;
196: end if;
197: --
200: if l_analysis_criteria_id is not null
201: --
202: then
203: --
204: hr_utility.set_location(l_proc, 15);
205: --
206: -- set indicator to show p_criteria_analysis_id did not enter program null
207: --
208: l_null_ind := 1;
242: if c_segments%NOTFOUND OR c_segments%NOTFOUND IS NULL
243: then
244: l_analysis_criteria_id := NULL;
245: l_null_ind := 0;
246: hr_utility.set_location(l_proc, 27);
247: end if;
248: close c_segments;
249: else
250: l_null_ind := 0;
249: else
250: l_null_ind := 0;
251: end if;
252: --
253: hr_utility.set_location(l_proc, 20);
254: --
255: begin
256: --
257: -- Start of API User Hook for the before hook of create_job_requirement
378: -- Insert Job Requirements.
379: --
380: -- Set local analysis criteria to pass to ins jbr
381: --
382: hr_utility.set_location(l_proc, 25);
383: --
384: per_jbr_ins.ins
385: (p_job_requirement_id => l_job_requirement_id
386: ,p_business_group_id => l_business_group_id
412: ,p_object_version_number => l_object_version_number
413: ,p_validate => FALSE
414: );
415: --
416: hr_utility.set_location(l_proc, 30);
417: begin
418: --
419: -- Start of API User Hook for the after hook of create_job_requirement
420: --
502: p_job_requirement_id := l_job_requirement_id;
503: p_object_version_number := l_object_version_number;
504: p_analysis_criteria_id := l_analysis_criteria_id;
505: --
506: hr_utility.set_location('Leaving:'||l_proc, 35);
507: exception
508: when hr_api.validate_enabled then
509: --
510: -- As the Validate_Enabled exception has been raised