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_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 EXISTS
744: (SELECT 1
745: FROM irc_offer_status_history iosh1

Line 745: FROM irc_offer_status_history iosh1

741: from irc_offer_status_history ios1
742: where ios1.offer_id = p_offer_id
743: and EXISTS
744: (SELECT 1
745: FROM irc_offer_status_history iosh1
746: WHERE iosh1.offer_id = ios1.offer_id
747: AND iosh1.status_change_date > ios1.status_change_date
748: )
749: AND ios1.offer_status_history_id =

Line 751: FROM irc_offer_status_history iosh2

747: AND iosh1.status_change_date > ios1.status_change_date
748: )
749: AND ios1.offer_status_history_id =
750: (SELECT MAX(iosh2.offer_status_history_id)
751: FROM irc_offer_status_history iosh2
752: WHERE iosh2.offer_id = ios1.offer_id
753: AND iosh2.status_change_date = ios1.status_change_date
754: )
755: AND 1 =

Line 757: FROM irc_offer_status_history ios3

753: AND iosh2.status_change_date = ios1.status_change_date
754: )
755: AND 1 =
756: (SELECT COUNT(*)
757: FROM irc_offer_status_history ios3
758: WHERE ios3.offer_id = ios1.offer_id
759: AND ios3.status_change_date > ios1.status_change_date
760: );
761: --

Line 771: ,irc_offer_status_history iosh

767: cursor csr_offer_count is
768: select count(*)
769: from irc_offers iof
770: ,per_all_vacancies pav
771: ,irc_offer_status_history iosh
772: where pav.vacancy_id = p_vacancy_id
773: and iof.vacancy_id = pav.vacancy_id
774: and iosh.offer_id = iof.offer_id
775: and iof.offer_id <> p_offer_id

Line 778: FROM irc_offer_status_history iosh1

774: and iosh.offer_id = iof.offer_id
775: and iof.offer_id <> p_offer_id
776: AND NOT EXISTS
777: (SELECT 1
778: FROM irc_offer_status_history iosh1
779: WHERE iosh1.offer_id = iosh.offer_id
780: AND iosh1.status_change_date > iosh.status_change_date
781: )
782: AND iosh.offer_status_history_id =

Line 784: FROM irc_offer_status_history iosh2

780: AND iosh1.status_change_date > iosh.status_change_date
781: )
782: AND iosh.offer_status_history_id =
783: (SELECT MAX(iosh2.offer_status_history_id)
784: FROM irc_offer_status_history iosh2
785: WHERE iosh2.offer_id = iosh.offer_id
786: AND iosh2.status_change_date = iosh.status_change_date
787: )
788: and iof.latest_offer = 'Y'

Line 2042: from irc_offer_status_history ios1

2038: l_mutiple_fields_updated boolean;
2039: --
2040: cursor csr_prev_to_prev_offer_status is
2041: select ios1.offer_status
2042: from irc_offer_status_history ios1
2043: where ios1.offer_id = p_current_offer_record.offer_id
2044: and EXISTS
2045: (SELECT 1
2046: FROM irc_offer_status_history iosh1

Line 2046: FROM irc_offer_status_history iosh1

2042: from irc_offer_status_history ios1
2043: where ios1.offer_id = p_current_offer_record.offer_id
2044: and EXISTS
2045: (SELECT 1
2046: FROM irc_offer_status_history iosh1
2047: WHERE iosh1.offer_id = ios1.offer_id
2048: AND iosh1.status_change_date > ios1.status_change_date
2049: )
2050: AND ios1.offer_status_history_id =

Line 2052: FROM irc_offer_status_history iosh2

2048: AND iosh1.status_change_date > ios1.status_change_date
2049: )
2050: AND ios1.offer_status_history_id =
2051: (SELECT MAX(iosh2.offer_status_history_id)
2052: FROM irc_offer_status_history iosh2
2053: WHERE iosh2.offer_id = ios1.offer_id
2054: AND iosh2.status_change_date = ios1.status_change_date
2055: )
2056: AND 1 =

Line 2058: FROM irc_offer_status_history ios3

2054: AND iosh2.status_change_date = ios1.status_change_date
2055: )
2056: AND 1 =
2057: (SELECT COUNT(*)
2058: FROM irc_offer_status_history ios3
2059: WHERE ios3.offer_id = ios1.offer_id
2060: AND ios3.status_change_date > ios1.status_change_date
2061: );
2062: --