[Home] [Help]
PACKAGE: APPS.SSP_SMPRPELR_XMLP_PKG
Source
1 PACKAGE SSP_SMPRPELR_XMLP_PKG 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;