APPS.HR_ICX_INS dependencies on HR_ITEM_CONTEXTS

Line 48: l_item_context_id hr_item_contexts.item_context_id%type;

44: p_item_context_id out nocopy number,
45: p_concatenated_segments out nocopy varchar2
46: ) is
47: --
48: l_item_context_id hr_item_contexts.item_context_id%type;
49: l_concatenated_segments varchar2(2000);
50: l_id_flex_num hr_item_contexts.id_flex_num%type;
51: l_segs_changed boolean;
52: --

Line 50: l_id_flex_num hr_item_contexts.id_flex_num%type;

46: ) is
47: --
48: l_item_context_id hr_item_contexts.item_context_id%type;
49: l_concatenated_segments varchar2(2000);
50: l_id_flex_num hr_item_contexts.id_flex_num%type;
51: l_segs_changed boolean;
52: --
53: CURSOR cur_id_flex
54: IS

Line 227: -- Insert the row into: hr_item_contexts

223: p_rec.object_version_number := 1; -- Initialise the object version
224: --
225: --
226: --
227: -- Insert the row into: hr_item_contexts
228: --
229: insert into hr_item_contexts
230: (item_context_id
231: ,object_version_number

Line 229: insert into hr_item_contexts

225: --
226: --
227: -- Insert the row into: hr_item_contexts
228: --
229: insert into hr_item_contexts
230: (item_context_id
231: ,object_version_number
232: ,id_flex_num
233: ,summary_flag

Line 375: Cursor C_Sel1 is select hr_item_contexts_s.nextval from sys.dual;

371: ) is
372: --
373: l_proc varchar2(72) := g_package||'pre_insert';
374: --
375: Cursor C_Sel1 is select hr_item_contexts_s.nextval from sys.dual;
376: --
377: Begin
378: hr_utility.set_location('Entering:'||l_proc, 5);
379: --

Line 516: (p_module_name => 'HR_ITEM_CONTEXTS'

512: --
513: when hr_api.cannot_find_prog_unit then
514: --
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'HR_ITEM_CONTEXTS'
517: ,p_hook_type => 'AI');
518: --
519: end;
520: --