PACKAGE BODY: APPS.SSP_SMPRPELR_XMLP_PKG

Source

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