PACKAGE: APPS.PER_PERUSADA_XMLP_PKG

Source

1 PACKAGE PER_PERUSADA_XMLP_PKG AS
2 /* $Header: PERUSADAS.pls 120.1 2007/12/28 07:38:47 amakrish noship $ */
3 	P_ORG_STRUCTURE_VERSION_ID	number;
4 	P_SESSION_DATE1 varchar2(240);
5 	P_ORG_STRUCTURE_VERSION_ID_1	number;
6 	P_BUSINESS_GROUP_ID	number;
7 	P_ORGANIZATION_ID	varchar2(40);
8 	P_SESSION_DATE	date;
9 	P_VIEW_JOB_REQS	varchar2(32767);
10 	P_VIEW_POSITION_REQS	varchar2(32767);
11 	P_REGISTERED_DISABLED	varchar2(32767);
12 	P_PERSON	number;
13 	P_EMPLOYEE_NUMBER	number;
14 	P_JOB_ID	number;
15 	P_POSITION_NAME	varchar2(240);
16 	P_LOCATION	number;
17 	P_SORT	varchar2(32767);
18 	P_CONC_REQUEST_ID	number;
19 	C_BUSINESS_GROUP_NAME	varchar2(60);
20 	C_REPORT_TYPE	varchar2(30);
21 	C_ORGANIZATION_HIERARCHY	varchar2(30);
22 	C_ORGANIZATION	varchar2(60);
23 	C_DISABILITY_ID_FLEX_NUM	number;
24 	C_DISABILITY_ACC_ID_FLEX_NUM	number;
25 /*	C_lex_assign_where	varchar2(20000) := := 'and 1 = 1' ;
26 	C_lex_assign_order	varchar2(250) := := 'initcap(peo.full_name)' ;*/
27 	C_lex_assign_where	varchar2(20000) := 'and 1 = 1' ;
28 	C_lex_assign_order	varchar2(250) := 'initcap(peo.full_name)' ;
29 	C_full_name	varchar2(240);
30 	C_employee_number	varchar2(40);
31 	C_job_name	varchar2(80);
32 	C_location_code	varchar2(40);
33 	function BeforeReport return boolean  ;
34 	function g_1groupfilter(establishment_id1 in number) return boolean  ;
35 	function G_DisabilitiesGroupFilter return boolean  ;
36 	function G_2GroupFilter return boolean  ;
37 	function AfterPForm return boolean  ;
38 	function AfterReport return boolean  ;
39 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
40 	Function C_REPORT_TYPE_p return varchar2;
41 	Function C_ORGANIZATION_HIERARCHY_p return varchar2;
42 	Function C_ORGANIZATION_p return varchar2;
43 	Function C_DISABILITY_ID_FLEX_NUM_p return number;
44 	Function C_DISABILITY_ACC_ID_FLEX_NUM_p return number;
45 	Function C_lex_assign_where_p return varchar2;
46 	Function C_lex_assign_order_p return varchar2;
47 	Function C_full_name_p return varchar2;
48 	Function C_employee_number_p return varchar2;
49 	Function C_job_name_p return varchar2;
50 	Function C_location_code_p return varchar2;
51 END PER_PERUSADA_XMLP_PKG;