PACKAGE BODY: APPS.SSP_SSPRPELR_XMLP_PKG

Source

1 PACKAGE BODY SSP_SSPRPELR_XMLP_PKG AS
2 /* $Header: SSPRPELRB.pls 120.1 2007/12/24 14:05:21 amakrish noship $ */
3 
4 function BeforeReport return boolean is
5 begin
6 DECLARE
7   P_SORT boolean;
8  BEGIN
9   /*srw.user_exit('FND SRWINIT');*/null;
10  P_SORT := P_SORT_OPTIONValidTrigger;
11   C_SORT_OPTION := P_SORT_OPTION;
12 
13   select payroll_name
14   into c_payroll_name
15   from pay_payrolls_x
16   where payroll_id = p_payroll_id;
17 
18   c_business_group_name :=
19      hr_reports.get_business_group(p_business_group_id);
20 
21 	select ptp.period_name
22 	into c_time_period_name
23 	from per_time_periods ptp
24 	where ptp.time_period_id = p_time_period_id;
25 
26   select pcs.consolidation_set_name
27   into c_consolidation_set_name
28   from pay_consolidation_sets pcs
29   where pcs.consolidation_set_id = p_consolidation_set;
30 
31  EXCEPTION WHEN NO_DATA_FOUND THEN null;
32  END;
33 return (TRUE);
34 end;
35 
36 function P_SORT_OPTIONValidTrigger return boolean is
37 begin
38 
39 P_SORT_OPTION_1 := Derive_sort_criteria;  return (TRUE);
40 end;
41 function Derive_sort_criteria return varchar2 is
42 begin
43  if P_SORT_OPTION = 'Assignment Number' then
44     return( 'Order By assignment_number');
45  elsif  P_SORT_OPTION = 'Employee Name' then
46     return( 'Order By  employee_name,assignment_number');
47  else
48      return( 'Order By assignment_number');
49  end if;
50 
51 RETURN NULL; end Derive_sort_criteria;
52 
53 function AfterReport return boolean is
54 begin
55   /*srw.user_exit('FND SRWEXIT');*/null;
56 
57   return (TRUE);
58 end;
59 
60 --Functions to refer Oracle report placeholders--
61 
62  Function C_BUSINESS_GROUP_NAME_p return varchar2 is
63 	Begin
64 	 return C_BUSINESS_GROUP_NAME;
65 	 END;
66  Function C_REPORT_SUBTITLE_p return varchar2 is
67 	Begin
68 	 return C_REPORT_SUBTITLE;
69 	 END;
70  Function C_PAYROLL_NAME_p return varchar2 is
71 	Begin
72 	 return C_PAYROLL_NAME;
73 	 END;
74  Function C_CONSOLIDATION_SET_NAME_p return varchar2 is
75 	Begin
76 	 return C_CONSOLIDATION_SET_NAME;
77 	 END;
78  Function C_TIME_PERIOD_NAME_p return varchar2 is
79 	Begin
80 	 return C_TIME_PERIOD_NAME;
81 	 END;
82  Function C_SORT_OPTION_p return varchar2 is
83 	Begin
84 	 return C_SORT_OPTION;
85 	 END;
86 END SSP_SSPRPELR_XMLP_PKG ;