APPS.OTA_FTU_INS dependencies on OTA_PVT_FRM_THREAD_USERS

Line 96: -- Insert the row into: ota_pvt_frm_thread_users

92: p_rec.object_version_number := 1; -- Initialise the object version
93: --
94: --
95: --
96: -- Insert the row into: ota_pvt_frm_thread_users
97: --
98: insert into ota_pvt_frm_thread_users
99: (forum_thread_id
100: ,forum_id

Line 98: insert into ota_pvt_frm_thread_users

94: --
95: --
96: -- Insert the row into: ota_pvt_frm_thread_users
97: --
98: insert into ota_pvt_frm_thread_users
99: (forum_thread_id
100: ,forum_id
101: ,business_group_id
102: ,author_person_id

Line 185: Cursor C_Sel1 is select ota_pvt_frm_thread_users_s.nextval from sys.dual;

181: (p_rec in out nocopy ota_ftu_shd.g_rec_type
182: ) is
183: --
184: /*
185: Cursor C_Sel1 is select ota_pvt_frm_thread_users_s.nextval from sys.dual;
186: --
187: Cursor C_Sel2 is
188: Select null
189: from ota_pvt_frm_thread_users

Line 189: from ota_pvt_frm_thread_users

185: Cursor C_Sel1 is select ota_pvt_frm_thread_users_s.nextval from sys.dual;
186: --
187: Cursor C_Sel2 is
188: Select null
189: from ota_pvt_frm_thread_users
190: where forum_thread_id =
191: ota_ftu_ins.g_forum_thread_id_i
192: or forum_id =
193: ota_ftu_ins.g_forum_id_i

Line 222: fnd_message.set_token('TABLE_NAME','ota_pvt_frm_thread_users');

218: --
219: -- The primary key values are already in use.
220: --
221: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
222: fnd_message.set_token('TABLE_NAME','ota_pvt_frm_thread_users');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel2;
226: --

Line 325: (p_module_name => 'OTA_PVT_FRM_THREAD_USERS'

321: --
322: when hr_api.cannot_find_prog_unit then
323: --
324: hr_api.cannot_find_prog_unit_error
325: (p_module_name => 'OTA_PVT_FRM_THREAD_USERS'
326: ,p_hook_type => 'AI');
327: --
328: end;
329: --

Line 342: l_forum_id ota_pvt_frm_thread_users.forum_id%TYPE;

338: ,p_rec in out nocopy ota_ftu_shd.g_rec_type
339: ) is
340: --
341: l_proc varchar2(72) := g_package||'ins';
342: l_forum_id ota_pvt_frm_thread_users.forum_id%TYPE;
343: l_forum_thread_id ota_pvt_frm_thread_users.forum_thread_id%TYPE;
344: l_person_id ota_pvt_frm_thread_users.person_id%TYPE;
345: l_contact_id ota_pvt_frm_thread_users.contact_id%TYPE;
346:

Line 343: l_forum_thread_id ota_pvt_frm_thread_users.forum_thread_id%TYPE;

339: ) is
340: --
341: l_proc varchar2(72) := g_package||'ins';
342: l_forum_id ota_pvt_frm_thread_users.forum_id%TYPE;
343: l_forum_thread_id ota_pvt_frm_thread_users.forum_thread_id%TYPE;
344: l_person_id ota_pvt_frm_thread_users.person_id%TYPE;
345: l_contact_id ota_pvt_frm_thread_users.contact_id%TYPE;
346:
347: --

Line 344: l_person_id ota_pvt_frm_thread_users.person_id%TYPE;

340: --
341: l_proc varchar2(72) := g_package||'ins';
342: l_forum_id ota_pvt_frm_thread_users.forum_id%TYPE;
343: l_forum_thread_id ota_pvt_frm_thread_users.forum_thread_id%TYPE;
344: l_person_id ota_pvt_frm_thread_users.person_id%TYPE;
345: l_contact_id ota_pvt_frm_thread_users.contact_id%TYPE;
346:
347: --
348: Begin

Line 345: l_contact_id ota_pvt_frm_thread_users.contact_id%TYPE;

341: l_proc varchar2(72) := g_package||'ins';
342: l_forum_id ota_pvt_frm_thread_users.forum_id%TYPE;
343: l_forum_thread_id ota_pvt_frm_thread_users.forum_thread_id%TYPE;
344: l_person_id ota_pvt_frm_thread_users.person_id%TYPE;
345: l_contact_id ota_pvt_frm_thread_users.contact_id%TYPE;
346:
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);