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 ;