PACKAGE: APPS.PER_PERRPCTM_XMLP_PKG

Source

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