[Home] [Help]
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 ;