DBA Data[Home] [Help]

APPS.RRS_ATTR_PANE dependencies on FND_TIMEZONES

Line 1316: SELECT FROM_TZ(CAST(p_date AS TIMESTAMP), FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE

1312: --IF p_date IS NULL THEN
1313: --DBMS_OUTPUT.PUT_LINE('p_date is null at beginning');
1314: --END IF;
1315:
1316: SELECT FROM_TZ(CAST(p_date AS TIMESTAMP), FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE
1317: INTO l_timestamp
1318: FROM DUAL;
1319:
1320: --SELECT TO_TIMESTAMP(p_date) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE

Line 1320: --SELECT TO_TIMESTAMP(p_date) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE

1316: SELECT FROM_TZ(CAST(p_date AS TIMESTAMP), FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE
1317: INTO l_timestamp
1318: FROM DUAL;
1319:
1320: --SELECT TO_TIMESTAMP(p_date) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE
1321: -- INTO l_timestamp
1322: -- FROM DUAL;
1323:
1324: --IF p_date IS NULL THEN