APPS.IRC_IVC_INS dependencies on IRC_VACANCY_CONSIDERATIONS

Line 83: -- Insert the row into: irc_vacancy_considerations

79: p_rec.object_version_number := 1; -- Initialise the object version
80: --
81: --
82: --
83: -- Insert the row into: irc_vacancy_considerations
84: --
85: insert into irc_vacancy_considerations
86: (vacancy_consideration_id
87: ,person_id

Line 85: insert into irc_vacancy_considerations

81: --
82: --
83: -- Insert the row into: irc_vacancy_considerations
84: --
85: insert into irc_vacancy_considerations
86: (vacancy_consideration_id
87: ,person_id
88: ,party_id
89: ,vacancy_id

Line 167: cursor c1 is select irc_vacancy_considerations_s.nextval from sys.dual;

163: Procedure pre_insert
164: (p_rec in out nocopy irc_ivc_shd.g_rec_type
165: ) is
166: --
167: cursor c1 is select irc_vacancy_considerations_s.nextval from sys.dual;
168: cursor c2 is
169: select null from irc_vacancy_considerations
170: where vacancy_consideration_id=irc_ivc_ins.g_vacancy_consideration_id_i;
171: l_proc varchar2(72) := g_package||'pre_insert';

Line 169: select null from irc_vacancy_considerations

165: ) is
166: --
167: cursor c1 is select irc_vacancy_considerations_s.nextval from sys.dual;
168: cursor c2 is
169: select null from irc_vacancy_considerations
170: where vacancy_consideration_id=irc_ivc_ins.g_vacancy_consideration_id_i;
171: l_proc varchar2(72) := g_package||'pre_insert';
172: l_exists varchar2(1);
173: --

Line 184: fnd_message.set_token('TABLE_NAME','irc_vacancy_considerations');

180: fetch c2 into l_exists;
181: if c2%found then
182: close c2;
183: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
184: fnd_message.set_token('TABLE_NAME','irc_vacancy_considerations');
185: fnd_message.raise_error;
186: end if;
187: close c2;
188: --

Line 266: (p_module_name => 'IRC_VACANCY_CONSIDERATIONS'

262: --
263: when hr_api.cannot_find_prog_unit then
264: --
265: hr_api.cannot_find_prog_unit_error
266: (p_module_name => 'IRC_VACANCY_CONSIDERATIONS'
267: ,p_hook_type => 'AI');
268: --
269: end;
270: --