PACKAGE: APPS.AD_CORE

Source

1 package ad_core AUTHID CURRENT_USER as
2 /* $Header: aducores.pls 115.1 2003/05/22 19:01:12 kksingh noship $ */
3 
4 -- Given an elapsed time in days (such as that returned by subtracting 2
5 -- dates in SQL), return the formatted value in Hrs/Mins/Secs.
6 --   Supported format_modes: 1, 2
7 --     1 => Always display hrs, min, secs
8 --       eg: 0.00030093 days is displayed as 0 Hrs, 0 Mins, 26 Secs
9 --     2 => Only display applicable units
10 --       eg: 0.00030093 days is displayed as 26 Secs
11 
12 function get_formatted_elapsed_time
13 (
14   p_ela_days number,
15   p_format_mode number
16 ) return varchar2;
17 
18 pragma restrict_references (get_formatted_elapsed_time, wnds, rnds,
19                                                         wnps, rnps);
20 
21 end ad_core;