1 PACKAGE PSP_PSPLSODR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPLSODRS.pls 120.5 2008/01/30 07:45:23 amakrish noship $ */
3
4 P_RUN_ID NUMBER := -99;
5
6 P_BEGIN_DATE DATE;
7
8 P_END_DATE DATE;
9
10 P_ORGANIZATION_ID VARCHAR2(2000) := '1=1';
11
12 P_REPORT_TYPE VARCHAR2(1);
13
14 P_CONC_REQUEST_ID NUMBER;
15
16 P_BUSINESS_GROUP_ID NUMBER;
17
18 P_SET_OF_BOOKS_ID NUMBER;
19
20 P_ORG_TEMPLATE_ID NUMBER;
21
22 FUNCTION CF_GL_DESCFORMULA(GL_CODE_COMBINATION_ID IN NUMBER) RETURN CHAR;
23
24 FUNCTION CF_TASK_NAMEFORMULA(PROJECT_ID_1 IN NUMBER
25 ,TASK_ID_1 IN NUMBER) RETURN CHAR;
26
27 FUNCTION CF_AWARD_NUMBERFORMULA(AWARD_ID_1 IN NUMBER) RETURN CHAR;
28
29 FUNCTION CF_PROJECT_NUMBERFORMULA(PROJECT_ID_1 IN NUMBER) RETURN CHAR;
30
31 FUNCTION CF_ORG_NAMEFORMULA(EXPENDITURE_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
32
33 FUNCTION BEFOREREPORT RETURN BOOLEAN;
34
35 FUNCTION AFTERREPORT RETURN BOOLEAN;
36
37 FUNCTION CF_ORG_SCHEDULE_IDFORMULA(ORG_SCHEDULE_ID IN NUMBER) RETURN NUMBER;
38
39 FUNCTION AFTERPFORM RETURN BOOLEAN;
40
41 FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR;
42
43 FUNCTION CF_SCH_BEGIN_DATE_DISPFORMULA(SCHEDULE_BEGIN_DATE IN DATE
44 ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
45
46 FUNCTION CF_SCH_END_DATE_DISPFORMULA(SCHEDULE_END_DATE IN DATE
47 ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
48
49 FUNCTION CF_REPORT_RUN_DATEFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
50
51 FUNCTION CF_PERIOD_START_DATEFORMULA(PERIOD_START_DATE IN DATE
52 ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
53
54 FUNCTION CF_PERIOD_END_DATE_DISPFORMULA(PERIOD_END_DATE IN DATE
55 ,CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
56
57 FUNCTION CF_BEGIN_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
58
59 FUNCTION CF_END_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
60
61 END PSP_PSPLSODR_XMLP_PKG;