PACKAGE: APPS.PER_PERRPROH_XMLP_PKG

Source

1 PACKAGE PER_PERRPROH_XMLP_PKG AS
2 /* $Header: PERRPROHS.pls 120.1 2007/12/06 11:33:13 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	date;
5 	P_SESSION_DATE1 varchar2(240);
6 	P_CONC_REQUEST_ID	number;
7 	P_PARENT_ORGANIZATION_ID	number;
8 	P_ORG_STRUCTURE_VERSION_ID	number;
9 	P_MANAGER_FLAG	varchar2(30);
10 	C_type	varchar2(90);
11 	C_BUSINESS_GROUP_NAME	varchar2(240);
12 	C_REPORT_SUBTITLE	varchar2(60);
13 	C_ORG_HIERARCHY_NAME	varchar2(30);
14 	C_VERSION	number;
15 	C_VERSION_START_DATE	date;
16 	C_VERSION_END_DATE	date;
17 	C_PARENT_ORG_NAME	varchar2(240);
18 	C_SESSION_DATE	varchar2(11);
19 	C_MANAGERS_SHOWN	varchar2(30);
20 	--C_GLOBAL_HIERARCHY	varchar2(80) := := 'Global Organization Hierarchy' ;
21 	C_GLOBAL_HIERARCHY	varchar2(80) := 'Global Organization Hierarchy' ;
22 	function BeforeReport return boolean  ;
23 	function c_nameformula(organization_id_parent in number) return varchar2  ;
24 	function c_count_org_subords2formula(organization_id_child in number) return number  ;
25 	--function c_count_child_orgs1formula(organization_id_parent in number) return number  ;
26 	function c_count_child_orgs1formula(arg_organization_id_parent in number) return number  ;
27 	function c_count_managersformula(organization_id_parent in number) return varchar2  ;
28 	function c_count_managers1formula(organization_id_child in number) return number  ;
29 	function c_count_org_subordsformula(organization_id_parent in number) return number  ;
30 	function AfterReport return boolean  ;
31 	Function C_type_p return varchar2;
32 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
33 	Function C_REPORT_SUBTITLE_p return varchar2;
34 	Function C_ORG_HIERARCHY_NAME_p return varchar2;
35 	Function C_VERSION_p return number;
36 	Function C_VERSION_START_DATE_p return date;
37 	Function C_VERSION_END_DATE_p return date;
38 	Function C_PARENT_ORG_NAME_p return varchar2;
39 	Function C_SESSION_DATE_p return varchar2;
40 	Function C_MANAGERS_SHOWN_p return varchar2;
41 	Function C_GLOBAL_HIERARCHY_p return varchar2;
42 END PER_PERRPROH_XMLP_PKG;