DBA Data[Home] [Help]

APPS.IRC_OFFERS_API dependencies on FND_PROFILE

Line 2846: if 'N' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')

2842: --
2843: if l_offer_status = 'EXTENDED'
2844: then
2845: --
2846: if 'N' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
2847: OR 'E' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
2848: OR fnd_profile.value('IRC_ALLOW_MULTI_OFFERS') is null
2849: then
2850: --

Line 2847: OR 'E' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')

2843: if l_offer_status = 'EXTENDED'
2844: then
2845: --
2846: if 'N' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
2847: OR 'E' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
2848: OR fnd_profile.value('IRC_ALLOW_MULTI_OFFERS') is null
2849: then
2850: --
2851: other_extended_offers_count

Line 2848: OR fnd_profile.value('IRC_ALLOW_MULTI_OFFERS') is null

2844: then
2845: --
2846: if 'N' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
2847: OR 'E' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
2848: OR fnd_profile.value('IRC_ALLOW_MULTI_OFFERS') is null
2849: then
2850: --
2851: other_extended_offers_count
2852: ( p_applicant_assignment_id => l_prev_applicant_assignment_id

Line 3711: if fnd_profile.value('IRC_AGENCY_NAME') is not null then

3707: else
3708: l_manager_terminates:='Y';
3709: end if;
3710: --
3711: if fnd_profile.value('IRC_AGENCY_NAME') is not null then
3712: --
3713: l_change_reason := 'AGENCY_TERMINATE_APPL';
3714: --
3715: elsif l_manager_terminates = 'Y' then

Line 4150: if 'N' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')

4146: AND l_prev_to_prev_change_reason = 'APL_ACCEPTED'
4147: )
4148: then
4149: --
4150: if 'N' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
4151: OR 'E' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
4152: OR fnd_profile.value('IRC_ALLOW_MULTI_OFFERS') is null
4153: then
4154: --

Line 4151: OR 'E' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')

4147: )
4148: then
4149: --
4150: if 'N' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
4151: OR 'E' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
4152: OR fnd_profile.value('IRC_ALLOW_MULTI_OFFERS') is null
4153: then
4154: --
4155: -- This happens when an offer which was previously EXTENDED or was CLOSED and ACCEPTED

Line 4152: OR fnd_profile.value('IRC_ALLOW_MULTI_OFFERS') is null

4148: then
4149: --
4150: if 'N' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
4151: OR 'E' = fnd_profile.value('IRC_ALLOW_MULTI_OFFERS')
4152: OR fnd_profile.value('IRC_ALLOW_MULTI_OFFERS') is null
4153: then
4154: --
4155: -- This happens when an offer which was previously EXTENDED or was CLOSED and ACCEPTED
4156: -- is being taken off Hold.