1 PACKAGE PSP_PSPENEXR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPENEXRS.pls 120.6 2007/11/01 06:41:39 amakrish noship $ */
3 P_BUSINESS_GROUP NUMBER;
4
5 P_CONC_REQUEST_ID NUMBER;
6
7 P_SORT_BY VARCHAR2(40);
8
9 P_SET_OF_BOOKS_ID NUMBER;
10
11 P_PAYROLL_ID NUMBER;
12
13 P_ACTUAL_SELECT VARCHAR2(20000);
14
15 P_GMS_APPLICATION_ID VARCHAR2(40);
16
17 P_GL_APPLICATION_ID VARCHAR2(40);
18
19 P_PAYROLL_ACTION_ID NUMBER;
20
21 CP_SORT_DESCRIPTION2 VARCHAR2(4000);
22
23 CP_SORT_BY_DETAIL VARCHAR2(40);
24
25 FUNCTION BEFOREREPORT RETURN BOOLEAN;
26
27 FUNCTION CF_ELEMENT_NAMEFORMULA(ELEMENT_TYPE_ID IN NUMBER
28 ,MAX_END_DATE IN DATE
29 ,MIN_START_DATE IN DATE
30 ,SORT_OPTION22 IN NUMBER
31 ,SORT_OPTION23 IN NUMBER
32 ,SORT_OPTION24 IN NUMBER
33 ,SORT_OPTION25 IN NUMBER
34 ,SORT_OPTION26 IN NUMBER
35 ,SORT_OPTION27 IN VARCHAR2
36 ,SORT_OPTION21 IN NUMBER) RETURN CHAR;
37
38 FUNCTION CF_SORT_DESCRIPTION1FORMULA(SORT_OPTION11 IN NUMBER
39 ,SORT_OPTION12 IN NUMBER
40 ,SORT_OPTION13 IN NUMBER
41 ,SORT_OPTION14 IN NUMBER
42 ,SORT_OPTION15 IN NUMBER
43 ,SORT_OPTION16 IN NUMBER
44 ,SORT_OPTION17 IN VARCHAR2) RETURN CHAR;
45
46 FUNCTION CF_SORT_BY_HEADERFORMULA RETURN CHAR;
47
48 FUNCTION AFTERREPORT RETURN BOOLEAN;
49
50 FUNCTION CF_PAYROLL_NAMEFORMULA(PAYROLL_ID IN NUMBER) RETURN CHAR;
51
52 FUNCTION CF_PERSON_NAMEFORMULA(PERSON_ID IN NUMBER
53 ,MAX_END_DATE IN DATE
54 ,MIN_START_DATE IN DATE) RETURN CHAR;
55
56 FUNCTION CF_ASSIGNMENT_NUMBERFORMULA(ASSIGNMENT_ID IN NUMBER
57 ,MAX_END_DATE IN DATE
58 ,MIN_START_DATE IN DATE) RETURN CHAR;
59
60 FUNCTION CP_SORT_DESCRIPTION2_P RETURN VARCHAR2;
61
62 FUNCTION CP_SORT_BY_DETAIL_P RETURN VARCHAR2;
63
64 END PSP_PSPENEXR_XMLP_PKG;