APPS.IRC_IDO_INS dependencies on IRC_IDO_INS

Line 1: Package Body irc_ido_ins as

1: Package Body irc_ido_ins as
2: /* $Header: iridorhi.pkb 120.5.12010000.2 2008/09/26 13:55:20 pvelugul ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' irc_ido_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_ido_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_ido_ins.g_document_id_i := p_document_id;

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: irc_ido_ins.g_document_id_i := p_document_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --

Line 199: irc_ido_ins.g_document_id_i;

195: Cursor C_Sel2 is
196: Select null
197: from irc_documents
198: where document_id =
199: irc_ido_ins.g_document_id_i;
200: --
201: l_proc varchar2(72) := g_package||'pre_insert';
202: l_exists varchar2(1);
203: --

Line 207: If (irc_ido_ins.g_document_id_i is not null) Then

203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: If (irc_ido_ins.g_document_id_i is not null) Then
208: --
209: -- Verify registered primary key values not already in use
210: --
211: Open C_Sel2;

Line 227: irc_ido_ins.g_document_id_i;

223: --
224: -- Use registered key values and clear globals
225: --
226: p_rec.document_id :=
227: irc_ido_ins.g_document_id_i;
228: irc_ido_ins.g_document_id_i := null;
229: Else
230: --
231: -- No registerd key values, so select the next sequence number

Line 228: irc_ido_ins.g_document_id_i := null;

224: -- Use registered key values and clear globals
225: --
226: p_rec.document_id :=
227: irc_ido_ins.g_document_id_i;
228: irc_ido_ins.g_document_id_i := null;
229: Else
230: --
231: -- No registerd key values, so select the next sequence number
232: --

Line 356: irc_ido_ins.pre_insert(p_rec);

352: );
353: --
354: -- Call the supporting pre-insert operation
355: --
356: irc_ido_ins.pre_insert(p_rec);
357: --
358: -- Insert the row
359: --
360: irc_ido_ins.insert_dml(p_rec);

Line 360: irc_ido_ins.insert_dml(p_rec);

356: irc_ido_ins.pre_insert(p_rec);
357: --
358: -- Insert the row
359: --
360: irc_ido_ins.insert_dml(p_rec);
361: --
362: -- Call the supporting post-insert operation
363: --
364: irc_ido_ins.post_insert

Line 364: irc_ido_ins.post_insert

360: irc_ido_ins.insert_dml(p_rec);
361: --
362: -- Call the supporting post-insert operation
363: --
364: irc_ido_ins.post_insert
365: (p_effective_date
366: ,p_rec
367: );
368: --

Line 418: irc_ido_ins.ins

414: --
415: -- Having converted the arguments into the irc_ido_rec
416: -- plsql record structure we call the corresponding record business process.
417: --
418: irc_ido_ins.ins
419: (p_effective_date
420: ,l_rec
421: );
422: --

Line 432: end irc_ido_ins;

428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 10);
430: End ins;
431: --
432: end irc_ido_ins;