PACKAGE: APPS.PER_PERUSE1L_XMLP_PKG

Source

1 PACKAGE PER_PERUSE1L_XMLP_PKG AS
2 /* $Header: PERUSE1LS.pls 120.0 2008/01/07 12:31:08 srikrish noship $ */
3   P_PAYROLL_PERIOD_DATE_START VARCHAR2(32767);
4 
5   P_MAXIMUM_NO_OF_EMPLOYEES NUMBER;
6 
7   P_REPORT_YEAR VARCHAR2(4);
8 
9   P_PAYROLL_PERIOD_DATE_END VARCHAR2(32767);
10 
11   P_PAYROLL_PERIOD_DATE VARCHAR2(32767);
12 
13   P_CONC_REQUEST_ID NUMBER;
14 
15   P_HIERARCHY_ID NUMBER;
16 
17   P_HIERARCHY_VERSION_ID NUMBER;
18 
19   P_BUSINESS_GROUP_ID NUMBER;
20 
21   P_AUDIT_REPORT VARCHAR2(1);
22 
23   C_REPORT_EMPS NUMBER;
24 
25   C_MAIN_ACTIVITY VARCHAR2(200);
26 
27   C_TOT_EMPS NUMBER;
28 
29   C_END_OF_TIME DATE;
30 
31   TOT_COUNT_EMPS NUMBER := 0;
32 
33   C_BUSINESS_GROUP_NAME VARCHAR2(60);
34 
35   C_HIERARCHY_VERSION_NUM NUMBER;
36 
37   C_PARENT_NODE_ID NUMBER;
38 
39   C_PARENT_ORG_ID NUMBER;
40 
41   DEFAULT_ACTIVITIES_LINE1 VARCHAR2(60);
42 
43   DEFAULT_ACTIVITIES_LINE2 VARCHAR2(60);
44 
45   DEFAULT_ACTIVITIES_LINE3 VARCHAR2(60);
46 
47   DEFAULT_ACTIVITIES_LINE4 VARCHAR2(60);
48 
49   C_HIERARCHY_NAME VARCHAR2(60);
50 
51   C_NO_OF_ESTABLISHMENTS NUMBER;
52 
53   C_REPORT_YEAR VARCHAR2(4);
54 
55   C_REPORT_DATE DATE;
56 
57   C_MAXIMUM_NO_OF_EMPLOYEES NUMBER;
58 
59   C_PAYROLL_PERIOD_DATE_START DATE;
60 
61   C_PAYROLL_PERIOD_DATE_END DATE;
62 
63   FUNCTION BEFOREREPORT RETURN BOOLEAN;
64 
65   FUNCTION P_REPORT_YEARVALIDTRIGGER RETURN BOOLEAN;
66 
67   FUNCTION AFTERREPORT RETURN BOOLEAN;
68 
69   FUNCTION C_TOT_ACTFORMULA(EST_NODE_ID IN NUMBER
70                            ,HEADQUARTERS IN VARCHAR2) RETURN NUMBER;
71 
72   FUNCTION BEFOREPFORM RETURN BOOLEAN;
73 
74   FUNCTION C_REPORT_EMPS_P RETURN NUMBER;
75 
76   FUNCTION C_MAIN_ACTIVITY_P RETURN VARCHAR2;
77 
78   FUNCTION C_TOT_EMPS_P RETURN NUMBER;
79 
80   FUNCTION C_END_OF_TIME_P RETURN DATE;
81 
82   FUNCTION TOT_COUNT_EMPS_P RETURN NUMBER;
83 
84   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
85 
86   FUNCTION C_HIERARCHY_VERSION_NUM_P RETURN NUMBER;
87 
88   FUNCTION C_PARENT_NODE_ID_P RETURN NUMBER;
89 
90   FUNCTION C_PARENT_ORG_ID_P RETURN NUMBER;
91 
92   FUNCTION DEFAULT_ACTIVITIES_LINE1_P RETURN VARCHAR2;
93 
94   FUNCTION DEFAULT_ACTIVITIES_LINE2_P RETURN VARCHAR2;
95 
96   FUNCTION DEFAULT_ACTIVITIES_LINE3_P RETURN VARCHAR2;
97 
98   FUNCTION DEFAULT_ACTIVITIES_LINE4_P RETURN VARCHAR2;
99 
100   FUNCTION C_HIERARCHY_NAME_P RETURN VARCHAR2;
101 
102   FUNCTION C_NO_OF_ESTABLISHMENTS_P RETURN NUMBER;
103 
104   FUNCTION C_REPORT_YEAR_P RETURN VARCHAR2;
105 
106   FUNCTION C_REPORT_DATE_P RETURN DATE;
107 
108   FUNCTION C_MAXIMUM_NO_OF_EMPLOYEES_P RETURN NUMBER;
109 
110   FUNCTION C_PAYROLL_PERIOD_DATE_START_P RETURN DATE;
111 
112   FUNCTION C_PAYROLL_PERIOD_DATE_END_P RETURN DATE;
113 
114   --PROCEDURE OPEN;
115 
116   --PROCEDURE PUT(P_CHAR IN VARCHAR2);
117 
118   --PROCEDURE CLOSE;
119 
120 END PER_PERUSE1L_XMLP_PKG;