1 PACKAGE PSP_PSPLDAWD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPLDAWDS.pls 120.5 2007/10/29 07:23:35 amakrish noship $ */
3 P_AWARD_ID VARCHAR2(2550);
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_AWD_TEMPLATE_ID NUMBER;
16
17 FUNCTION AFTERPFORM RETURN BOOLEAN;
18
19 FUNCTION BEFOREPFORM(ORIENTATION IN VARCHAR2) RETURN BOOLEAN;
20
21 FUNCTION CF_EMPLOYEE_NUMBERFORMULA RETURN VARCHAR2;
22
23 FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2;
24
25 FUNCTION BEFOREREPORT RETURN BOOLEAN;
26
27 FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
28
29 FUNCTION CF_SUM_CURRENCY_CODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
30
31 FUNCTION CF_CURR_AWD_AMT_TOTALFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
32 ,CS_CURR_AWD_AMT_TOTAL IN NUMBER) RETURN CHAR;
33
34 FUNCTION CF_EARNINGS_AMOUNTFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2
35 ,EARNINGS_AMOUNT IN NUMBER) RETURN CHAR;
36
37 FUNCTION CF_AWARD_NAMEFORMULA(AWARD_ID IN NUMBER) RETURN VARCHAR2;
38
39 FUNCTION CF_EMPLOYEE_NAMEFORMULA(PERSON_ID IN NUMBER) RETURN VARCHAR2;
40
41 FUNCTION CF_ASSIGNMENT_NUMBERFORMULA(ASSIGNMENT_ID IN NUMBER
42 ,PERSON_ID IN NUMBER) RETURN VARCHAR2;
43
44 FUNCTION CF_ELEMENT_NAMEFORMULA(ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
45
46 FUNCTION CF_TIME_PERIOD_NAMEFORMULA(TIME_PERIOD_ID IN NUMBER) RETURN VARCHAR2;
47
48 FUNCTION AFTERREPORT RETURN BOOLEAN;
49
50 FUNCTION CF_DATE_FORMATFORMULA RETURN CHAR;
51
52 FUNCTION CF_START_DATE_DISPLAYFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
53
54 FUNCTION CF_END_DATE_DISPFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
55
56 FUNCTION CF_CHARGING_INSTRUCTIONSFORMUL(EXPENDITURE_ORGANIZATION_ID IN NUMBER
57 ,TASK_ID IN NUMBER
58 ,PROJECT_ID IN NUMBER
59 --,CF_AWARD_NAME IN VARCHAR2
60 ,AWARD_ID IN VARCHAR2
61 ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR;
62
63 FUNCTION CF_DATE_RUNFORMULA(CF_DATE_FORMAT IN VARCHAR2) RETURN CHAR;
64
65 PROCEDURE PUT(NAME IN VARCHAR2
66 ,VAL IN VARCHAR2);
67
68 FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
69
70 PROCEDURE GET(NAME IN VARCHAR2
71 ,VAL OUT NOCOPY VARCHAR2);
72
73 FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
74
75 FUNCTION SAVE_USER(X_NAME IN VARCHAR2
76 ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
77
78 FUNCTION SAVE(X_NAME IN VARCHAR2
79 ,X_VALUE IN VARCHAR2
80 ,X_LEVEL_NAME IN VARCHAR2
81 ,X_LEVEL_VALUE IN VARCHAR2
82 ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
83
84 PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
85 ,USER_ID_Z IN NUMBER
86 ,RESPONSIBILITY_ID_Z IN NUMBER
87 ,APPLICATION_ID_Z IN NUMBER
88 ,VAL_Z OUT NOCOPY VARCHAR2
89 ,DEFINED_Z OUT NOCOPY BOOLEAN);
90
91 FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
92 ,USER_ID IN NUMBER
93 ,RESPONSIBILITY_ID IN NUMBER
94 ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
95
96 PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
97 ,RESPONSIBILITY_ID_Z IN NUMBER
98 ,APPLICATION_ID_Z IN NUMBER
99 ,SITE_ID_Z IN NUMBER);
100
101 PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
102 ,VALS IN VARCHAR2
103 ,NUM IN NUMBER);
104
105 END PSP_PSPLDAWD_XMLP_PKG;