eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_HXT959A_XMLP_PKG dependencies on STANDARD

Line 4: function cf_tot_varformula(STANDARD_START in number, TIME_IN in date) return varchar2 is

1: PACKAGE BODY HXT_HXT959A_XMLP_PKG AS
2: /* $Header: HXT959AB.pls 120.0 2007/12/03 11:43:55 amakrish noship $ */
3:
4: function cf_tot_varformula(STANDARD_START in number, TIME_IN in date) return varchar2 is
5:
6:
7: CF_RET VARCHAR2 (20);
8: CF_DATE_WORKED_TIME VARCHAR2(20);

Line 17: IF (STANDARD_START is not null) AND (TIME_IN is not null) THEN

13:
14: begin
15:
16:
17: IF (STANDARD_START is not null) AND (TIME_IN is not null) THEN
18: CF_DATE1 := to_date('01-01-1900 '||to_char(TIME_IN, 'HH24MI'), 'DD-MM-YYYY HH24MI');
19: CF_DATE2 := to_date('01-01-1900 '||to_char(STANDARD_START,'0009'), 'DD-MM-YYYY HH24MI');
20:
21: CF_RET := reset_hours(CF_DATE1, CF_DATE2);

Line 19: CF_DATE2 := to_date('01-01-1900 '||to_char(STANDARD_START,'0009'), 'DD-MM-YYYY HH24MI');

15:
16:
17: IF (STANDARD_START is not null) AND (TIME_IN is not null) THEN
18: CF_DATE1 := to_date('01-01-1900 '||to_char(TIME_IN, 'HH24MI'), 'DD-MM-YYYY HH24MI');
19: CF_DATE2 := to_date('01-01-1900 '||to_char(STANDARD_START,'0009'), 'DD-MM-YYYY HH24MI');
20:
21: CF_RET := reset_hours(CF_DATE1, CF_DATE2);
22: if (to_number(CF_RET) = 0) then
23: return (NULL);

Line 33: function cf_l_vlformula(STANDARD_START in number, TIME_IN in date) return varchar2 is

29: end if;
30:
31: RETURN NULL; end;
32:
33: function cf_l_vlformula(STANDARD_START in number, TIME_IN in date) return varchar2 is
34:
35: CF_RET VARCHAR2 (20);
36: CF_RET_NUM NUMBER;
37: CF_DATE_WORKED_TIME VARCHAR2(20);

Line 47: IF (STANDARD_START is not null) AND (TIME_IN is not null) THEN

43: begin
44:
45:
46:
47: IF (STANDARD_START is not null) AND (TIME_IN is not null) THEN
48: CF_DATE1 := to_date('01-01-1900 '||to_char(TIME_IN, 'HH24MI'), 'DD-MM-YYYY HH24MI');
49: CF_DATE2 := to_date('01-01-1900 '||to_char(STANDARD_START,'0009'), 'DD-MM-YYYY HH24MI');
50:
51: CF_RET := reset_hours(CF_DATE1, CF_DATE2);

Line 49: CF_DATE2 := to_date('01-01-1900 '||to_char(STANDARD_START,'0009'), 'DD-MM-YYYY HH24MI');

45:
46:
47: IF (STANDARD_START is not null) AND (TIME_IN is not null) THEN
48: CF_DATE1 := to_date('01-01-1900 '||to_char(TIME_IN, 'HH24MI'), 'DD-MM-YYYY HH24MI');
49: CF_DATE2 := to_date('01-01-1900 '||to_char(STANDARD_START,'0009'), 'DD-MM-YYYY HH24MI');
50:
51: CF_RET := reset_hours(CF_DATE1, CF_DATE2);
52: CF_RET_NUM := to_number (CF_RET);
53: if (CF_RET_NUM >= 0) then