DBA Data[Home] [Help]

APPS.AS_JTF_RS_GROUP_MEM_TRG dependencies on FND_PROFILE

Line 45: l_opp_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_OPPORTUNITIES'),'OPEN'))));

41: AND status_code = 'SUBMITTED'
42: AND end_date_active is null;
43: BEGIN
44:
45: l_opp_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_OPPORTUNITIES'),'OPEN'))));
46: l_lead_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_SALES_LEADS'),'OPEN'))));
47:
48: IF(Trigger_Mode = 'ON-INSERT') THEN
49:

Line 46: l_lead_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_SALES_LEADS'),'OPEN'))));

42: AND end_date_active is null;
43: BEGIN
44:
45: l_opp_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_OPPORTUNITIES'),'OPEN'))));
46: l_lead_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_SALES_LEADS'),'OPEN'))));
47:
48: IF(Trigger_Mode = 'ON-INSERT') THEN
49:
50: IF(x_old_resource_id is null AND