PACKAGE BODY: APPS.HXT_HXT953A_XMLP_PKG

Source

1 PACKAGE BODY HXT_HXT953A_XMLP_PKG AS
2 /* $Header: HXT953AB.pls 120.0 2007/12/03 10:56:49 amakrish noship $ */
3 
4 function high1formula(TOT_HOURS in number, HIGH in number) return number is
5  HIGH1       NUMBER(8,2);
6 begin
7    IF NVL(TOT_HOURS,0) > NVL(HIGH,0) THEN
8    HIGH1 := NVL(TOT_HOURS,0) - NVL(HIGH,0);
9    ELSE
10       HIGH1 := 0;
11    END IF;
12    RETURN HIGH1;
13 end;
14 
15 function low1formula(TOT_HOURS in number, LOW in number) return number is
16    LOW1       NUMBER(8,2);
17 begin
18    IF NVL(TOT_HOURS,0) < NVL(LOW,0) THEN
19    LOW1 := NVL(LOW,0) - NVL(TOT_HOURS,0);
20    ELSE
21    LOW1 := 0;
22    END IF;
23    RETURN LOW1;
24 end;
25 
26 function average1formula(TOT_HOURS in number, AVERAGE in number) return number is
27    AVERAGE1       NUMBER(8,2);
28 begin
29    AVERAGE1 := NVL(TOT_HOURS,0) - NVL(AVERAGE,0);
30    RETURN AVERAGE1;
31 END;
32 
33 function BeforeReport return boolean is
34 begin
35 
36   /*SRW.USER_EXIT('FND SRWINIT');*/null;
37 
38 
39   if start_date is null then
40      start_date := hr_general.start_of_time;
41   end if;
42   if end_date is null then
43      end_date := hr_general.end_of_time;
44   end if;
45   return (TRUE);
46 end;
47 
48 function AfterReport return boolean is
49 begin
50 
51    /*SRW.USER_EXIT('FND SRWEXIT');*/null;
52 
53 
54   return (TRUE);
55 end;
56 
57 --Functions to refer Oracle report placeholders--
58 
59 END HXT_HXT953A_XMLP_PKG ;