DBA Data[Home] [Help]

PACKAGE: APPS.PQH_PQHWSOPS_XMLP_PKG

Source


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;