APPS.HR_SCL_INS dependencies on HR_SOFT_CODING_KEYFLEX

Line 63: -- Insert the row into: hr_soft_coding_keyflex

59: --
60: --
61: hr_scl_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_soft_coding_keyflex
64: --
65: insert into hr_soft_coding_keyflex
66: ( soft_coding_keyflex_id,
67: concatenated_segments,

Line 65: insert into hr_soft_coding_keyflex

61: hr_scl_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_soft_coding_keyflex
64: --
65: insert into hr_soft_coding_keyflex
66: ( soft_coding_keyflex_id,
67: concatenated_segments,
68: request_id,
69: program_application_id,

Line 217: Cursor C_Sel1 is select hr_soft_coding_keyflex_s.nextval from sys.dual;

213: Procedure pre_insert(p_rec in out nocopy hr_scl_shd.g_rec_type) is
214: --
215: l_proc varchar2(72) := g_package||'pre_insert';
216: --
217: Cursor C_Sel1 is select hr_soft_coding_keyflex_s.nextval from sys.dual;
218: --
219: Begin
220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --

Line 536: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;

532: p_soft_coding_keyflex_id out nocopy number,
533: p_concatenated_segments out nocopy varchar2,
534: p_validate in boolean default false) is
535: --
536: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
537: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type;
538: l_id_flex_num hr_soft_coding_keyflex.id_flex_num%type;
539: l_proc varchar2(72) := g_package||'ins_or_sel';
540: --

Line 537: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type;

533: p_concatenated_segments out nocopy varchar2,
534: p_validate in boolean default false) is
535: --
536: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
537: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type;
538: l_id_flex_num hr_soft_coding_keyflex.id_flex_num%type;
539: l_proc varchar2(72) := g_package||'ins_or_sel';
540: --
541: begin

Line 538: l_id_flex_num hr_soft_coding_keyflex.id_flex_num%type;

534: p_validate in boolean default false) is
535: --
536: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
537: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type;
538: l_id_flex_num hr_soft_coding_keyflex.id_flex_num%type;
539: l_proc varchar2(72) := g_package||'ins_or_sel';
540: --
541: begin
542: hr_utility.set_location('Entering:'||l_proc, 5);