[Home] [Help]
PACKAGE: APPS.PER_PAYRPEMV_XMLP_PKG
Source
1 PACKAGE PER_PAYRPEMV_XMLP_PKG 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;