DBA Data[Home] [Help]

PACKAGE: APPS.PER_PERFRD2R_XMLP_PKG

Source


1 PACKAGE PER_PERFRD2R_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PERFRD2RS.pls 120.0 2007/12/24 13:18:32 amakrish noship $ */
3 	P_ESTABLISHMENT_ID	number;
4 	P_YEAR_FIRST_OBLIGATION	number;
5 	P_YEAR	number;
6 	PC_1JAN	date;
7 	PC_31DEC	date;
8 	PC_31DEC_m varchar2(11);
9 	P_CONC_REQUEST_ID	number;
10 	PC_HIRE_YEAR	number;
11 	PC_YEAR_BECAME_PERMANENT	number;
12 	PC_JOB_TITLE	varchar2(240);
13 	PC_HOURS_TRAINING	number;
14 	PC_PCS_CODE	varchar2(32767);
15 	PC_UNITS_TOTAL	number;
16 	PC_UNITS_COEF	number;
17 	PC_UNITS_ACTUAL	number;
18 	PC_DISABLED_WHERE_CLAUSE	varchar2(32000);
19 	PC_HEADCOUNT_OBLIGATION	number;
20 	PC_HEADCOUNT_PARTICULAR	number;
21 	PC_BASIS_OBLIGATION	number;
22 	PC_OBLIGATION	number;
23 	PC_BREAKDOWN_PARTICULAR	varchar2(32000) := 'select ''00000000000000000000'' pc, 0 ph from dual' ;
24 	PC_COUNT_DISABLED	varchar2(32000) := '0=0;' ;
25 	function c_set_unitsformula(cotorep_category in varchar2, age in number, previous_cotorep in varchar2, disability_rate in number, due_to_wa in varchar2, disability_class_code in varchar2, pid in number) return number  ;
26 	function AfterPForm return boolean  ;
27 	function BeforeReport return boolean  ;
28 	function fc_set_job_infoformula(pid in number) return number  ;
29 	function g_disabled_empgroupfilter(disability_start_date in date, disability_end_date in date) return boolean  ;
30 	function AfterReport return boolean  ;
31 	Function PC_HIRE_YEAR_p return number;
32 	Function PC_YEAR_BECAME_PERMANENT_p return number;
33 	Function PC_JOB_TITLE_p return varchar2;
34 	Function PC_HOURS_TRAINING_p return number;
35 	Function PC_PCS_CODE_p return varchar2;
36 	Function PC_UNITS_TOTAL_p return number;
37 	Function PC_UNITS_COEF_p return number;
38 	Function PC_UNITS_ACTUAL_p return number;
39 	Function PC_DISABLED_WHERE_CLAUSE_p return varchar2;
40 	Function PC_HEADCOUNT_OBLIGATION_p return number;
41 	Function PC_HEADCOUNT_PARTICULAR_p return number;
42 	Function PC_BASIS_OBLIGATION_p return number;
43 	Function PC_OBLIGATION_p return number;
44 	Function PC_BREAKDOWN_PARTICULAR_p return varchar2;
45 	Function PC_COUNT_DISABLED_p return varchar2;
46 END PER_PERFRD2R_XMLP_PKG;