APPS.IRC_IOF_BUS dependencies on IRC_OFFERS_API

Line 1565: applicant_assignment_id = nvl(irc_offers_api.g_src_apl_asg_id,-1)

1561: select nvl(max(offer_version),0) + 1
1562: from irc_offers
1563: where ( applicant_assignment_id = nvl(p_applicant_assignment_id,-1)
1564: OR
1565: applicant_assignment_id = nvl(irc_offers_api.g_src_apl_asg_id,-1)
1566: OR
1567: applicant_assignment_id in
1568: (
1569: select tgt_apl_asg_id from per_vac_linked_assignments

Line 1570: where src_apl_asg_id = irc_offers_api.g_src_apl_asg_id

1566: OR
1567: applicant_assignment_id in
1568: (
1569: select tgt_apl_asg_id from per_vac_linked_assignments
1570: where src_apl_asg_id = irc_offers_api.g_src_apl_asg_id
1571: )
1572: );
1573:
1574: --

Line 2009: -- checked for offer_status 'CLOSED' in update_offer procedure of irc_offers_api.

2005: --
2006: -- Description:
2007: -- This procedure ensures the following:
2008: -- 1) If the offer_status is 'CLOSED' do nothing - This is because we have already
2009: -- checked for offer_status 'CLOSED' in update_offer procedure of irc_offers_api.
2010: --
2011: -- 2) If the offer is in 'HOLD' state now, and the offer_status was previously 'HOLD'
2012: -- too, throw an error saying that an offer in HOLD status cannot be updated.
2013: --