1 PACKAGE PSP_PSPENORG_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPENORGS.pls 120.3 2007/10/29 07:23:18 amakrish noship $ */
3 P_ORGANIZATION_ID VARCHAR2(400);
4
5 P_PAYROLL_ID VARCHAR2(300);
6
7 P_SET_OF_BOOKS_ID NUMBER;
8
9 P_BUSINESS_GROUP_ID NUMBER;
10
11 P_CONC_REQUEST_ID NUMBER;
12
13 P_BEGIN_DATE DATE;
14
15 CP_BEGIN_DATE VARCHAR2(25);
16
17 P_END_DATE DATE;
18
19 CP_END_DATE VARCHAR2(25);
20 P_ORG_TEMPLATE_ID NUMBER;
21
22 P_PAY_TEMPLATE_ID NUMBER;
23
24 FUNCTION AFTERPFORM RETURN BOOLEAN;
25
26 FUNCTION CF_CHARGING_INSTFORMULA(GL_CODE_COMBINATION_ID IN NUMBER
27 ,PROJECT_ID1 IN NUMBER
28 ,TASK_ID1 IN NUMBER
29 ,AWARD_ID1 IN NUMBER
30 ,EXPENDITURE_ORGANIZATION_ID IN NUMBER
31 ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR;
32
33 FUNCTION CF_AWD_END_DTFORMULA(AWARD_ID1 IN NUMBER) RETURN DATE;
34
35 FUNCTION CF_DATE_CHECKFORMULA(CF_AWD_END_DT IN DATE
36 ,ENC_END_DATE IN DATE) RETURN CHAR;
37
38 FUNCTION BEFOREREPORT RETURN BOOLEAN;
39
40 FUNCTION CF_ENC_DATE_RANGEFORMULA(ENC_BEGIN_DATE IN DATE
41 ,ENC_END_DATE IN DATE) RETURN CHAR;
42
43 FUNCTION CF_ENC_AMOUNT_DSPFORMULA(ENC_AMOUNT IN NUMBER
44 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
45
46 FUNCTION CF_ORG_TOTAL_DSPFORMULA(CS_ORG_TOTAL IN NUMBER
47 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
48
49 FUNCTION AFTERREPORT RETURN BOOLEAN;
50
51 FUNCTION CF_PAY_TOTAL_DISPFORMULA(CS_PAY_TOTAL IN NUMBER
52 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
53
54 FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
55
56 FUNCTION CF_CURRENCY_TOTAL_DSPFORMULA(CURRENCY_CODE IN VARCHAR2
57 ,CF_CURRENCY_FORMAT IN VARCHAR2
58 ,CS_CURRENCY_TOTAL IN NUMBER) RETURN CHAR;
59
60 END PSP_PSPENORG_XMLP_PKG;