eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IOS_INS dependencies on IRC_IOS_INS

Line 1: Package Body irc_ios_ins as

1: Package Body irc_ios_ins as
2: /* $Header: iriosrhi.pkb 120.3.12010000.2 2008/11/09 06:41:05 vmummidi ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_ios_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_ios_ins.g_offer_status_history_id_i := p_offer_status_history_id;

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

Line 179: irc_ios_ins.g_offer_status_history_id_i;

175: Cursor C_Sel2 is
176: Select null
177: from irc_offer_status_history
178: where offer_status_history_id =
179: irc_ios_ins.g_offer_status_history_id_i;
180: --
181: l_proc varchar2(72) := g_package||'pre_insert';
182: l_exists varchar2(1);
183: --

Line 187: If (irc_ios_ins.g_offer_status_history_id_i is not null) Then

183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: If (irc_ios_ins.g_offer_status_history_id_i is not null) Then
188: --
189: -- Verify registered primary key values not already in use
190: --
191: Open C_Sel2;

Line 207: irc_ios_ins.g_offer_status_history_id_i;

203: --
204: -- Use registered key values and clear globals
205: --
206: p_rec.offer_status_history_id :=
207: irc_ios_ins.g_offer_status_history_id_i;
208: irc_ios_ins.g_offer_status_history_id_i := null;
209: Else
210: --
211: -- No registerd key values, so select the next sequence number

Line 208: irc_ios_ins.g_offer_status_history_id_i := null;

204: -- Use registered key values and clear globals
205: --
206: p_rec.offer_status_history_id :=
207: irc_ios_ins.g_offer_status_history_id_i;
208: irc_ios_ins.g_offer_status_history_id_i := null;
209: Else
210: --
211: -- No registerd key values, so select the next sequence number
212: --

Line 323: irc_ios_ins.pre_insert(p_rec);

319: hr_multi_message.end_validation_set;
320: --
321: -- Call the supporting pre-insert operation
322: --
323: irc_ios_ins.pre_insert(p_rec);
324: --
325: -- Insert the row
326: --
327: irc_ios_ins.insert_dml(p_rec);

Line 327: irc_ios_ins.insert_dml(p_rec);

323: irc_ios_ins.pre_insert(p_rec);
324: --
325: -- Insert the row
326: --
327: irc_ios_ins.insert_dml(p_rec);
328: --
329: -- Call the supporting post-insert operation
330: --
331: irc_ios_ins.post_insert

Line 331: irc_ios_ins.post_insert

327: irc_ios_ins.insert_dml(p_rec);
328: --
329: -- Call the supporting post-insert operation
330: --
331: irc_ios_ins.post_insert
332: (p_effective_date
333: ,p_rec
334: );
335: --

Line 379: irc_ios_ins.ins

375: --
376: -- Having converted the arguments into the irc_ios_rec
377: -- plsql record structure we call the corresponding record business process.
378: --
379: irc_ios_ins.ins
380: (p_effective_date
381: ,l_rec
382: );
383: --

Line 393: end irc_ios_ins;

389: --
390: hr_utility.set_location(' Leaving:'||l_proc, 10);
391: End ins;
392: --
393: end irc_ios_ins;