PACKAGE: APPS.PER_PERUSEOX_XMLP_PKG

Source

1 PACKAGE PER_PERUSEOX_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PERUSEOXS.pls 120.0 2007/12/28 06:59:32 srikrish noship $ */
3 	P_HIERARCHY_VERSION_ID	number;
4 	P_PAYROLL_PERIOD_DATE_START	varchar2(32767);
5 	P_PAYROLL_PERIOD_DATE_START_1 DATE;
6 	P_BUSINESS_GROUP_ID	number;
7 	P_HIERARCHY_ID	number;
8 	P_REPORT_YEAR	varchar2(4);
9 	P_PAYROLL_PERIOD_DATE_END	varchar2(32767);
10 	P_PAYROLL_PERIOD_DATE_END_1 DATE;
11 	P_PAYROLL_PERIOD_DATE	varchar2(32767);
12 	P_CONC_REQUEST_ID	number;
13 	P_AUDIT_REPORT	varchar2(1);
14 	CP_no_rows	number := 0 ;
15 	CP_Emp_Name	varchar2(150);
16 	CP_Emp_Num	varchar2(150);
17 	CP_Gender	varchar2(150);
18 	CP_Location	varchar2(500);
19 	CP_Job_Cat	varchar2(150);
20 	CP_Ethnic	varchar2(150);
21 	CP_Emp_Cat	varchar2(150);
22 	CP_ass_type	varchar2(60);
23 	CP_Reason	varchar2(500);
24 	CP_display	number ;
25 	c_business_group_name	varchar2(60);
26 	c_hierarchy_name	varchar2(40);
27 	c_hierarchy_version_num	number;
28 	c_parent_org_id	number;
29 	c_parent_node_id	number;
30 	c_ass_loc	number := 0 ;
31 	c_report_date	date;
32 	c_report_year	varchar2(4);
33 	function BeforeReport return boolean  ;
34 	function P_REPORT_YEARValidTrigger return boolean  ;
35 	function AfterReport return boolean  ;
36 	--function cf_set_detailsformula(person_id in number, report_date_end in date) return number  ;
37 	function cf_set_detailsformula(person_id1 in number, report_date_end in date, ASS_LOC in number, location_id in number, address1 in varchar2) return number;
38 	Function CP_no_rows_p return number;
39 	Function CP_Emp_Name_p return varchar2;
40 	Function CP_Emp_Num_p return varchar2;
41 	Function CP_Gender_p return varchar2;
42 	Function CP_Location_p return varchar2;
43 	Function CP_Job_Cat_p return varchar2;
44 	Function CP_Ethnic_p return varchar2;
45 	Function CP_Emp_Cat_p return varchar2;
46 	Function CP_ass_type_p return varchar2;
47 	Function CP_Reason_p return varchar2;
48 	Function CP_display_p return number;
49 	Function c_business_group_name_p return varchar2;
50 	Function c_hierarchy_name_p return varchar2;
51 	Function c_hierarchy_version_num_p return number;
52 	Function c_parent_org_id_p return number;
53 	Function c_parent_node_id_p return number;
54 	Function c_ass_loc_p return number;
55 	Function c_report_date_p return date;
56 	Function c_report_year_p return varchar2;
57 END PER_PERUSEOX_XMLP_PKG;