62: and pj.business_group_id + 0 = p_business_group_id;
63: --
64: cursor csr_combo_exists is
65: select 'x'
66: from per_job_requirements pjr
67: where (p_job_requirement_id <> pjr.job_requirement_id or
68: p_job_requirement_id is NULL)
69: and p_job_id = pjr.job_id
70: and p_analysis_criteria_id = pjr.analysis_criteria_id;
171: and pos.business_group_id + 0 = p_business_group_id;
172: --
173: cursor csr_pos_combo_exists is
174: select 'x'
175: from per_job_requirements pjr
176: where (p_job_requirement_id <> pjr.job_requirement_id or
177: p_job_requirement_id is NULL)
178: and p_position_id = pjr.position_id
179: and p_analysis_criteria_id = pjr.analysis_criteria_id;
532: -- b) During insert.
533: --
534: hr_dflex_utility.ins_or_upd_descflex_attribs
535: (p_appl_short_name => 'PER'
536: ,p_descflex_name => 'PER_JOB_REQUIREMENTS'
537: ,p_attribute_category => p_rec.attribute_category
538: ,p_attribute1_name => 'ATTRIBUTE1'
539: ,p_attribute1_value => p_rec.attribute1
540: ,p_attribute2_name => 'ATTRIBUTE2'