[Home] [Help]
PACKAGE BODY: APPS.PAY_PYGBNICV_XMLP_PKG
Source
1 PACKAGE BODY PAY_PYGBNICV_XMLP_PKG AS
2 /* $Header: PYGBNICVB.pls 120.2 2007/12/27 05:27:24 amakrish noship $ */
3
4
5 function BeforeReport return boolean is
6 begin
7
8 /*srw.user_exit('FND SRWINIT');*/null;
9
10
11 c_payroll_name := hr_reports.get_payroll_name(sysdate,p_payroll_name);
12
13 c_business_group_name :=
14 hr_reports.get_business_group(p_business_group_id);
15
16 p_sort := ' ORDER BY ' || p_sort_order;
17
18 begin
19 select consolidation_set_name
20 into c_consolidation_set
21 from pay_consolidation_sets
22 where consolidation_set_id = p_consolidation_set;
23 exception
24 when no_data_found then
25 null;
26 end;
27
28 begin
29 select assignment_set_name
30 into c_assignment_set
31 from hr_assignment_sets
32 where assignment_set_id = p_assignment_set;
33 exception
34 when no_data_found then
35 null;
36 end;
37 LP_EFFECTIVE_DATE := P_EFFECTIVE_DATE;
38 return (TRUE);
39
40 end;
41
42 function AfterReport return boolean is
43 begin
44 /*srw.user_exit('FND SRWEXIT');*/null;
45
46 return (TRUE);
47 end;
48
49 --Functions to refer Oracle report placeholders--
50
51 Function C_BUSINESS_GROUP_NAME_p return varchar2 is
52 Begin
53 return C_BUSINESS_GROUP_NAME;
54 END;
55 Function C_REPORT_SUBTITLE_p return varchar2 is
56 Begin
57 return C_REPORT_SUBTITLE;
58 END;
59 Function C_PAYROLL_NAME_p return varchar2 is
60 Begin
61 return C_PAYROLL_NAME;
62 END;
63 Function C_CONSOLIDATION_SET_p return varchar2 is
64 Begin
65 return C_CONSOLIDATION_SET;
66 END;
67 Function C_ASSIGNMENT_SET_p return varchar2 is
68 Begin
69 return C_ASSIGNMENT_SET;
70 END;
71 END PAY_PYGBNICV_XMLP_PKG ;