84: -- the cursor kfsel selects the analysis_criteria_id
85: --
86: cursor kfsel is
87: select pac.analysis_criteria_id
88: from per_analysis_criteria pac
89: where pac.id_flex_num = p_id_flex_num
90: and pac.enabled_flag = 'Y'
91: and (pac.segment1 = p_segment1
92: or (pac.segment1 is null
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: If (p_constraint_name = 'PER_ANALYSIS_CRITERIA_PK') Then
324: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
325: hr_utility.raise_error;
326: Else
327: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
385: segment27,
386: segment28,
387: segment29,
388: segment30
389: from per_analysis_criteria
390: where analysis_criteria_id = p_analysis_criteria_id;
391: --
392: l_proc varchar2(72) := g_package||'api_updating';
393: l_fct_ret boolean;