DBA Data[Home] [Help]

APPS.ASO_UTILITY_PVT dependencies on FND_PROFILE

Line 485: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));

481: l_message_num := NULL;
482: IF l_id is not NULL
483: THEN
484: OPEN Get_Message_Num (l_message_name, l_id,
485: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));
486: FETCH Get_Message_Num into l_message_num;
487: CLOSE Get_Message_Num;
488: END IF;
489:

Line 5484: from fnd_profile_options

5480: IS
5481:
5482: cursor c_end_date is
5483: select end_date_active
5484: from fnd_profile_options
5485: where profile_option_name = p_profile_name
5486: and application_id = p_application_id
5487: and trunc(start_date_active) <= trunc(sysdate)
5488: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate);

Line 6156: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);

6152: aso_debug_pub.add( '***** Printing the profile values *****',1, 'Y' );
6153: aso_debug_pub.add( '******************************************',1, 'Y' );
6154: aso_debug_pub.add( ' ',1, 'Y' );
6155:
6156: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6157: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6158: fnd_profile.get('ORG_ID',l_org_id);
6159: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6160: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');

Line 6157: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);

6153: aso_debug_pub.add( '******************************************',1, 'Y' );
6154: aso_debug_pub.add( ' ',1, 'Y' );
6155:
6156: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6157: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6158: fnd_profile.get('ORG_ID',l_org_id);
6159: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6160: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');
6161: aso_debug_pub.add(rpad('ORG ID',50,'------')||'------>'||l_org_id , 1, 'Y');

Line 6158: fnd_profile.get('ORG_ID',l_org_id);

6154: aso_debug_pub.add( ' ',1, 'Y' );
6155:
6156: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6157: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6158: fnd_profile.get('ORG_ID',l_org_id);
6159: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6160: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');
6161: aso_debug_pub.add(rpad('ORG ID',50,'------')||'------>'||l_org_id , 1, 'Y');
6162: