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_BUS dependencies on IRC_OFFER_STATUS_HISTORY

Line 30: , irc_offer_status_history ios

26: --
27: cursor csr_leg_code is
28: select pbg.legislation_code
29: from per_business_groups_perf pbg
30: , irc_offer_status_history ios
31: , per_all_vacancies vac
32: where ios.offer_status_history_id = p_offer_status_history_id
33: and pbg.business_group_id = vac.business_group_id;
34: --

Line 211: (p_offer_id in irc_offer_status_history.offer_id%TYPE

207: --
208: -- {End Of Comments}
209: -- ----------------------------------------------------------------------------
210: Procedure chk_offer_id
211: (p_offer_id in irc_offer_status_history.offer_id%TYPE
212: ) is
213: --
214: l_proc varchar2(72) := g_package || 'chk_offer_id';
215: --

Line 216: l_offer_id irc_offer_status_history.offer_id%TYPE;

212: ) is
213: --
214: l_proc varchar2(72) := g_package || 'chk_offer_id';
215: --
216: l_offer_id irc_offer_status_history.offer_id%TYPE;
217: --
218: cursor csr_offer is
219: select 1
220: from IRC_OFFERS

Line 248: 'IRC_OFFER_STATUS_HISTORY.OFFER_ID'

244: exception
245: when app_exception.application_exception then
246: if hr_multi_message.exception_add
247: (p_associated_column1=>
248: 'IRC_OFFER_STATUS_HISTORY.OFFER_ID'
249: ) then
250: hr_utility.set_location(' Leaving:'|| l_proc, 40);
251: raise;
252: end if;

Line 263: -- a) Offer Status is not null in the table irc_offer_status_history

259: -- {Start Of Comments}
260: --
261: -- Description:
262: -- This procedure is used to ensure that
263: -- a) Offer Status is not null in the table irc_offer_status_history
264: -- b) Offer Status is a valid value from IRC_OFFER_STATUSES lookup
265: --
266: -- Pre Conditions:
267: -- offer status should exist in the table.

Line 282: (p_offer_status in irc_offer_status_history.offer_status%TYPE,

278: --
279: -- {End Of Comments}
280: -- ----------------------------------------------------------------------------
281: Procedure chk_offer_status
282: (p_offer_status in irc_offer_status_history.offer_status%TYPE,
283: p_effective_date in date
284: ) is
285: --
286: l_proc varchar2(72) := g_package || 'chk_offer_status';

Line 288: l_offer_status irc_offer_status_history.offer_status%TYPE;

284: ) is
285: --
286: l_proc varchar2(72) := g_package || 'chk_offer_status';
287: --
288: l_offer_status irc_offer_status_history.offer_status%TYPE;
289:
290: --
291: begin
292: --

Line 328: 'IRC_OFFER_STATUS_HISTORY.OFFER_STATUS'

324: exception
325: when app_exception.application_exception then
326: if hr_multi_message.exception_add
327: (p_associated_column1=>
328: 'IRC_OFFER_STATUS_HISTORY.OFFER_STATUS'
329: ) then
330: hr_utility.set_location(' Leaving:'|| l_proc, 40);
331: raise;
332: end if;

Line 345: -- b) Should not get updated in irc_offer_status_history

341: -- Description:
342: -- This procedure is used to ensure that
343: -- a) Change Reason must be a valid value from
344: -- IRC_OFFER_STATUS_CHANGE_REASON lookup
345: -- b) Should not get updated in irc_offer_status_history
346: --
347: -- Pre Conditions:
348: -- Change Reason should exist in the lookup.
349: --

Line 363: (p_change_reason in irc_offer_status_history.change_reason%TYPE,

359: --
360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure chk_change_reason
363: (p_change_reason in irc_offer_status_history.change_reason%TYPE,
364: p_effective_date in date
365: ) is
366: --
367: l_proc varchar2(72) := g_package || 'chk_change_reason';

Line 369: l_change_reason irc_offer_status_history.change_reason%TYPE;

365: ) is
366: --
367: l_proc varchar2(72) := g_package || 'chk_change_reason';
368: --
369: l_change_reason irc_offer_status_history.change_reason%TYPE;
370:
371: --
372: begin
373: --

Line 397: 'IRC_OFFER_STATUS_HISTORY.CHANGE_REASON'

393: exception
394: when app_exception.application_exception then
395: if hr_multi_message.exception_add
396: (p_associated_column1=>
397: 'IRC_OFFER_STATUS_HISTORY.CHANGE_REASON'
398: ) then
399: hr_utility.set_location(' Leaving:'|| l_proc, 40);
400: raise;
401: end if;

Line 414: -- b) Should not get updated in irc_offer_status_history

410: -- Description:
411: -- This procedure is used to ensure that
412: -- a) decline Reason must be a valid value from
413: -- IRC_OFFER_STATUS_DECLINE_REASON lookup
414: -- b) Should not get updated in irc_offer_status_history
415: --
416: -- Pre Conditions:
417: -- decline Reason should exist in the lookup.
418: --

Line 432: (p_decline_reason in irc_offer_status_history.decline_reason%TYPE,

428: --
429: -- {End Of Comments}
430: -- ----------------------------------------------------------------------------
431: Procedure chk_decline_reason
432: (p_decline_reason in irc_offer_status_history.decline_reason%TYPE,
433: p_effective_date in date
434: ) is
435: --
436: l_proc varchar2(72) := g_package || 'chk_decline_reason';

Line 438: l_decline_reason irc_offer_status_history.decline_reason%TYPE;

434: ) is
435: --
436: l_proc varchar2(72) := g_package || 'chk_decline_reason';
437: --
438: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
439:
440: --
441: begin
442: --

Line 481: 'IRC_OFFER_STATUS_HISTORY.DECLINE_REASON'

477: exception
478: when app_exception.application_exception then
479: if hr_multi_message.exception_add
480: (p_associated_column1=>
481: 'IRC_OFFER_STATUS_HISTORY.DECLINE_REASON'
482: ) then
483: hr_utility.set_location(' Leaving:'|| l_proc, 40);
484: raise;
485: end if;

Line 498: -- b) Should not get updated in irc_offer_status_history

494: -- Description:
495: -- This procedure is used to ensure that
496: -- a) decline Reason must be a valid value from
497: -- IRC_OFFER_WITHDRAW_REASON lookup
498: -- b) Should not get updated in irc_offer_status_history
499: --
500: -- Pre Conditions:
501: -- decline Reason should exist in the lookup.
502: --

Line 516: (p_withdraw_reason in irc_offer_status_history.decline_reason%TYPE,

512: --
513: -- {End Of Comments}
514: -- ----------------------------------------------------------------------------
515: Procedure chk_withdraw_reason
516: (p_withdraw_reason in irc_offer_status_history.decline_reason%TYPE,
517: p_effective_date in date
518: ) is
519: --
520: l_proc varchar2(72) := g_package || 'chk_withdraw_reason';

Line 522: l_decline_reason irc_offer_status_history.decline_reason%TYPE;

518: ) is
519: --
520: l_proc varchar2(72) := g_package || 'chk_withdraw_reason';
521: --
522: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
523:
524: --
525: begin
526: --

Line 565: 'IRC_OFFER_STATUS_HISTORY.DECLINE_REASON'

561: exception
562: when app_exception.application_exception then
563: if hr_multi_message.exception_add
564: (p_associated_column1=>
565: 'IRC_OFFER_STATUS_HISTORY.DECLINE_REASON'
566: ) then
567: hr_utility.set_location(' Leaving:'|| l_proc, 40);
568: raise;
569: end if;