APPS.IRC_IOF_BUS dependencies on IRC_OFFER_STATUS_HISTORY

Line 727: l_prev_change_reason irc_offer_status_history.change_reason%TYPE;

723: --
724: l_proc varchar2(72) := g_package || 'chk_offers_exceeds_openings';
725: l_offer_count number(15);
726: l_prev_offer_status irc_offers.offer_status%TYPE;
727: l_prev_change_reason irc_offer_status_history.change_reason%TYPE;
728: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
729: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
730: l_chk_vacancy_count boolean := false;
731: --

Line 729: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;

725: l_offer_count number(15);
726: l_prev_offer_status irc_offers.offer_status%TYPE;
727: l_prev_change_reason irc_offer_status_history.change_reason%TYPE;
728: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
729: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
730: l_chk_vacancy_count boolean := false;
731: --
732: cursor csr_vacancy_opening_count is
733: select budget_measurement_value

Line 741: from irc_offer_status_history ios1

737: --
738: cursor csr_prev_to_prev_offer_chg_rsn is
739: select ios1.offer_status
740: ,ios1.change_reason
741: from irc_offer_status_history ios1
742: where ios1.offer_id = p_offer_id
743: and 1 = (select count(*)
744: from irc_offer_status_history ios2
745: where ios2.offer_id = p_offer_id

Line 744: from irc_offer_status_history ios2

740: ,ios1.change_reason
741: from irc_offer_status_history ios1
742: where ios1.offer_id = p_offer_id
743: and 1 = (select count(*)
744: from irc_offer_status_history ios2
745: where ios2.offer_id = p_offer_id
746: and ios2.offer_status_history_id > ios1.offer_status_history_id);
747: --
748: cursor csr_prev_offer_status is

Line 757: ,irc_offer_status_history iosh

753: cursor csr_offer_count is
754: select count(*)
755: from irc_offers iof
756: ,per_all_vacancies pav
757: ,irc_offer_status_history iosh
758: where pav.vacancy_id = p_vacancy_id
759: and iof.vacancy_id = pav.vacancy_id
760: and iosh.offer_status_history_id = (select max(offer_status_history_id) from irc_offer_status_history where offer_id = iof.offer_id)
761: and iof.latest_offer = 'Y'

Line 760: and iosh.offer_status_history_id = (select max(offer_status_history_id) from irc_offer_status_history where offer_id = iof.offer_id)

756: ,per_all_vacancies pav
757: ,irc_offer_status_history iosh
758: where pav.vacancy_id = p_vacancy_id
759: and iof.vacancy_id = pav.vacancy_id
760: and iosh.offer_status_history_id = (select max(offer_status_history_id) from irc_offer_status_history where offer_id = iof.offer_id)
761: and iof.latest_offer = 'Y'
762: and ( iof.offer_status = 'EXTENDED' or ( iof.offer_status = 'CLOSED' and iosh.change_reason = 'APL_ACCEPTED'));
763: --
764: l_vacancy_opening_count csr_vacancy_opening_count%ROWTYPE;

Line 2005: from irc_offer_status_history ios1

2001: l_mutiple_fields_updated boolean;
2002: --
2003: cursor csr_prev_to_prev_offer_status is
2004: select ios1.offer_status
2005: from irc_offer_status_history ios1
2006: where ios1.offer_id = p_current_offer_record.offer_id
2007: and 1 = (select count(*)
2008: from irc_offer_status_history ios2
2009: where ios2.offer_id = p_current_offer_record.offer_id

Line 2008: from irc_offer_status_history ios2

2004: select ios1.offer_status
2005: from irc_offer_status_history ios1
2006: where ios1.offer_id = p_current_offer_record.offer_id
2007: and 1 = (select count(*)
2008: from irc_offer_status_history ios2
2009: where ios2.offer_id = p_current_offer_record.offer_id
2010: and ios2.offer_status_history_id > ios1.offer_status_history_id);
2011: --
2012: begin