1 PACKAGE PSP_PSPRCSLD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPRCSLDS.pls 120.3 2007/10/29 07:27:56 amakrish noship $ */
3 P_SOURCE_CODE VARCHAR2(30);
4
5 P_SOURCE_TYPE VARCHAR2(1);
6
7 P_TIME_PERIOD_ID NUMBER;
8
9 P_BATCH_NAME VARCHAR2(30);
10
11 P_CONC_REQUEST_ID NUMBER;
12
13 P_PAYROLL_ID NUMBER;
14
15 P_START_DATE DATE;
16
17 P_SET_OF_BOOKS_ID NUMBER;
18
19 FUNCTION CF_ASSIGNMENT_NUMBERFORMULA(ASSIGNMENT_ID IN NUMBER) RETURN VARCHAR2;
20
21 FUNCTION CF_ELEMENT_NAMEFORMULA(ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
22
23 FUNCTION CF_PERSON_NAMEFORMULA(PERSON_ID IN NUMBER) RETURN VARCHAR2;
24
25 FUNCTION AFTERPFORM RETURN BOOLEAN;
26
27 FUNCTION CF_MISMATCH_ELTFORMULA RETURN VARCHAR2;
28
29 FUNCTION CF_MISMATCH_ASSGFORMULA(SUM_DL_D_ASSG IN NUMBER
30 ,SUM_SL_D_ASSG IN NUMBER
31 ,SUM_DL_C_ASSG IN NUMBER
32 ,SUM_SL_C_ASSG IN NUMBER) RETURN VARCHAR2;
33
34 FUNCTION CF_MISMATCH_PERSONFORMULA(SUM_DL_D_PERSON IN NUMBER
35 ,SUM_SL_D_PERSON IN NUMBER
36 ,SUM_DL_C_PERSON IN NUMBER
37 ,SUM_SL_C_PERSON IN NUMBER) RETURN VARCHAR2;
38
39 FUNCTION CF_MISMATCH_REPORTFORMULA(SUM_DL_D_TOTAL IN NUMBER
40 ,SUM_SL_D_TOTAL IN NUMBER
41 ,SUM_DL_C_TOTAL IN NUMBER
42 ,SUM_SL_C_TOTAL IN NUMBER) RETURN VARCHAR2;
43
44 FUNCTION CF_ORGFORMULA RETURN VARCHAR2;
45
46 FUNCTION BEFOREREPORT RETURN BOOLEAN;
47
48 FUNCTION CF_SOURCE_TYPEFORMULA RETURN VARCHAR2;
49
50 FUNCTION CF_TIME_PERIODFORMULA RETURN VARCHAR2;
51
52 FUNCTION CF_CHARGING_INSTRUCTIONSFORMUL(GLCCID IN NUMBER
53 ,PROJECT_ID IN NUMBER
54 ,TASK_ID IN NUMBER
55 ,AWARD_ID IN NUMBER
56 ,EXP_ORG_ID IN NUMBER
57 ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR;
58
59 FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
60
61 FUNCTION CF_CURRENCY_CODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
62
63 FUNCTION CF_SUM_SL_D_TOTAL_DSPFORMULA(CS_SUM_SL_D_TOTAL IN NUMBER
64 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
65
66 FUNCTION CF_SUM_SL_C_TOTAL_DSPFORMULA(CS_SUM_SL_C_TOTAL IN NUMBER
67 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
68
69 FUNCTION CF_SUM_DL_D_TOTAL_DSPFORMULA(CS_SUM_DL_D_TOTAL IN NUMBER
70 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
71
72 FUNCTION CF_SUM_DL_C_TOTAL_DSPFORMULA(CS_SUM_DL_C_TOTAL IN NUMBER
73 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
74
75 FUNCTION CF_MISMATCH_REPORT_DSPFORMULA(CS_SUM_DL_D_TOTAL IN NUMBER
76 ,CS_SUM_SL_D_TOTAL IN NUMBER
77 ,CS_SUM_DL_C_TOTAL IN NUMBER
78 ,CS_SUM_SL_C_TOTAL IN NUMBER) RETURN CHAR;
79
80 FUNCTION CF_SUM_DL_D_PERSON_DSPFORMULA(SUM_DL_D_PERSON IN NUMBER
81 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
82
83 FUNCTION CF_SUM_DL_C_PERSON_DSPFORMULA(SUM_DL_C_PERSON IN NUMBER
84 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
85
86 FUNCTION CF_SL_DEBIT_AMOUNT_DSPFORMULA(SL_DEBIT_AMOUNT IN NUMBER
87 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
88
89 FUNCTION CF_SL_CREDIT_AMOUNT_DSPFORMULA(SL_CREDIT_AMOUNT IN NUMBER
90 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
91
92 FUNCTION CF_SUM_DL_D_ASSG_DSPFORMULA(SUM_DL_D_ASSG IN NUMBER
93 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
94
95 FUNCTION CF_SUM_DL_C_ASSG_DSPFORMULA(SUM_DL_C_ASSG IN NUMBER
96 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
97
98 FUNCTION CF_DL_CREDIT_AMOUNT_DSPFORMULA(DL_CREDIT_AMOUNT IN NUMBER
99 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
100
101 FUNCTION CF_DL_DEBIT_AMOUNT_DSPFORMULA(DL_DEBIT_AMOUNT IN NUMBER
102 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
103
104 FUNCTION AFTERREPORT RETURN BOOLEAN;
105
106 PROCEDURE PUT(NAME IN VARCHAR2
107 ,VAL IN VARCHAR2);
108
109 FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
110
111 PROCEDURE GET(NAME IN VARCHAR2
112 ,VAL OUT NOCOPY VARCHAR2);
113
114 FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
115
116 FUNCTION SAVE_USER(X_NAME IN VARCHAR2
117 ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
118
119 FUNCTION SAVE(X_NAME IN VARCHAR2
120 ,X_VALUE IN VARCHAR2
121 ,X_LEVEL_NAME IN VARCHAR2
122 ,X_LEVEL_VALUE IN VARCHAR2
123 ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
124
125 PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
126 ,USER_ID_Z IN NUMBER
127 ,RESPONSIBILITY_ID_Z IN NUMBER
128 ,APPLICATION_ID_Z IN NUMBER
129 ,VAL_Z OUT NOCOPY VARCHAR2
130 ,DEFINED_Z OUT NOCOPY BOOLEAN);
131
132 FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
133 ,USER_ID IN NUMBER
134 ,RESPONSIBILITY_ID IN NUMBER
135 ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
136
137 PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
138 ,RESPONSIBILITY_ID_Z IN NUMBER
139 ,APPLICATION_ID_Z IN NUMBER
140 ,SITE_ID_Z IN NUMBER);
141
142 PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
143 ,VALS IN VARCHAR2
144 ,NUM IN NUMBER);
145
146 END PSP_PSPRCSLD_XMLP_PKG;