DBA Data[Home] [Help]

PACKAGE: APPS.PAY_PYGBNSEX_XMLP_PKG

Source


1 PACKAGE PAY_PYGBNSEX_XMLP_PKG AS
2 /* $Header: PYGBNSEXS.pls 120.2 2007/12/27 05:28:27 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_TAX_REF	varchar2(14);
5 	P_PAYROLL_ID	number;
6 	P_EFFECTIVE_DATE	date;
7 	/* added as fix */
8 	P_EFFECTIVE_DATE_T date;
9 	P_STARTERS_FROM	date;
10 		CP_EFFECTIVE_DATE_T date;
11 		CP_STARTERS_FROM	date;
12 	P_CONC_REQUEST_ID	number;
13 	C_BUSINESS_GROUP_NAME	varchar2(240);
14 	C_ORDER_BY	varchar2(30) := 'last_name' ;
15 	C_HEAD_ORDER_BY	varchar2(30);
16 	C_PAYROLL_NAME	varchar2(80);
17 	function BeforeReport return boolean  ;
18 	function AfterReport return boolean  ;
19 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
20 	Function C_ORDER_BY_p return varchar2;
21 	Function C_HEAD_ORDER_BY_p return varchar2;
22 	Function C_PAYROLL_NAME_p return varchar2;
23 END PAY_PYGBNSEX_XMLP_PKG;