1 PACKAGE PSP_PSPRCDLS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPRCDLSS.pls 120.6 2008/01/30 07:46:08 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_END_DATE DATE;
16
17 P_SET_OF_BOOKS_ID NUMBER;
18
19 CP_CREDIT_AMOUNT_DL NUMBER;
20
21 CP_SUSPENSE VARCHAR2(500);
22
23 FUNCTION CF_ASSIGNMENT_NUMBERFORMULA(ASSIGNMENT_ID IN NUMBER) RETURN VARCHAR2;
24
25 FUNCTION CF_PERSON_NAMEFORMULA(PERSON_ID IN NUMBER) RETURN VARCHAR2;
26
27 FUNCTION AFTERPFORM RETURN BOOLEAN;
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_CHARGING_INSTRUCTIONSFORMUL(GL_CODE_COMBINATION_ID IN NUMBER
45 ,PROJECT_ID IN NUMBER
46 ,TASK_ID IN NUMBER
47 ,AWARD_ID IN NUMBER
48 ,EXPENDITURE_ORGANIZATION_ID IN NUMBER
49 ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR;
50
51 FUNCTION CF_ORG_REPORTFORMULA RETURN VARCHAR2;
52
53 FUNCTION BEFOREREPORT RETURN BOOLEAN;
54
55 FUNCTION CF_TIME_PERIODFORMULA RETURN VARCHAR2;
56
57 FUNCTION CF_SOURCE_TYPEFORMULA RETURN VARCHAR2;
58
59 FUNCTION CF_1FORMULA(CURRENCY_CODE IN VARCHAR2
60 ,PERSON_ID IN NUMBER
61 ,ASSIGNMENT_ID IN NUMBER
62 ,GL_CODE_COMBINATION_ID IN NUMBER
63 ,PROJECT_ID IN NUMBER
64 ,TASK_ID IN NUMBER
65 ,AWARD_ID IN NUMBER
66 ,EXPENDITURE_TYPE IN VARCHAR2
67 ,EXPENDITURE_ORGANIZATION_ID IN NUMBER) RETURN NUMBER;
68
69 FUNCTION CF_AMT_SL_CFORMULA(GL_CODE_COMBINATION_ID IN NUMBER
70 ,SL_CREDIT_AMOUNT IN NUMBER) RETURN NUMBER;
71
72 FUNCTION CF_CURRENCY_FORMATFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
73
74 FUNCTION CF_CURRENCY_CODEFORMULA(CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
75
76 FUNCTION CF_SUM_SL_D_TOTAL_DSPFORMULA(CS_SUM_SL_D_TOTAL IN NUMBER
77 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
78
79 FUNCTION CF_SUM_SL_C_TOTAL_DSPFORMULA(CS_SUM_SL_C_TOTAL IN NUMBER
80 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
81
82 FUNCTION CF_SUM_DL_D_TOTAL_DSPFORMULA(CS_SUM_DL_D_TOTAL IN NUMBER
83 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
84
85 FUNCTION CF_SUM_DL_C_TOTAL_DSPFORMULA(CS_SUM_DL_C_TOTAL IN NUMBER
86 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
87
88 FUNCTION CF_MISMATCH_TOTAL_DSPFORMULA(CS_SUM_DL_D_TOTAL IN NUMBER
89 ,CS_SUM_SL_D_TOTAL IN NUMBER
90 ,CS_SUM_DL_C_TOTAL IN NUMBER
91 ,CS_SUM_SL_C_TOTAL IN NUMBER) RETURN CHAR;
92
93 FUNCTION CF_SUM_SL_D_PERSON_DSPFORMULA(SUM_SL_D_PERSON IN NUMBER
94 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
95
96 FUNCTION CF_SUM_SL_C_PERSON_DSPFORMULA(SUM_SL_C_PERSON IN NUMBER
97 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
98
99 FUNCTION CF_SUM_DL_D_PERSON_DSPFORMULA(SUM_DL_D_PERSON IN NUMBER
100 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
101
102 FUNCTION CF_SUM_DL_C_PERSON_DSPFORMULA(SUM_DL_C_PERSON IN NUMBER
103 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
104
105 FUNCTION CF_SUM_SL_D_ASSG_DSPFORMULA(SUM_SL_D_ASSG IN NUMBER
106 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
107
108 FUNCTION CF_SUM_SL_C_ASSG_DSPFORMULA(SUM_SL_C_ASSG IN NUMBER
109 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
110
111 FUNCTION CF_SUM_DL_D_ASSG_DSPFORMULA(SUM_DL_D_ASSG IN NUMBER
112 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
113
114 FUNCTION CF_SUM_DL_C_ASSG_DSPFORMULA(SUM_DL_C_ASSG IN NUMBER
115 ,CF_CURRENCY_FORMAT IN VARCHAR2
116 ,SUM_SL_C_ASSG IN NUMBER) RETURN CHAR;
117
118 FUNCTION CF_SL_DEBIT_AMOUNT_DSPFORMULA(SL_DEBIT_AMOUNT IN NUMBER
119 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
120
121 FUNCTION CF_AMT_SL_C_DSPFORMULA(CF_AMT_SL_C IN NUMBER
122 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
123
124 FUNCTION CF_CREDIT_AMOUNT_DL_DSPFORMULA(CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
125
126 FUNCTION CF_1_DSPFORMULA(CF_1 IN NUMBER
127 ,CF_CURRENCY_FORMAT IN VARCHAR2) RETURN CHAR;
128
129 FUNCTION CF_MISMATCH_LINEFORMULA(CF_1 IN NUMBER
130 ,SL_DEBIT_AMOUNT IN NUMBER
131 ,CF_AMT_SL_C IN NUMBER) RETURN CHAR;
132
133 FUNCTION AFTERREPORT RETURN BOOLEAN;
134
135 FUNCTION CP_CREDIT_AMOUNT_DL_P RETURN NUMBER;
136
137 FUNCTION CP_SUSPENSE_P RETURN VARCHAR2;
138
139 PROCEDURE GET_ANNUAL_SALARY(P_ASSIGNMENT_ID IN NUMBER
140 ,P_SESSION_DATE IN DATE
141 ,P_ANNUAL_SALARY OUT NOCOPY NUMBER);
142
143 PROCEDURE GET_GL_CCID(P_PAYROLL_ID IN NUMBER
144 ,P_SET_OF_BOOKS_ID IN NUMBER
145 ,P_COST_KEYFLEX_ID IN NUMBER
146 ,X_GL_CCID OUT NOCOPY NUMBER);
147
148 FUNCTION BUSINESS_DAYS(LOW_DATE IN DATE
149 ,HIGH_DATE IN DATE) RETURN NUMBER;
150
151 FUNCTION GET_GL_DESCRIPTION(A_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2;
152
153 PROCEDURE PUT(NAME IN VARCHAR2
154 ,VAL IN VARCHAR2);
155
156 FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN;
157
158 PROCEDURE GET(NAME IN VARCHAR2
159 ,VAL OUT NOCOPY VARCHAR2);
160
161 FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2;
162
163 FUNCTION SAVE_USER(X_NAME IN VARCHAR2
164 ,X_VALUE IN VARCHAR2) RETURN BOOLEAN;
165
166 FUNCTION SAVE(X_NAME IN VARCHAR2
167 ,X_VALUE IN VARCHAR2
168 ,X_LEVEL_NAME IN VARCHAR2
169 ,X_LEVEL_VALUE IN VARCHAR2
170 ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN;
171
172 PROCEDURE GET_SPECIFIC(NAME_Z IN VARCHAR2
173 ,USER_ID_Z IN NUMBER
174 ,RESPONSIBILITY_ID_Z IN NUMBER
175 ,APPLICATION_ID_Z IN NUMBER
176 ,VAL_Z OUT NOCOPY VARCHAR2
177 ,DEFINED_Z OUT NOCOPY BOOLEAN);
178
179 FUNCTION VALUE_SPECIFIC(NAME IN VARCHAR2
180 ,USER_ID IN NUMBER
181 ,RESPONSIBILITY_ID IN NUMBER
182 ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2;
183
184 PROCEDURE INITIALIZE(USER_ID_Z IN NUMBER
185 ,RESPONSIBILITY_ID_Z IN NUMBER
186 ,APPLICATION_ID_Z IN NUMBER
187 ,SITE_ID_Z IN NUMBER);
188
189 PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
190 ,VALS IN VARCHAR2
191 ,NUM IN NUMBER);
192
193 END PSP_PSPRCDLS_XMLP_PKG;