PACKAGE: APPS.PER_PERRPRAA_XMLP_PKG

Source

1 PACKAGE PER_PERRPRAA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PERRPRAAS.pls 120.1 2007/12/06 11:30:35 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE1 varchar2(240);
5 	P_SESSION_DATE	date;
6 	P_CONC_REQUEST_ID	number;
7 	P_ORGANIZATION_ID	number;
8 	P_PERSON_ID	number;
9 	P_DATE_FROM	date;
10 	P_DATE_TO	date;
11 	P_ABS_TYPE1	varchar2(30);
12 	P_ABS_TYPE2	varchar2(30);
13 	P_ABS_TYPE3	varchar2(30);
14 	P_ABS_TYPE4	varchar2(30);
15 	P_ABS_TYPE5	varchar2(30);
16 	P_ABS_TYPE6	varchar2(30);
17 	P_ABS_TYPE7	varchar2(30);
18 	P_ABS_TYPE8	varchar2(30);
19 	P_ABS_TYPE9	varchar2(30);
20 	P_ABS_TYPE10	varchar2(30);
21 	--P_ABSENCE_SQL	varchar2(400);
22 	--P_ABSENCE_ATT_SQL	varchar2(100);
23 	P_ABSENCE_SQL	varchar2(400) := 'and 1 = 1';
24 	P_ABSENCE_ATT_SQL	varchar2(100) := 'and 1 = 1';
25 	C_BUSINESS_GROUP_NAME	varchar2(240);
26 	C_REPORT_SUBTITLE	varchar2(60);
27 	C_DISPLAY_ABTYPES	varchar2(309);
28 	C_ORGANIZATION_NAME	varchar2(240);
29 	C_ABTYPES_ENTERED	varchar2(1);
30 	C_ABSENCE_TYPES	varchar2(329);
31 	C_ABS_TYPE_NAME1	varchar2(30);
32 	C_ABS_TYPE_NAME2	varchar2(30);
33 	C_ABS_TYPE_NAME3	varchar2(30);
34 	C_ABS_TYPE_NAME4	varchar2(30);
35 	C_ABS_TYPE_NAME5	varchar2(30);
36 	C_ABS_TYPE_NAME6	varchar2(30);
37 	C_ABS_TYPE_NAME7	varchar2(30);
38 	C_ABS_TYPE_NAME8	varchar2(30);
39 	C_ABS_TYPE_NAME9	varchar2(30);
40 	C_ABS_TYPE_NAME10	varchar2(30);
41 	C_PERSON_NAME	varchar2(240);
42 	C_NLS_LANGUAGE	varchar2(66);
43 	function BeforeReport return boolean  ;
44 	function c_running_totalformula(summ_person_id in number, p_absence_attendance_type_id in number) return number  ;
45 	function AfterReport return boolean  ;
46 	function AfterPForm return boolean  ;
47 	function BetweenPage return boolean  ;
48 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
49 	Function C_REPORT_SUBTITLE_p return varchar2;
50 	Function C_DISPLAY_ABTYPES_p return varchar2;
51 	Function C_ORGANIZATION_NAME_p return varchar2;
52 	Function C_ABTYPES_ENTERED_p return varchar2;
53 	Function C_ABSENCE_TYPES_p return varchar2;
54 	Function C_ABS_TYPE_NAME1_p return varchar2;
55 	Function C_ABS_TYPE_NAME2_p return varchar2;
56 	Function C_ABS_TYPE_NAME3_p return varchar2;
57 	Function C_ABS_TYPE_NAME4_p return varchar2;
58 	Function C_ABS_TYPE_NAME5_p return varchar2;
59 	Function C_ABS_TYPE_NAME6_p return varchar2;
60 	Function C_ABS_TYPE_NAME7_p return varchar2;
61 	Function C_ABS_TYPE_NAME8_p return varchar2;
62 	Function C_ABS_TYPE_NAME9_p return varchar2;
63 	Function C_ABS_TYPE_NAME10_p return varchar2;
64 	Function C_PERSON_NAME_p return varchar2;
65 	Function C_NLS_LANGUAGE_p return varchar2;
66 END PER_PERRPRAA_XMLP_PKG;