APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on IRC_OFFER_STATUS_HISTORY

Line 45: from irc_offer_status_history ioh

41: CURSOR csr_get_offer_sent_date
42: (p_offer_id IN number)
43: IS
44: select max(ioh.status_change_date)
45: from irc_offer_status_history ioh
46: where ioh.offer_id = p_offer_id
47: and ioh.offer_status ='EXTENDED';
48:
49: -- ***************************************************************************

Line 486: -- only when the new row is inserted with 'EXTENDED' offer status in irc_offer_status_history table,

482: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
483: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,
484: '/offer_status_history/offer_status_history_id'));
485:
486: -- only when the new row is inserted with 'EXTENDED' offer status in irc_offer_status_history table,
487: -- proceed further
488: IF ( l_offer_status = 'EXTENDED') THEN
489:
490: hr_utility.set_location(l_proc, 30);

Line 1987: from irc_offer_status_history

1983: lookup_code = p_withdrawal_reason;
1984: --
1985: cursor csr_get_prev_offer_details (p_offer_status_history_id IN NUMBER,p_offer_id IN NUMBER) is
1986: select offer_status,change_reason
1987: from irc_offer_status_history
1988: where offer_id = p_offer_id
1989: and status_change_date = (select max(status_change_date)
1990: from irc_offer_status_history
1991: where offer_id = p_offer_id

Line 1990: from irc_offer_status_history

1986: select offer_status,change_reason
1987: from irc_offer_status_history
1988: where offer_id = p_offer_id
1989: and status_change_date = (select max(status_change_date)
1990: from irc_offer_status_history
1991: where offer_id = p_offer_id
1992: and offer_status_history_id <> p_offer_status_history_id);
1993: --
1994: CURSOR csr_get_name

Line 2362: from irc_offer_status_history

2358: lookup_code = p_decline_reason;
2359: --
2360: cursor csr_get_prev_offer_details (p_offer_status_history_id IN NUMBER,p_offer_id IN NUMBER) is
2361: select offer_status,change_reason
2362: from irc_offer_status_history
2363: where offer_id = p_offer_id
2364: and status_change_date = (select max(status_change_date)
2365: from irc_offer_status_history
2366: where offer_id = p_offer_id

Line 2365: from irc_offer_status_history

2361: select offer_status,change_reason
2362: from irc_offer_status_history
2363: where offer_id = p_offer_id
2364: and status_change_date = (select max(status_change_date)
2365: from irc_offer_status_history
2366: where offer_id = p_offer_id
2367: and offer_status_history_id <> p_offer_status_history_id);
2368: --
2369: CURSOR csr_get_name