DBA Data[Home] [Help]

APPS.EDR_PSIG dependencies on FND_TIMEZONES

Line 33: l_server_timezone :=fnd_timezones.GET_SERVER_TIMEZONE_CODE;

29:
30: BEGIN
31:
32: --Bug 4073809 : start
33: l_server_timezone :=fnd_timezones.GET_SERVER_TIMEZONE_CODE;
34: l_edr_timezone :=fnd_profile.VALUE('EDR_SERVER_TIMEZONE');
35: --Bug 4073809 : end
36:
37: /* Bug Fix 3225490 . Added new or condition to check null value for edr_timezone */

Line 2619: fnd_date.date_to_displayDT(psig.signature_timestamp,FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) as SIGNING_DATE,

2615: xmlforest(psig.signature_sequence as SIGNATURE_SEQUENCE,
2616: psig.user_name as SIGNER_USER_NAME,
2617: psig.user_display_name as SIGNER_DISPLAY_NAME,
2618: psig.user_response as SIGNER_RESPONSE,
2619: fnd_date.date_to_displayDT(psig.signature_timestamp,FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) as SIGNING_DATE,
2620: psig.SIGNATURE_OVERRIDING_COMMENTS as OVERRIDING_DETAILS,
2621: (select xmlagg(xmlelement("SIGNATURE_PARAMS",
2622: xmlforest(param1.name as PARAM_NAME,
2623: param1.value as PARAM_VALUE)