APPS.IRC_IOF_INS dependencies on IRC_IOF_INS

Line 1: package body irc_iof_ins as

1: package body irc_iof_ins as
2: /* $Header: iriofrhi.pkb 120.13 2006/04/17 05:06 narvenka noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | private global definitions |

Line 8: g_package varchar2(33) := ' irc_iof_ins.'; -- global package name

4: -- ----------------------------------------------------------------------------
5: -- | private global definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_iof_ins.'; -- global package name
9: --
10: -- the following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 26: irc_iof_ins.g_offer_id_i := p_offer_id;

22: --
23: begin
24: hr_utility.set_location('entering:'||l_proc, 10);
25: --
26: irc_iof_ins.g_offer_id_i := p_offer_id;
27: --
28: hr_utility.set_location(' leaving:'||l_proc, 20);
29: end set_base_key_value;
30: --

Line 269: irc_iof_ins.g_offer_id_i;

265: cursor c_sel2 is
266: select null
267: from irc_offers
268: where offer_id =
269: irc_iof_ins.g_offer_id_i;
270: --
271: l_proc varchar2(72) := g_package||'pre_insert';
272: l_exists varchar2(1);
273: --

Line 277: if (irc_iof_ins.g_offer_id_i is not null) then

273: --
274: begin
275: hr_utility.set_location('entering:'||l_proc, 5);
276: --
277: if (irc_iof_ins.g_offer_id_i is not null) then
278: --
279: -- verify registered primary key values not already in use
280: --
281: open c_sel2;

Line 297: irc_iof_ins.g_offer_id_i;

293: --
294: -- use registered key values and clear globals
295: --
296: p_rec.offer_id :=
297: irc_iof_ins.g_offer_id_i;
298: irc_iof_ins.g_offer_id_i := null;
299: else
300: --
301: -- no registerd key values, so select the next sequence number

Line 298: irc_iof_ins.g_offer_id_i := null;

294: -- use registered key values and clear globals
295: --
296: p_rec.offer_id :=
297: irc_iof_ins.g_offer_id_i;
298: irc_iof_ins.g_offer_id_i := null;
299: else
300: --
301: -- no registerd key values, so select the next sequence number
302: --

Line 501: irc_iof_ins.pre_insert(p_rec);

497: hr_multi_message.end_validation_set;
498: --
499: -- call the supporting pre-insert operation
500: --
501: irc_iof_ins.pre_insert(p_rec);
502: --
503: -- insert the row
504: --
505: irc_iof_ins.insert_dml(p_rec);

Line 505: irc_iof_ins.insert_dml(p_rec);

501: irc_iof_ins.pre_insert(p_rec);
502: --
503: -- insert the row
504: --
505: irc_iof_ins.insert_dml(p_rec);
506: --
507: -- call the supporting post-insert operation
508: --
509: irc_iof_ins.post_insert

Line 509: irc_iof_ins.post_insert

505: irc_iof_ins.insert_dml(p_rec);
506: --
507: -- call the supporting post-insert operation
508: --
509: irc_iof_ins.post_insert
510: (p_effective_date
511: ,p_rec
512: );
513: --

Line 644: irc_iof_ins.ins

640: --
641: -- having converted the arguments into the irc_iof_rec
642: -- plsql record structure we call the corresponding record business process.
643: --
644: irc_iof_ins.ins
645: (p_effective_date
646: ,l_rec
647: );
648: --

Line 659: end irc_iof_ins;

655: --
656: hr_utility.set_location(' leaving:'||l_proc, 10);
657: end ins;
658: --
659: end irc_iof_ins;