1 PACKAGE PQH_PQHWSOPS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PQHWSOPSS.pls 120.1 2007/12/07 07:02:03 vjaganat noship $ */
3 P_BUSINESS_GROUP_ID number;
4 p_business_group_id_1 number;
5 P_SESSION_DATE date;
6 P_SESSION_DATE_1 date;
7 P_REPORT_TITLE varchar2(80);
8 P_CONC_REQUEST_ID number;
9 P_START_DATE date;
10 P_START_DATE_1 date;
11 P_END_DATE date;
12 P_END_DATE_1 date;
13 P_ORGANIZATION_ID number;
14 P_ORGANIZATION_ID_1 number;
15 P_POSITION_TYPE varchar2(40);
16 P_VARIANCE_PERCENT number;
17 P_currency_code varchar2(15);
18 P_EFFECTIVE_DATE date;
19 p_effective_date_1 date;
20 C_REPORT_SUBTITLE varchar2(60);
21 CP_organization_name varchar2(240);
22 CP_position_type varchar2(80);
23 CP_currency varchar2(80);
24 C_BUSINESS_GROUP_NAME varchar2(240);
25 cp_session_dt date;
26 function BeforeReport return boolean ;
27 function cf_1formula(Budget_Unit_id1 in number, actual_amt in number, committed_amt in number) return number ;
28 function cf_def_ex_amtformula(budgeted_amt in number, cf_projected_exp in number) return number ;
29 function BeforePForm return boolean ;
30 function cf_act_performula(budgeted_amt in number, actual_amt in number) return number ;
31 function cf_com_performula(budgeted_amt in number, committed_amt in number) return number ;
32 function cf_proj_performula(budgeted_amt in number, cf_projected_exp in number) return number ;
33 function cf_def_ex_performula(budgeted_amt in number, cf_def_ex_amt in number) return number ;
34 function cf_org_budgeted_amtformula(organization_id1 in number, budget_unit_id in number) return number ;
35 function cf_org_actual_amtformula(organization_id1 in number, budget_unit_id in number) return number ;
36 function cf_org_act_performula(cf_org_budgeted_amt in number, cf_org_actual_amt in number) return number ;
37 function cf_org_committed_amtformula(organization_id1 in number, budget_unit_id in number) return number ;
38 function cf_org_com_performula(cf_org_budgeted_amt in number, cf_org_committed_amt in number) return number ;
39 function cf_org_projected_expformula(Budget_Unit_id in number, cf_org_actual_amt in number, cf_org_committed_amt in number) return number ;
40 function cf_org_proj_performula(cf_org_budgeted_amt in number, cf_org_projected_exp in number) return number ;
41 function cf_org_def_ex_amtformula(cf_org_budgeted_amt in number, cf_org_projected_exp in number) return number ;
42 function cf_org_def_ex_performula(cf_org_budgeted_amt in number, cf_org_def_ex_amt in number) return number ;
43 function cf_format_mask1(budget_unit_id in number) return char ;
44 function cf_format_mask2(budget_unit_id1 in number) return char ;
45 function AfterReport return boolean ;
46 Function C_REPORT_SUBTITLE_p return varchar2;
47 Function CP_organization_name_p return varchar2;
48 Function CP_position_type_p return varchar2;
49 Function CP_currency_p return varchar2;
50 Function C_BUSINESS_GROUP_NAME_p return varchar2;
51 Function cp_session_dt_p return date;
52 END PQH_PQHWSOPS_XMLP_PKG;