PACKAGE BODY: APPS.HXT_HXT964A_XMLP_PKG

Source

1 PACKAGE BODY HXT_HXT964A_XMLP_PKG AS
2 /* $Header: HXT964AB.pls 120.0 2007/12/03 11:47:15 amakrish noship $ */
3 
4 function CF_PeriodFormula return VARCHAR2 is
5  payroll  VARCHAR2(240);
6  start_d  date;
7  end_d    date;
8 
9 begin
10  select  payroll_name || '   ' || to_char(ptp.start_date, 'YYYY/MM/DD') || '  -  ' || to_char(ptp.end_date, 'YYYY/MM/DD')
11  into    payroll
12 from per_time_periods ptp, pay_payrolls_f pay
13 where ptp.time_period_id = P_TIME_PERIOD_ID
14 and (sysdate between pay.effective_start_date
15     and pay.effective_end_date)
16 and  (ptp.payroll_id = pay.payroll_id);
17 
18 -- return (payroll||'   '||to_char(start_d,'YYYY/MM/DD')||'   '||to_char(end_d,'YYYY/MM/DD'));
19 return (payroll);
20 
21 end;
22 
23 function BeforeReport return boolean is
24 begin
25 
26   /*SRW.USER_EXIT('FND SRWINIT');*/null;
27 
28 
29   return (TRUE);
30 end;
31 
32 function AfterReport return boolean is
33 begin
34   /*SRW.USER_EXIT('FND SRWEXIT');*/null;
35 
36 
37   return (TRUE);
38 end;
39 
40 --Functions to refer Oracle report placeholders--
41 
42 END HXT_HXT964A_XMLP_PKG ;