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_UPD dependencies on IRC_IOS_SHD

Line 55: (p_rec in out nocopy irc_ios_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy irc_ios_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 89: irc_ios_shd.constraint_error

85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: irc_ios_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --

Line 94: irc_ios_shd.constraint_error

90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: irc_ios_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --

Line 99: irc_ios_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: irc_ios_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: --
103: Raise;

Line 139: (p_rec in irc_ios_shd.g_rec_type

135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure pre_update
139: (p_rec in irc_ios_shd.g_rec_type
140: ) is
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --

Line 184: ,p_rec in irc_ios_shd.g_rec_type

180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure post_update
183: (p_effective_date in date
184: ,p_rec in irc_ios_shd.g_rec_type
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'post_update';
188: --

Line 210: => irc_ios_shd.g_old_rec.offer_id

206: => p_rec.decline_reason
207: ,p_object_version_number
208: => p_rec.object_version_number
209: ,p_offer_id_o
210: => irc_ios_shd.g_old_rec.offer_id
211: ,p_status_change_date_o
212: => irc_ios_shd.g_old_rec.status_change_date
213: ,p_offer_status_o
214: => irc_ios_shd.g_old_rec.offer_status

Line 212: => irc_ios_shd.g_old_rec.status_change_date

208: => p_rec.object_version_number
209: ,p_offer_id_o
210: => irc_ios_shd.g_old_rec.offer_id
211: ,p_status_change_date_o
212: => irc_ios_shd.g_old_rec.status_change_date
213: ,p_offer_status_o
214: => irc_ios_shd.g_old_rec.offer_status
215: ,p_change_reason_o
216: => irc_ios_shd.g_old_rec.change_reason

Line 214: => irc_ios_shd.g_old_rec.offer_status

210: => irc_ios_shd.g_old_rec.offer_id
211: ,p_status_change_date_o
212: => irc_ios_shd.g_old_rec.status_change_date
213: ,p_offer_status_o
214: => irc_ios_shd.g_old_rec.offer_status
215: ,p_change_reason_o
216: => irc_ios_shd.g_old_rec.change_reason
217: ,p_decline_reason_o
218: => irc_ios_shd.g_old_rec.decline_reason

Line 216: => irc_ios_shd.g_old_rec.change_reason

212: => irc_ios_shd.g_old_rec.status_change_date
213: ,p_offer_status_o
214: => irc_ios_shd.g_old_rec.offer_status
215: ,p_change_reason_o
216: => irc_ios_shd.g_old_rec.change_reason
217: ,p_decline_reason_o
218: => irc_ios_shd.g_old_rec.decline_reason
219: ,p_object_version_number_o
220: => irc_ios_shd.g_old_rec.object_version_number

Line 218: => irc_ios_shd.g_old_rec.decline_reason

214: => irc_ios_shd.g_old_rec.offer_status
215: ,p_change_reason_o
216: => irc_ios_shd.g_old_rec.change_reason
217: ,p_decline_reason_o
218: => irc_ios_shd.g_old_rec.decline_reason
219: ,p_object_version_number_o
220: => irc_ios_shd.g_old_rec.object_version_number
221: );
222: --

Line 220: => irc_ios_shd.g_old_rec.object_version_number

216: => irc_ios_shd.g_old_rec.change_reason
217: ,p_decline_reason_o
218: => irc_ios_shd.g_old_rec.decline_reason
219: ,p_object_version_number_o
220: => irc_ios_shd.g_old_rec.object_version_number
221: );
222: --
223: exception
224: --

Line 280: (p_rec in out nocopy irc_ios_shd.g_rec_type

276: --
277: -- {End Of Comments}
278: -- ----------------------------------------------------------------------------
279: Procedure convert_defs
280: (p_rec in out nocopy irc_ios_shd.g_rec_type
281: ) is
282: --
283: Begin
284: --

Line 292: irc_ios_shd.g_old_rec.offer_id;

288: -- is being used then we must set to the 'current' argument value.
289: --
290: If (p_rec.offer_id = hr_api.g_number) then
291: p_rec.offer_id :=
292: irc_ios_shd.g_old_rec.offer_id;
293: End If;
294: If (p_rec.status_change_date = hr_api.g_date) then
295: p_rec.status_change_date :=
296: irc_ios_shd.g_old_rec.status_change_date;

Line 296: irc_ios_shd.g_old_rec.status_change_date;

292: irc_ios_shd.g_old_rec.offer_id;
293: End If;
294: If (p_rec.status_change_date = hr_api.g_date) then
295: p_rec.status_change_date :=
296: irc_ios_shd.g_old_rec.status_change_date;
297: End If;
298: If (p_rec.offer_status = hr_api.g_varchar2) then
299: p_rec.offer_status :=
300: irc_ios_shd.g_old_rec.offer_status;

Line 300: irc_ios_shd.g_old_rec.offer_status;

296: irc_ios_shd.g_old_rec.status_change_date;
297: End If;
298: If (p_rec.offer_status = hr_api.g_varchar2) then
299: p_rec.offer_status :=
300: irc_ios_shd.g_old_rec.offer_status;
301: End If;
302: If (p_rec.change_reason = hr_api.g_varchar2) then
303: p_rec.change_reason :=
304: irc_ios_shd.g_old_rec.change_reason;

Line 304: irc_ios_shd.g_old_rec.change_reason;

300: irc_ios_shd.g_old_rec.offer_status;
301: End If;
302: If (p_rec.change_reason = hr_api.g_varchar2) then
303: p_rec.change_reason :=
304: irc_ios_shd.g_old_rec.change_reason;
305: End If;
306: If (p_rec.decline_reason = hr_api.g_varchar2) then
307: p_rec.decline_reason :=
308: irc_ios_shd.g_old_rec.decline_reason;

Line 308: irc_ios_shd.g_old_rec.decline_reason;

304: irc_ios_shd.g_old_rec.change_reason;
305: End If;
306: If (p_rec.decline_reason = hr_api.g_varchar2) then
307: p_rec.decline_reason :=
308: irc_ios_shd.g_old_rec.decline_reason;
309: End If;
310: --
311: End convert_defs;
312: --

Line 318: ,p_rec in out nocopy irc_ios_shd.g_rec_type

314: -- |---------------------------------< upd >----------------------------------|
315: -- ----------------------------------------------------------------------------
316: Procedure upd
317: (p_effective_date in date
318: ,p_rec in out nocopy irc_ios_shd.g_rec_type
319: ) is
320: --
321: l_proc varchar2(72) := g_package||'upd';
322: --

Line 328: irc_ios_shd.lck

324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: -- We must lock the row which we need to update.
327: --
328: irc_ios_shd.lck
329: (p_rec.offer_status_history_id
330: ,p_rec.object_version_number
331: );
332: --

Line 381: l_rec irc_ios_shd.g_rec_type;

377: ,p_change_reason in varchar2 default hr_api.g_varchar2
378: ,p_decline_reason in varchar2 default hr_api.g_varchar2
379: ) is
380: --
381: l_rec irc_ios_shd.g_rec_type;
382: l_proc varchar2(72) := g_package||'upd';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);

Line 391: irc_ios_shd.convert_args

387: -- Call conversion function to turn arguments into the
388: -- l_rec structure.
389: --
390: l_rec :=
391: irc_ios_shd.convert_args
392: (p_offer_status_history_id
393: ,p_offer_id
394: ,p_status_change_date
395: ,p_offer_status