[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| This function selects SYSDATE, converts it to the legal |
| entity timezone associated to the operating unit and removes|
| the timestamp returning the date with 00:00:00 for the time.|
| If the legal entity timezone is not setup then |
| TRUNC(SYSDATE) is returned. |
| |
| SCOPE - PUBLIC |
| |
| |
| ARGUMENTS : IN: p_ou_id |
| OUT: |
| |
| RETURNS : DATE |
| |
| NOTES |
| |
| MODIFICATION HISTORY |
| fdubois 29-sep-03 Created |
| rbasker 14-sep-05 Modified to call the XLE API. For R12, timezone |
| information comes from the new LE datamodel. |
| |
+===========================================================================*/
FUNCTION Get_Le_Sysdate_For_Ou
(p_ou_id IN NUMBER
)
RETURN DATE
IS
l_le_sysdate DATE := NULL;