DBA Data[Home] [Help]

PACKAGE: APPS.PER_PERFRMMO_XMLP_PKG

Source


1 PACKAGE PER_PERFRMMO_XMLP_PKG AS
2 /* $Header: PERFRMMOS.pls 120.1 2008/03/06 10:34:11 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	varchar2(25);
4 	P_SESSION_DATE	date := to_date('31-03-2000','DD-MM-YYYY');
5 	P_ESTABLISHMENT_ID	number;
6 	P_PERIOD_START_DATE	date :=  to_date('31-01-2000','DD-MM-YYYY');
7 	P_PERIOD_END_DATE	date :=  to_date('31-03-2000','DD-MM-YYYY');
8 	P_INCLUDE_SUSPENDED	varchar2(1);
9 	P_CONC_REQUEST_ID	number;
10 	C_COUNT_PREVIOUS_PERIOD	number;
11 	C_COUNT_PERIOD	number;
12 	C_COUNT_MEN	number;
13 	C_COUNT_WOMEN	number;
14 	C_TEMPORARY	number;
15 	C_JOB	varchar2(40);
16 	C_JOB_PCS	varchar2(32767);
17 	C_START_REASON	varchar2(2);
18 	C_END_REASON	varchar2(2);
19 	C_CHECK_STARTED	number;
20 	C_CHECK_LEFT	number;
21 	C_EFFECTIVE_START_DATE	date;
22 	P_FORMULA_ID	number;
23 	function CF_GET_HEADERFormula return Number  ;
24 	function BeforeReport return boolean  ;
25 	function c_get_nationalityformula(NATIONALITY in varchar2) return varchar2  ;
26 	function c_get_asgformula(PERSON_ID1 in number, START_DATE in date, END_DATE in date) return number  ;
27 	function AfterReport return boolean  ;
28 	Function C_COUNT_PREVIOUS_PERIOD_p return number;
29 	Function C_COUNT_PERIOD_p return number;
30 	Function C_COUNT_MEN_p return number;
31 	Function C_COUNT_WOMEN_p return number;
32 	Function C_TEMPORARY_p return number;
33 	Function C_JOB_p return varchar2;
34 	Function C_JOB_PCS_p return varchar2;
35 	Function C_START_REASON_p return varchar2;
36 	Function C_END_REASON_p return varchar2;
37 	Function C_CHECK_STARTED_p return number;
38 	Function C_CHECK_LEFT_p return number;
39 	Function C_EFFECTIVE_START_DATE_p return date;
40 	Function P_FORMULA_ID_p return number;
41 END PER_PERFRMMO_XMLP_PKG;