[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;