PACKAGE: APPS.PER_PAYRPEMV_XMLP_PKG

Source

1 PACKAGE PER_PAYRPEMV_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYRPEMVS.pls 120.1 2007/12/06 11:24:44 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	date;
5 	P_REPORT_TITLE	varchar2(60);
6 	P_CONC_REQUEST_ID	number;
7 	P_ORG_STRUCTURE_ID	number;
8 	P_ORG_STRUCTURE_VERSION_ID	number;
9 	P_PARENT_ORGANIZATION_ID	number;
10 	P_DATE_FROM	date;
11 	P_DATE_TO	date;
12 	P_DATE_FROM_T varchar2(25);
13 	P_DATE_TO_T varchar2(25);
14 	P_PAYROLL_ID	number;
15 	P_PAYROLL_PERIOD_ID	number;
16 	P_ORG_MATCHING	varchar2(500);
17 	P_PAYROLL_MATCHING	varchar2(500);
18 	P_DATES_MATCHING	varchar2(500);
19 	P_DATES_MATCHING2	varchar2(500);
20 	--P_DATES_MATCHING3	varchar2(500); Commented during DT Fix
21 	--P_DATES_MATCHING4	varchar2(500); Commented during DT Fix
22 	--P_DATES_MATCHING5	varchar2(500); Commented during DT Fix
23         P_DATES_MATCHING3	varchar2(500) := 'is not null';
24         P_DATES_MATCHING4	varchar2(500) := '''12314712''';
25         P_DATES_MATCHING5	varchar2(500) := '''12314712''';
26 	P_EMPLOYEE_DETAIL	varchar2(50);
27 	P_EMP_ORD_CLAUSE	varchar2(150);
28 	P_ORG_MATCHING2	varchar2(500);
29 	P_ORG_MATCHING3	varchar2(500);
30 	P_PAYROLL_MATCHING2	varchar2(500);
31 	P_PAYROLL_MATCHING3	varchar2(500);
32 	P_TRACE	varchar2(32767);
33 	P_worker_type	varchar2(100) := 'E';
34 	C_BUSINESS_GROUP_NAME	varchar2(240);
35 	C_REPORT_SUBTITLE	varchar2(60);
36 	C_ORG_STRUCTURE_NAME	varchar2(80);
37 	C_VERSION_NUMBER	number;
38 	C_PARENT_ORGANIZATION_NAME	varchar2(240);
39 	C_PAYROLL_NAME	varchar2(80);
40 	C_PAYROLL_PERIOD	varchar2(80);
41 	C_emp_det_param_disp	varchar2(80);
42 	CP_worker_type_desc	varchar2(80);
43 	CP_total_emp_newhire	number := 0 ;
44 	CP_total_cwk_newhire	number := 0 ;
45 	CP_total_emp_term	number := 0 ;
46 	CP_total_cwk_term	number := 0 ;
47 	CP_total_emp_transin	number := 0 ;
48 	CP_total_cwk_transin	number := 0 ;
49 	CP_total_emp_transout	number := 0 ;
50 	CP_total_cwk_transout	number := 0 ;
51 	function BeforeReport return boolean  ;
52 	function c_net_changeformula(c_new_hires_count in number, c_transfers_in in number, c_terminations_count in number, c_transfers_out in number) return varchar2  ;
53 	function C_sql_traceFormula return VARCHAR2  ;
54 	function TRACEFormula return VARCHAR2  ;
55 	function cf_control_total_newhireformul(new_hire_asg_type in varchar2, assignment_type in varchar2) return number  ;
56 	function cf_control_total_termformula(term_asg_type in varchar2) return number  ;
57 	function cf_control_total_transinformul(trans_ex_asg_type in varchar2) return number  ;
58 	function cf_control_total_transoutformu(transout_ex_asg_type in varchar2) return number  ;
59 	function AfterReport return boolean  ;
60 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
61 	Function C_REPORT_SUBTITLE_p return varchar2;
62 	Function C_ORG_STRUCTURE_NAME_p return varchar2;
63 	Function C_VERSION_NUMBER_p return number;
64 	Function C_PARENT_ORGANIZATION_NAME_p return varchar2;
65 	Function C_PAYROLL_NAME_p return varchar2;
66 	Function C_PAYROLL_PERIOD_p return varchar2;
67 	Function C_emp_det_param_disp_p return varchar2;
68 	Function CP_worker_type_desc_p return varchar2;
69 	Function CP_total_emp_newhire_p return number;
70 	Function CP_total_cwk_newhire_p return number;
71 	Function CP_total_emp_term_p return number;
72 	Function CP_total_cwk_term_p return number;
73 	Function CP_total_emp_transin_p return number;
74 	Function CP_total_cwk_transin_p return number;
75 	Function CP_total_emp_transout_p return number;
76 	Function CP_total_cwk_transout_p return number;
77 END PER_PAYRPEMV_XMLP_PKG;