DBA Data[Home] [Help]

APPS.XLE_LE_TIMEZONE_GRP dependencies on FND_PROFILE

Line 1300: G_ENABLE_LE_TIMEZONE := NVL(fnd_profile.value('XLE_ENABLE_LEGAL_ENTITY_TIMEZONE'),'N') ;

1296: -- Package initialization. Use to get/cache the Server timezone code,
1297: -- and other profile values
1298:
1299: -- check if Legal Entity Timezone conversion is enabled
1300: G_ENABLE_LE_TIMEZONE := NVL(fnd_profile.value('XLE_ENABLE_LEGAL_ENTITY_TIMEZONE'),'N') ;
1301: G_ENABLE_LE_TIMEZONE := 'N';
1302: -- If LE Timezone is enabled Get the server timezone code and timezone id
1303: IF G_ENABLE_LE_TIMEZONE = 'Y' THEN
1304: SELECT timezone_code ,

Line 1310: to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID')) ;

1306: INTO G_SERVER_TZ_CODE ,
1307: G_SERVER_TZ_ID
1308: FROM fnd_timezones_b
1309: WHERE upgrade_tz_id =
1310: to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID')) ;
1311:
1312: END IF ;
1313:
1314: END XLE_LE_TIMEZONE_GRP;