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 338: -- only when the new row is inserted with 'EXTENDED' offer status in irc_offer_status_history table,

334: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
335: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,
336: '/offer_status_history/offer_status_history_id'));
337:
338: -- only when the new row is inserted with 'EXTENDED' offer status in irc_offer_status_history table,
339: -- proceed further
340: IF ( l_offer_status = 'EXTENDED') THEN
341:
342: hr_utility.set_location(l_proc, 30);

Line 1366: from irc_offer_status_history

1362: lookup_code = p_withdrawal_reason;
1363: --
1364: cursor csr_get_prev_offer_details (p_offer_status_history_id IN NUMBER,p_offer_id IN NUMBER) is
1365: select offer_status,change_reason
1366: from irc_offer_status_history
1367: where offer_id = p_offer_id
1368: and status_change_date = (select max(status_change_date)
1369: from irc_offer_status_history
1370: where offer_id = p_offer_id

Line 1369: from irc_offer_status_history

1365: select offer_status,change_reason
1366: from irc_offer_status_history
1367: where offer_id = p_offer_id
1368: and status_change_date = (select max(status_change_date)
1369: from irc_offer_status_history
1370: where offer_id = p_offer_id
1371: and offer_status_history_id <> p_offer_status_history_id);
1372: --
1373: CURSOR csr_get_name

Line 1672: from irc_offer_status_history

1668: lookup_code = p_decline_reason;
1669: --
1670: cursor csr_get_prev_offer_details (p_offer_status_history_id IN NUMBER,p_offer_id IN NUMBER) is
1671: select offer_status,change_reason
1672: from irc_offer_status_history
1673: where offer_id = p_offer_id
1674: and status_change_date = (select max(status_change_date)
1675: from irc_offer_status_history
1676: where offer_id = p_offer_id

Line 1675: from irc_offer_status_history

1671: select offer_status,change_reason
1672: from irc_offer_status_history
1673: where offer_id = p_offer_id
1674: and status_change_date = (select max(status_change_date)
1675: from irc_offer_status_history
1676: where offer_id = p_offer_id
1677: and offer_status_history_id <> p_offer_status_history_id);
1678: --
1679: CURSOR csr_get_name