PACKAGE: APPS.SSP_SMPRPELR_XMLP_PKG

Source

1 PACKAGE SSP_SMPRPELR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: SMPRPELRS.pls 120.0 2007/12/24 14:05:03 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	date;
5 	AA_P_SESSION_DATE date;
6 	P_CONC_REQUEST_ID	number;
7 	P_PAYROLL_ID	number;
8 	P_CONSOLIDATION_SET	number;
9 	P_TIME_PERIOD_ID	number;
10 	P_SORT_OPTION	varchar2(60);
11 	P_SORT_OPTION_m	varchar2(60);
12 	C_BUSINESS_GROUP_NAME	varchar2(240);
13 	C_REPORT_SUBTITLE	varchar2(60);
14 	C_PAYROLL_NAME	varchar2(80);
15 	C_CONSOLIDATION_SET_NAME	varchar2(60);
16 	C_TIME_PERIOD_NAME	varchar2(35);
17 	C_SORT_OPTION	varchar2(60);
18 	function BeforeReport return boolean  ;
19 	function P_SORT_OPTIONValidTrigger return boolean  ;
20 	function C_SQL_TRACEFormula return VARCHAR2  ;
21 	function AfterReport return boolean  ;
22 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
23 	Function C_REPORT_SUBTITLE_p return varchar2;
24 	Function C_PAYROLL_NAME_p return varchar2;
25 	Function C_CONSOLIDATION_SET_NAME_p return varchar2;
26 	Function C_TIME_PERIOD_NAME_p return varchar2;
27 	Function C_SORT_OPTION_p return varchar2;
28 
29 	/*****************/
30 	/*Modified By Raj*/
31 	/*Additional Package Function*/
32 	function Derive_sort_criteria return varchar2;
33 	/*****************/
34 
35 END SSP_SMPRPELR_XMLP_PKG;