PACKAGE: APPS.PER_PERRPRTM_XMLP_PKG

Source

1 PACKAGE PER_PERRPRTM_XMLP_PKG AS
2 /* $Header: PERRPRTMS.pls 120.1 2007/12/06 11:34:21 amakrish noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_SESSION_DATE DATE;
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_PARENT_ORGANIZATION_ID NUMBER;
10 
11   P_ORG_STRUCTURE_VERSION_ID NUMBER;
12 
13   P_LEAV_REASON1 VARCHAR2(40);
14 
15   P_DATE_FROM DATE;
16 
17   P_DATE_TO DATE;
18 
19   P_LEAV_REASON2 VARCHAR2(40);
20 
21   P_LEAV_REASON3 VARCHAR2(40);
22 
23   P_LEAV_REASON4 VARCHAR2(40);
24 
25   P_LEAV_REASON5 VARCHAR2(40);
26 
27   P_LEAV_REASON6 VARCHAR2(40);
28 
29   P_ALTERNATE VARCHAR2(30);
30 
31   P_LOOKUP_TYPE VARCHAR2(30) := 'LEAV_REAS';
32 
33   P_REASON_COLUMN VARCHAR2(30) := 'P.LEAVING_REASON';
34 
35   P_ORG_MATCHING VARCHAR2(2000);
36 
37   C_BUSINESS_GROUP_NAME VARCHAR2(240);
38 
39   C_REPORT_SUBTITLE VARCHAR2(60);
40 
41   C_PARENT_ORGANIZATION_NAME VARCHAR2(240);
42 
43   C_ORG_STRUCTURE_NAME VARCHAR2(30);
44 
45   C_HEAD_REASONS VARCHAR2(720);
46 
47   C_LEAV_REASON1 VARCHAR2(30);
48 
49   C_LEAV_REASON2 VARCHAR2(30);
50 
51   C_LEAV_REASON3 VARCHAR2(30);
52 
53   C_LEAV_REASON4 VARCHAR2(30);
54 
55   C_LEAV_REASON5 VARCHAR2(30);
56 
57   C_LEAV_REASON6 VARCHAR2(30);
58 
59   C_GLOBAL_HIERARCHY VARCHAR2(80) := 'Global Organization Hierarchy';
60 
61   FUNCTION BEFOREREPORT RETURN BOOLEAN;
62 
63   FUNCTION AFTERREPORT RETURN BOOLEAN;
64 
65   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
66 
67   FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
68 
69   FUNCTION C_PARENT_ORGANIZATION_NAME_P RETURN VARCHAR2;
70 
71   FUNCTION C_ORG_STRUCTURE_NAME_P RETURN VARCHAR2;
72 
73   FUNCTION C_HEAD_REASONS_P RETURN VARCHAR2;
74 
75   FUNCTION C_LEAV_REASON1_P RETURN VARCHAR2;
76 
77   FUNCTION C_LEAV_REASON2_P RETURN VARCHAR2;
78 
79   FUNCTION C_LEAV_REASON3_P RETURN VARCHAR2;
80 
81   FUNCTION C_LEAV_REASON4_P RETURN VARCHAR2;
82 
83   FUNCTION C_LEAV_REASON5_P RETURN VARCHAR2;
84 
85   FUNCTION C_LEAV_REASON6_P RETURN VARCHAR2;
86 
87   FUNCTION C_GLOBAL_HIERARCHY_P RETURN VARCHAR2;
88 
89 END PER_PERRPRTM_XMLP_PKG;