APPS.IRC_INP_INS dependencies on IRC_NOTIFICATION_PREFERENCES

Line 87: -- Insert the row into: irc_notification_preferences

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: irc_inp_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: irc_notification_preferences
88: --
89: insert into irc_notification_preferences
90: (party_id
91: ,person_id

Line 89: insert into irc_notification_preferences

85: irc_inp_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: irc_notification_preferences
88: --
89: insert into irc_notification_preferences
90: (party_id
91: ,person_id
92: ,notification_preference_id
93: ,matching_jobs

Line 250: select null from irc_notification_preferences

246: --
247: cursor c1 is select irc_notification_prefs_s.nextval from sys.dual;
248: --
249: cursor c2 is
250: select null from irc_notification_preferences
251: where notification_preference_id = irc_inp_ins.g_notification_preference_id_i;
252: --
253: l_proc varchar2(72) := g_package||'pre_insert';
254: l_exists varchar2(1);

Line 266: fnd_message.set_token('TABLE_NAME','irc_notification_preferences');

262: fetch c2 into l_exists;
263: if c2%found then
264: close c2;
265: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
266: fnd_message.set_token('TABLE_NAME','irc_notification_preferences');
267: fnd_message.raise_error;
268: end if;
269: close c2;
270: --

Line 420: (p_module_name => 'IRC_NOTIFICATION_PREFERENCES'

416: --
417: when hr_api.cannot_find_prog_unit then
418: --
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'IRC_NOTIFICATION_PREFERENCES'
421: ,p_hook_type => 'AI');
422: --
423: end;
424: --