APPS.HR_SCL_SHD dependencies on HR_SOFT_CODING_KEYFLEX

Line 48: l_id_flex_num hr_soft_coding_keyflex.id_flex_num%type;

44: p_soft_coding_keyflex_id out nocopy number,
45: p_concatenated_segments out nocopy varchar2,
46: p_id_flex_num out nocopy number) is
47: --
48: l_id_flex_num hr_soft_coding_keyflex.id_flex_num%type;
49: l_proc varchar2(72) := g_package||'segment_combination_check';
50: --
51: -- the cursor idsel selects the valid id_flex_num
52: -- (scl keyflex) for the specified business group

Line 81: from hr_soft_coding_keyflex scl

77: --
78: cursor sclsel is
79: select scl.soft_coding_keyflex_id,
80: scl.concatenated_segments
81: from hr_soft_coding_keyflex scl
82: where scl.id_flex_num = l_id_flex_num
83: and scl.enabled_flag = 'Y'
84: and (scl.segment1 = p_segment1
85: or (scl.segment1 is null

Line 283: If (p_constraint_name = 'HR_SOFT_CODING_KEYFLEX_PK') Then

279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: If (p_constraint_name = 'HR_SOFT_CODING_KEYFLEX_PK') Then
284: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
285: hr_utility.raise_error;
286: Else
287: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 348: from hr_soft_coding_keyflex

344: segment27,
345: segment28,
346: segment29,
347: segment30
348: from hr_soft_coding_keyflex
349: where soft_coding_keyflex_id = p_soft_coding_keyflex_id;
350: --
351: l_proc varchar2(72) := g_package||'api_updating';
352: l_fct_ret boolean;