APPS.IRC_IID_INS dependencies on IRC_IID_INS

Line 1: Package Body irc_iid_ins as

1: Package Body irc_iid_ins as
2: /* $Header: iriidrhi.pkb 120.3.12010000.2 2008/11/06 13:49:47 mkjayara ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_iid_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_iid_ins.g_interview_details_id_i := p_interview_details_id;

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

Line 257: irc_iid_ins.dt_insert_dml

253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: irc_iid_ins.dt_insert_dml
258: (p_rec => p_rec
259: ,p_effective_date => p_effective_date
260: ,p_datetrack_mode => p_datetrack_mode
261: ,p_validation_start_date => p_validation_start_date

Line 321: irc_iid_ins.g_interview_details_id_i

317: Cursor C_Sel2 is
318: Select null
319: from irc_interview_details
320: where interview_details_id =
321: irc_iid_ins.g_interview_details_id_i
322: and p_effective_date between start_date
323: and end_date;
324: --
325: l_proc varchar2(72) := g_package||'pre_insert';

Line 331: If (irc_iid_ins.g_interview_details_id_i is not null) Then

327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: If (irc_iid_ins.g_interview_details_id_i is not null) Then
332: --
333: -- Verify registered primary key values not already in use
334: --
335: Open C_Sel2;

Line 351: irc_iid_ins.g_interview_details_id_i;

347: --
348: -- Use registered key values and clear globals
349: --
350: p_rec.interview_details_id :=
351: irc_iid_ins.g_interview_details_id_i;
352: irc_iid_ins.g_interview_details_id_i := null;
353: Else
354: --
355: -- No registerd key values, so select the next sequence number

Line 352: irc_iid_ins.g_interview_details_id_i := null;

348: -- Use registered key values and clear globals
349: --
350: p_rec.interview_details_id :=
351: irc_iid_ins.g_interview_details_id_i;
352: irc_iid_ins.g_interview_details_id_i := null;
353: Else
354: --
355: -- No registerd key values, so select the next sequence number
356: --

Line 551: irc_iid_ins.ins_lck

547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Call the lock operation
550: --
551: irc_iid_ins.ins_lck
552: (p_effective_date => p_effective_date
553: ,p_datetrack_mode => l_datetrack_mode
554: ,p_rec => p_rec
555: ,p_validation_start_date => l_validation_start_date

Line 574: irc_iid_ins.pre_insert

570: hr_multi_message.end_validation_set;
571: --
572: -- Call the supporting pre-insert operation
573: --
574: irc_iid_ins.pre_insert
575: (p_rec => p_rec
576: ,p_effective_date => p_effective_date
577: ,p_datetrack_mode => l_datetrack_mode
578: ,p_validation_start_date => l_validation_start_date

Line 584: irc_iid_ins.insert_dml

580: );
581: --
582: -- Insert the row
583: --
584: irc_iid_ins.insert_dml
585: (p_rec => p_rec
586: ,p_effective_date => p_effective_date
587: ,p_datetrack_mode => l_datetrack_mode
588: ,p_validation_start_date => l_validation_start_date

Line 594: irc_iid_ins.post_insert

590: );
591: --
592: -- Call the supporting post-insert operation
593: --
594: irc_iid_ins.post_insert
595: (p_rec => p_rec
596: ,p_effective_date => p_effective_date
597: ,p_datetrack_mode => l_datetrack_mode
598: ,p_validation_start_date => l_validation_start_date

Line 696: irc_iid_ins.ins

692: -- Having converted the arguments into the irc_iid_rec
693: -- plsql record structure we call the corresponding record
694: -- business process.
695: --
696: irc_iid_ins.ins
697: (p_effective_date
698: ,l_rec
699: );
700: --

Line 712: end irc_iid_ins;

708: --
709: hr_utility.set_location(' Leaving:'||l_proc, 10);
710: End ins;
711: --
712: end irc_iid_ins;