1 PACKAGE PSP_PSPLDPRJ_XMLP_PKG AS
2 /* $Header: PSPLDPRJS.pls 120.4 2007/10/29 07:24:29 amakrish noship $ */
3 P_PROJECT_ID VARCHAR2(2000);
4
5 P_CONC_REQUEST_ID NUMBER;
6
7 P_BUSINESS_GROUP_ID NUMBER;
8
9 P_SET_OF_BOOKS_ID NUMBER;
10
11 P_START_DATE DATE;
12
13 P_END_DATE DATE;
14
15 P_PRJ_TEMPLATE_ID NUMBER;
16
17 FUNCTION AFTERPFORM RETURN BOOLEAN;
18
19 FUNCTION BEFOREPFORM(ORIENTATION IN VARCHAR2) RETURN BOOLEAN;
20
21 FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2;
22
23 FUNCTION BEFOREREPORT RETURN BOOLEAN;
24
25 FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
26
27 FUNCTION CF_SUM_CURRENCY_CODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
28
29 FUNCTION CF_CURR_PROJ_AMT_TOTALFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
30 ,CS_CURR_PROJ_AMT_TOTAL IN NUMBER) RETURN CHAR;
31
32 FUNCTION CF_EARNINGS_AMOUNTFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
33 ,EARNINGS_AMOUNT IN NUMBER) RETURN CHAR;
34
35 FUNCTION CF_PROJECT_NAMEFORMULA(PROJECT_ID_arg IN NUMBER) RETURN VARCHAR2;
36
37 FUNCTION CF_EMPLOYEE_NAMEFORMULA(PERSON_ID_arg IN NUMBER) RETURN VARCHAR2;
38
39 FUNCTION CF_ASSIGNMENT_NUMBERFORMULA(ASSIGNMENT_ID_arg IN NUMBER) RETURN VARCHAR2;
40
41 FUNCTION CF_ELEMENT_NAMEFORMULA(ELEMENT_TYPE_ID_arg IN NUMBER) RETURN VARCHAR2;
42
43 FUNCTION CF_TIME_PERIOD_NAMEFORMULA(TIME_PERIOD_ID_arg IN NUMBER) RETURN VARCHAR2;
44
45 FUNCTION AFTERREPORT RETURN BOOLEAN;
46
47 FUNCTION CF_BEGIN_DATE_DSPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
48
49 FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR;
50
51 FUNCTION CF_DATE_RUNFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
52
53 FUNCTION CF_END_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
54
55 FUNCTION CF_CHARGING_INSTRUCTIONFORMULA(EXPENDITURE_ORGANIZATION_ID IN NUMBER
56 ,TASK_ID_arg IN NUMBER
57 ,AWARD_ID_arg IN NUMBER
58 ,CF_PROJECT_NAME IN VARCHAR2
59 ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR ;
60
61 PROCEDURE PUT(NAME IN VARCHAR2
62 ,VAL IN VARCHAR2);
63
64 FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
65
66 PROCEDURE GET(NAME IN VARCHAR2
67 ,VAL OUT NOCOPY VARCHAR2);
68
69 FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
70
71 FUNCTION SAVE_USER(X_NAME IN VARCHAR2
72 ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
73
74 FUNCTION SAVE(X_NAME IN VARCHAR2
75 ,X_VALUE IN VARCHAR2
76 ,X_LEVEL_NAME IN VARCHAR2
77 ,X_LEVEL_VALUE IN VARCHAR2
78 ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
79
80 PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
81 ,USER_ID_Z IN NUMBER
82 ,RESPONSIBILITY_ID_Z IN NUMBER
83 ,APPLICATION_ID_Z IN NUMBER
84 ,VAL_Z OUT NOCOPY VARCHAR2
85 ,DEFINED_Z OUT NOCOPY BOOLEAN);
86
87 FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
88 ,USER_ID IN NUMBER
89 ,RESPONSIBILITY_ID IN NUMBER
90 ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
91
92 PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
93 ,RESPONSIBILITY_ID_Z IN NUMBER
94 ,APPLICATION_ID_Z IN NUMBER
95 ,SITE_ID_Z IN NUMBER);
96
97 PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
98 ,VALS IN VARCHAR2
99 ,NUM IN NUMBER);
100
101 END PSP_PSPLDPRJ_XMLP_PKG;