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.HR_WORKFLOW_SERVICE dependencies on IRC_OFFERS

Line 2168: irc_offers iof

2164: select hat.transaction_ref_id,
2165: hat.assignment_id,
2166: iof.offer_status
2167: from hr_api_transactions hat,
2168: irc_offers iof
2169: where hat.transaction_ref_table='IRC_OFFERS' and
2170: hat.transaction_ref_id = iof.offer_id and
2171: hat.transaction_id = c_transaction_id and
2172: iof.offer_status in ('PENDING','CORRECTION');

Line 2169: where hat.transaction_ref_table='IRC_OFFERS' and

2165: hat.assignment_id,
2166: iof.offer_status
2167: from hr_api_transactions hat,
2168: irc_offers iof
2169: where hat.transaction_ref_table='IRC_OFFERS' and
2170: hat.transaction_ref_id = iof.offer_id and
2171: hat.transaction_id = c_transaction_id and
2172: iof.offer_status in ('PENDING','CORRECTION');
2173:

Line 2239: irc_offers_api.close_offer(p_effective_date => sysdate

2235: hr_utility.set_location ('Offer ID : '||l_offer_id,430);
2236: hr_utility.set_location ('Applicant Assignment ID : '||l_applicant_assignment_id,445);
2237: hr_utility.set_location ('Offer Status : '||l_offer_status,460);
2238:
2239: irc_offers_api.close_offer(p_effective_date => sysdate
2240: , p_applicant_assignment_id => l_applicant_assignment_id
2241: , p_offer_id => l_offer_id
2242: , p_change_reason => 'MANUAL_CLOSURE'
2243: , p_note_text => 'Closed from Complete Defunct Workflow Process');