1 PACKAGE PSP_PSPENAWD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPENAWDS.pls 120.6 2008/01/30 07:36:27 amakrish noship $ */
3 P_AWARD_ID VARCHAR2(2047);
4
5 P_PAYROLL_ID VARCHAR2(2047);
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 LP_BEGIN_DATE VARCHAR2(20);
16
17 P_END_DATE DATE;
18
19 LP_END_DATE VARCHAR2(20);
20
21 P_AWD_TEMPLATE_ID NUMBER;
22
23 P_PAY_TEMPLATE_ID NUMBER;
24
25 FUNCTION AFTERPFORM RETURN BOOLEAN;
26
27 FUNCTION CF_CHARGING_INSTFORMULA(PROJECT_ID IN NUMBER
28 ,TASK_ID IN NUMBER
29 ,AWARD_ID IN NUMBER
30 ,EXPENDITURE_ORGANIZATION_ID IN NUMBER
31 ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR;
32
33 FUNCTION CF_AWD_END_DTFORMULA(AWARD_ID 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_END_DATE_RANGEFORMULA(ENC_BEGIN_DATE IN DATE
41 ,ENC_END_DATE IN DATE) RETURN CHAR;
42
43 FUNCTION CF_AWARD_TOTAL_DSPFORMULA(CS_AWARD_TOTAL IN NUMBER
44 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
45
46 FUNCTION CF_PELH_ENC_AMOUNT_DSPFORMULA(SUM_PELH_ENCUMBRANCE_AMOUNT IN NUMBER
47 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
48
49 FUNCTION AFTERREPORT RETURN BOOLEAN;
50
51 FUNCTION CF_PAY_TOTAL_DSPFORMULA(CS_PAY_TOTAL IN NUMBER
52 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
53
54 FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
55
56 FUNCTION CF_CURRENCY_TOTAL_DSPFORMULA(CS_CURRENCY_TOTAL IN NUMBER
57 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN VARCHAR2;
58
59 END PSP_PSPENAWD_XMLP_PKG;