1 PACKAGE PER_PERHDCNT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PERHDCNTS.pls 120.1 2007/12/06 11:27:10 amakrish noship $ */
3 P_REPORT_DATE_FROM date;
4 P_REPORT_DATE_TO date;
5 P_TOP_ORGANIZATION_ID number;
6 P_ORGANIZATION_STRUCTURE_ID number;
7 P_BUSINESS_GROUP_ID number;
8 P_REPORT_DATE date;
9 P_ROLL_UP varchar2(32767);
10 P_BUDGET varchar2(32767);
11 P_JOB_CATEGORY varchar2(32767);
12 P_INCLUDE_TOP_ORG varchar2(32767);
13 P_INCLUDE_ASG_TYPE varchar2(32767);
14 P_DAYS_PRIOR_TO_END_DATE number;
15 P_WORKER_TYPE varchar2(32767);
16 P_CONC_REQUEST_ID number;
17 CP_BUSINESS_GROUP_NAME varchar2(240);
18 CP_TOP_ORG_NAME varchar2(240);
19 CP_ORGANIZATION_HIERARCHY_NAME varchar2(60);
20 CP_NULL number;
21 CP_TERM varchar2(20);
22 CP_NH varchar2(30);
23 CP_NH1 varchar2(20);
24 CP_TERM1 varchar2(20);
25 CP_WORKER_TYPE varchar2(50);
26 function BeforeReport return boolean ;
27 function cf_rev_vol_termformula(cs_rev_vol_term in number, Sumrev_start_valPerorg_structu in number) return number ;
28 function cf_nonrev_vol_termformula(cs_nonrev_vol_term in number, Sumnonrev_start_valPerorg_stru in number) return number ;
29 function cf_rev_invol_termformula(cs_nonrev_invol_term in number, Sumnonrev_start_valPerorg_stru in number) return number ;
30 function cf_rev_invol_termformula0017(cs_rev_invol_term in number, Sumrev_start_valPerorg_structu in number) return number ;
31 function cf_rev_cur_termformula(cs_rev_cur_term in number, Sumrev_start_valPerorg_structu in number) return number ;
32 function cf_nonrev_cur_termformula(cs_nonrev_cur_term in number, Sumnonrev_start_valPerorg_stru in number) return number ;
33 function cf_rev_pct_changeformula(Sumrev_start_valPerorg_structu in number, Sumrev_end_valPerorg_Structure in number) return number ;
34 function cf_nonrev_pct_changeformula(Sumnonrev_start_valPerorg_stru in number, Sumnonrev_end_valPerorg_Struct in number) return number ;
35 function cf_days_betweenformula(date_to in date, date_from in date) return number ;
36 function AfterReport return boolean ;
37 Function CP_BUSINESS_GROUP_NAME_p return varchar2;
38 Function CP_TOP_ORG_NAME_p return varchar2;
39 Function CP_ORGANIZATION_HIERARCHY_NAM return varchar2;
40 Function CP_NULL_p return number;
41 Function CP_TERM_p return varchar2;
42 Function CP_NH_p return varchar2;
43 Function CP_NH1_p return varchar2;
44 Function CP_TERM1_p return varchar2;
45 Function CP_WORKER_TYPE_p return varchar2;
46 END PER_PERHDCNT_XMLP_PKG;