PACKAGE: APPS.PA_PAXRWDOH_XMLP_PKG

Source

1 PACKAGE PA_PAXRWDOH_XMLP_PKG AS
2 /* $Header: PAXRWDOHS.pls 120.0 2008/01/02 11:57:03 krreddy noship $ */
3 	START_ORG_ID	varchar2(200);
4 	P_CONC_REQUEST_ID	number;
5 	P_burden	varchar2(200);
6 	P_select_column	varchar2(200):='''hieracy_type''';
7 	P_select_column1	varchar2(200):='pi.org_structure_version_id org_structure_version_id';
8 	P_structure_id	varchar2(200):='and 1=1';
9 	P_version_id	varchar2(200):='and 1=1';
10 	P_where_clause	varchar2(200):='and    p.org_structure_version_id = pi.org_structure_version_id';
11 	P_where_clause1	varchar2(200):='and  HR2.ORG_INFORMATION_CONTEXT = ''Project Burdening Hierarchy''';
12 	P_decode_column	varchar2(200):='1';
13 	P_from_clause	varchar2(200):='per_org_structure_versions  posv,hr_organization_information hr';
14 	P_hierarchy_type	varchar2(200);
15 	P_org_hr	varchar2(200):='and 1=1';
16 	P_parent_org_id	varchar2(200):='pi.exp_start_org_id';
17 	C_Company_Name_Header	varchar2(40);
18 	C_Org_Name	varchar2(60);
19 	C_NO_DATA_FOUND	varchar2(80);
20 	FUNCTION  get_company_name    RETURN BOOLEAN  ;
21 	function BeforeReport return boolean  ;
22 	function AfterReport return boolean  ;
23 	Function C_Company_Name_Header_p return varchar2;
24 	Function C_Org_Name_p return varchar2;
25 	Function C_NO_DATA_FOUND_p return varchar2;
26 END PA_PAXRWDOH_XMLP_PKG;