APPS.OTA_FOI_INS dependencies on OTA_FRM_OBJ_INCLUSIONS

Line 93: -- Insert the row into: ota_frm_obj_inclusions

89: p_rec.object_version_number := 1; -- Initialise the object version
90: --
91: --
92: --
93: -- Insert the row into: ota_frm_obj_inclusions
94: --
95: insert into ota_frm_obj_inclusions
96: (forum_id
97: ,object_id

Line 95: insert into ota_frm_obj_inclusions

91: --
92: --
93: -- Insert the row into: ota_frm_obj_inclusions
94: --
95: insert into ota_frm_obj_inclusions
96: (forum_id
97: ,object_id
98: ,object_type
99: ,start_date_active

Line 180: Cursor C_Sel1 is select ota_frm_obj_inclusions_s.nextval from sys.dual;

176: (p_rec in out nocopy ota_foi_shd.g_rec_type
177: ) is
178: --
179: /*
180: Cursor C_Sel1 is select ota_frm_obj_inclusions_s.nextval from sys.dual;
181: --
182: Cursor C_Sel2 is
183: Select null
184: from ota_frm_obj_inclusions

Line 184: from ota_frm_obj_inclusions

180: Cursor C_Sel1 is select ota_frm_obj_inclusions_s.nextval from sys.dual;
181: --
182: Cursor C_Sel2 is
183: Select null
184: from ota_frm_obj_inclusions
185: where forum_id =
186: ota_foi_ins.g_forum_id_i
187: or object_id =
188: ota_foi_ins.g_object_id_i

Line 214: fnd_message.set_token('TABLE_NAME','ota_frm_obj_inclusions');

210: --
211: -- The primary key values are already in use.
212: --
213: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
214: fnd_message.set_token('TABLE_NAME','ota_frm_obj_inclusions');
215: fnd_message.raise_error;
216: End If;
217: Close C_Sel2;
218: --

Line 312: (p_module_name => 'OTA_FRM_OBJ_INCLUSIONS'

308: --
309: when hr_api.cannot_find_prog_unit then
310: --
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'OTA_FRM_OBJ_INCLUSIONS'
313: ,p_hook_type => 'AI');
314: --
315: end;
316: --

Line 329: l_forum_id ota_frm_obj_inclusions.forum_id%TYPE;

325: ,p_rec in out nocopy ota_foi_shd.g_rec_type
326: ) is
327: --
328: l_proc varchar2(72) := g_package||'ins';
329: l_forum_id ota_frm_obj_inclusions.forum_id%TYPE;
330: l_object_id ota_frm_obj_inclusions.object_id%TYPE;
331: l_object_type ota_frm_obj_inclusions.object_type%TYPE;
332:
333: --

Line 330: l_object_id ota_frm_obj_inclusions.object_id%TYPE;

326: ) is
327: --
328: l_proc varchar2(72) := g_package||'ins';
329: l_forum_id ota_frm_obj_inclusions.forum_id%TYPE;
330: l_object_id ota_frm_obj_inclusions.object_id%TYPE;
331: l_object_type ota_frm_obj_inclusions.object_type%TYPE;
332:
333: --
334: Begin

Line 331: l_object_type ota_frm_obj_inclusions.object_type%TYPE;

327: --
328: l_proc varchar2(72) := g_package||'ins';
329: l_forum_id ota_frm_obj_inclusions.forum_id%TYPE;
330: l_object_id ota_frm_obj_inclusions.object_id%TYPE;
331: l_object_type ota_frm_obj_inclusions.object_type%TYPE;
332:
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);