APPS.IRC_JBI_INS dependencies on IRC_JOB_BASKET_ITEMS

Line 87: -- Insert the row into: irc_job_basket_items

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

Line 89: insert into irc_job_basket_items(job_basket_item_id

85: irc_jbi_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: irc_job_basket_items
88: --
89: insert into irc_job_basket_items(job_basket_item_id
90: ,person_id
91: ,party_id
92: ,recruitment_activity_id
93: ,object_version_number

Line 172: cursor c1 is select irc_job_basket_items_s.nextval from sys.dual;

168: Procedure pre_insert
169: (p_rec in out nocopy irc_jbi_shd.g_rec_type
170: ) is
171: --
172: cursor c1 is select irc_job_basket_items_s.nextval from sys.dual;
173: cursor c2 is
174: select null from irc_job_basket_items
175: where job_basket_item_id=irc_jbi_ins.g_job_basket_item_id_i;
176: l_proc varchar2(72) := g_package||'pre_insert';

Line 174: select null from irc_job_basket_items

170: ) is
171: --
172: cursor c1 is select irc_job_basket_items_s.nextval from sys.dual;
173: cursor c2 is
174: select null from irc_job_basket_items
175: where job_basket_item_id=irc_jbi_ins.g_job_basket_item_id_i;
176: l_proc varchar2(72) := g_package||'pre_insert';
177: l_exists varchar2(1);
178: --

Line 189: fnd_message.set_token('TABLE_NAME','irc_job_basket_items');

185: fetch c2 into l_exists;
186: if c2%found then
187: close c2;
188: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
189: fnd_message.set_token('TABLE_NAME','irc_job_basket_items');
190: fnd_message.raise_error;
191: end if;
192: close c2;
193: --

Line 270: (p_module_name => 'IRC_JOB_BASKET_ITEMS'

266: --
267: when hr_api.cannot_find_prog_unit then
268: --
269: hr_api.cannot_find_prog_unit_error
270: (p_module_name => 'IRC_JOB_BASKET_ITEMS'
271: ,p_hook_type => 'AI');
272: --
273: end;
274: --