1 PACKAGE PAY_PAYGBACT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYGBACTS.pls 120.0 2008/01/07 15:33:06 srikrish noship $ */
3 P_BUSINESS_GROUP_ID NUMBER;
4
5 P_SESSION_DATE DATE;
6 P_SESSION_DATE_T VARCHAR2(40);
7
8 P_CONC_REQUEST_ID NUMBER;
9
10 P_ELEMENT_NAME VARCHAR2(12);
11
12 P_START_DATE DATE;
13 P_START_DATE_T VARCHAR2(40);
14
15 P_PERSON_ID NUMBER;
16
17 PERSON_ID VARCHAR2(40);
18
19 SESSION_DATE DATE;
20
21 C_BUSINESS_GROUP_NAME VARCHAR2(240);
22
23 C_REPORT_SUBTITLE VARCHAR2(60);
24
25 C_PERSON_NAME VARCHAR2(500) := 'All Employees';
26
27 FUNCTION BEFOREREPORT RETURN BOOLEAN;
28
29 FUNCTION GET_STAT_PERIOD_START(ASSIGNMENT_ACTION_ID IN NUMBER) RETURN DATE;
30
31 FUNCTION GET_NI_PTD(ASSIGNMENT_ACTION_ID IN NUMBER
32 ,ELEMENT_NAME IN VARCHAR2
33 ,INPUT_NAME IN VARCHAR2) RETURN NUMBER;
34
35 FUNCTION GET_NI_YTD(ASSIGNMENT_ACTION_ID IN NUMBER
36 ,ELEMENT_NAME IN VARCHAR2
37 ,INPUT_NAME IN VARCHAR2) RETURN NUMBER;
38
39 FUNCTION BEFOREPFORM RETURN BOOLEAN;
40
41 FUNCTION AFTERPFORM RETURN BOOLEAN;
42
43 FUNCTION BETWEENPAGE RETURN BOOLEAN;
44
45 FUNCTION AFTERREPORT RETURN BOOLEAN;
46
47 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
48
49 FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
50
51 FUNCTION C_PERSON_NAME_P RETURN VARCHAR2;
52
53 FUNCTION GET_BUDGET(P_BUDGET_ID IN NUMBER) RETURN VARCHAR2;
54
55 FUNCTION GET_BUDGET_VERSION(P_BUDGET_ID IN NUMBER
56 ,P_BUDGET_VERSION_ID IN NUMBER) RETURN VARCHAR2;
57
58 PROCEDURE GET_ORGANIZATION(P_ORGANIZATION_ID IN NUMBER
59 ,P_ORG_NAME OUT NOCOPY VARCHAR2
60 ,P_ORG_TYPE OUT NOCOPY VARCHAR2);
61
62 FUNCTION GET_JOB(P_JOB_ID IN NUMBER) RETURN VARCHAR2;
63
64 FUNCTION GET_POSITION(P_POSITION_ID IN NUMBER) RETURN VARCHAR2;
65
66 FUNCTION GET_GRADE(P_GRADE_ID IN NUMBER) RETURN VARCHAR2;
67
68 FUNCTION GET_STATUS(P_BUSINESS_GROUP_ID IN NUMBER
69 ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER
70 ,P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
71
72 FUNCTION GET_ABS_TYPE(P_ABS_ATT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
73
74 PROCEDURE GET_TIME_PERIOD(P_TIME_PERIOD_ID IN NUMBER
75 ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
76 ,P_START_DATE OUT NOCOPY DATE
77 ,P_END_DATE OUT NOCOPY DATE);
78
79 FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
80
81 FUNCTION COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID IN NUMBER
82 ,P_PARENT_ORGANIZATION_ID IN NUMBER) RETURN NUMBER;
83
84 FUNCTION COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID IN NUMBER
85 ,P_PARENT_POSITION_ID IN NUMBER) RETURN NUMBER;
86
87 PROCEDURE GET_ORGANIZATION_HIERARCHY(P_ORGANIZATION_STRUCTURE_ID IN NUMBER
88 ,P_ORG_STRUCTURE_VERSION_ID IN NUMBER
89 ,P_ORG_STRUCTURE_NAME OUT NOCOPY VARCHAR2
90 ,P_ORG_VERSION OUT NOCOPY NUMBER
91 ,P_VERSION_START_DATE OUT NOCOPY DATE
92 ,P_VERSION_END_DATE OUT NOCOPY DATE);
93
94 PROCEDURE GET_POSITION_HIERARCHY(P_POSITION_STRUCTURE_ID IN NUMBER
95 ,P_POS_STRUCTURE_VERSION_ID IN NUMBER
96 ,P_POS_STRUCTURE_NAME OUT NOCOPY VARCHAR2
97 ,P_POS_VERSION OUT NOCOPY NUMBER
98 ,P_VERSION_START_DATE OUT NOCOPY DATE
99 ,P_VERSION_END_DATE OUT NOCOPY DATE);
100
101 FUNCTION GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
102 ,P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2;
103
104 FUNCTION PERSON_MATCHING_SKILLS(P_PERSON_ID IN NUMBER
105 ,P_JOB_POSITION_ID IN NUMBER
106 ,P_JOB_POSITION_TYPE IN VARCHAR2
107 ,P_MATCHING_LEVEL IN VARCHAR2
108 ,P_NO_OF_ESSENTIAL IN NUMBER
109 ,P_NO_OF_DESIRABLE IN NUMBER) RETURN BOOLEAN;
110
111 FUNCTION GET_PAYROLL_NAME(P_SESSION_DATE IN DATE
112 ,P_PAYROLL_ID IN NUMBER) RETURN VARCHAR2;
113
114 FUNCTION GET_ELEMENT_NAME(P_SESSION_DATE IN DATE
115 ,P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2;
116
117 PROCEDURE GEN_PARTIAL_MATCHING_LEXICAL(P_CONCATENATED_SEGMENTS IN VARCHAR2
118 ,P_ID_FLEX_NUM IN NUMBER
119 ,P_MATCHING_LEXICAL IN OUT NOCOPY VARCHAR2);
120
121 PROCEDURE GET_ATTRIBUTES(P_CONCATENATED_SEGMENTS IN VARCHAR2
122 ,P_NAME IN VARCHAR2
123 ,P_SEGMENTS_USED OUT NOCOPY NUMBER
124 ,P_VALUE1 OUT NOCOPY VARCHAR2
125 ,P_VALUE2 OUT NOCOPY VARCHAR2
126 ,P_VALUE3 OUT NOCOPY VARCHAR2
127 ,P_VALUE4 OUT NOCOPY VARCHAR2
128 ,P_VALUE5 OUT NOCOPY VARCHAR2
129 ,P_VALUE6 OUT NOCOPY VARCHAR2
130 ,P_VALUE7 OUT NOCOPY VARCHAR2
131 ,P_VALUE8 OUT NOCOPY VARCHAR2
132 ,P_VALUE9 OUT NOCOPY VARCHAR2
133 ,P_VALUE10 OUT NOCOPY VARCHAR2
134 ,P_VALUE11 OUT NOCOPY VARCHAR2
135 ,P_VALUE12 OUT NOCOPY VARCHAR2
136 ,P_VALUE13 OUT NOCOPY VARCHAR2
137 ,P_VALUE14 OUT NOCOPY VARCHAR2
138 ,P_VALUE15 OUT NOCOPY VARCHAR2
139 ,P_VALUE16 OUT NOCOPY VARCHAR2
140 ,P_VALUE17 OUT NOCOPY VARCHAR2
141 ,P_VALUE18 OUT NOCOPY VARCHAR2
142 ,P_VALUE19 OUT NOCOPY VARCHAR2
143 ,P_VALUE20 OUT NOCOPY VARCHAR2
144 ,P_VALUE21 OUT NOCOPY VARCHAR2
145 ,P_VALUE22 OUT NOCOPY VARCHAR2
146 ,P_VALUE23 OUT NOCOPY VARCHAR2
147 ,P_VALUE24 OUT NOCOPY VARCHAR2
148 ,P_VALUE25 OUT NOCOPY VARCHAR2
149 ,P_VALUE26 OUT NOCOPY VARCHAR2
150 ,P_VALUE27 OUT NOCOPY VARCHAR2
151 ,P_VALUE28 OUT NOCOPY VARCHAR2
152 ,P_VALUE29 OUT NOCOPY VARCHAR2
153 ,P_VALUE30 OUT NOCOPY VARCHAR2);
154
155 PROCEDURE GET_SEGMENTS(P_CONCATENATED_SEGMENTS IN VARCHAR2
156 ,P_ID_FLEX_NUM IN NUMBER
157 ,P_SEGMENTS_USED OUT NOCOPY NUMBER
158 ,P_VALUE1 OUT NOCOPY VARCHAR2
159 ,P_VALUE2 OUT NOCOPY VARCHAR2
160 ,P_VALUE3 OUT NOCOPY VARCHAR2
161 ,P_VALUE4 OUT NOCOPY VARCHAR2
162 ,P_VALUE5 OUT NOCOPY VARCHAR2
163 ,P_VALUE6 OUT NOCOPY VARCHAR2
164 ,P_VALUE7 OUT NOCOPY VARCHAR2
165 ,P_VALUE8 OUT NOCOPY VARCHAR2
166 ,P_VALUE9 OUT NOCOPY VARCHAR2
167 ,P_VALUE10 OUT NOCOPY VARCHAR2
168 ,P_VALUE11 OUT NOCOPY VARCHAR2
169 ,P_VALUE12 OUT NOCOPY VARCHAR2
170 ,P_VALUE13 OUT NOCOPY VARCHAR2
171 ,P_VALUE14 OUT NOCOPY VARCHAR2
172 ,P_VALUE15 OUT NOCOPY VARCHAR2
173 ,P_VALUE16 OUT NOCOPY VARCHAR2
174 ,P_VALUE17 OUT NOCOPY VARCHAR2
175 ,P_VALUE18 OUT NOCOPY VARCHAR2
176 ,P_VALUE19 OUT NOCOPY VARCHAR2
177 ,P_VALUE20 OUT NOCOPY VARCHAR2
178 ,P_VALUE21 OUT NOCOPY VARCHAR2
179 ,P_VALUE22 OUT NOCOPY VARCHAR2
180 ,P_VALUE23 OUT NOCOPY VARCHAR2
181 ,P_VALUE24 OUT NOCOPY VARCHAR2
182 ,P_VALUE25 OUT NOCOPY VARCHAR2
183 ,P_VALUE26 OUT NOCOPY VARCHAR2
184 ,P_VALUE27 OUT NOCOPY VARCHAR2
185 ,P_VALUE28 OUT NOCOPY VARCHAR2
186 ,P_VALUE29 OUT NOCOPY VARCHAR2
187 ,P_VALUE30 OUT NOCOPY VARCHAR2);
188
189 PROCEDURE GET_DESC_FLEX(P_APPL_SHORT_NAME IN VARCHAR2
190 ,P_DESC_FLEX_NAME IN VARCHAR2
191 ,P_TABLE_ALIAS IN VARCHAR2
192 ,P_TITLE OUT NOCOPY VARCHAR2
193 ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
194 ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2);
195
196 PROCEDURE GET_DESC_FLEX_CONTEXT(P_APPL_SHORT_NAME IN VARCHAR2
197 ,P_DESC_FLEX_NAME IN VARCHAR2
198 ,P_TABLE_ALIAS IN VARCHAR2
199 ,P_TITLE OUT NOCOPY VARCHAR2
200 ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
201 ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2);
202
203 PROCEDURE GET_DVLPR_DESC_FLEX(P_APPL_SHORT_NAME IN VARCHAR2
204 ,P_DESC_FLEX_NAME IN VARCHAR2
205 ,P_DESC_FLEX_CONTEXT IN VARCHAR2
206 ,P_TABLE_ALIAS IN VARCHAR2
207 ,P_TITLE OUT NOCOPY VARCHAR2
208 ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
209 ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2);
210
211 FUNCTION GET_PERSON_NAME(P_SESSION_DATE IN DATE
212 ,P_PERSON_ID IN NUMBER) RETURN VARCHAR2;
213
214 PROCEDURE SET_CONTEXT(P_CONTEXT_NAME IN VARCHAR2
215 ,P_CONTEXT_VALUE IN VARCHAR2);
216
217 FUNCTION RUN_DB_ITEM(P_DATABASE_NAME IN VARCHAR2
218 ,P_BUS_GROUP_ID IN NUMBER
219 ,P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
220
221 FUNCTION CHECK_BAL_EXPIRY(P_BAL_OWNER_ASG_ACTION IN NUMBER
222 ,P_ASSIGNMENT_ACTION_ID IN NUMBER
223 ,P_DIMENSION_NAME IN VARCHAR2
224 ,P_EXPIRY_CHECKING_LEVEL IN VARCHAR2
225 ,P_EXPIRY_CHECKING_CODE IN VARCHAR2
226 ,P_BAL_CONTEXT_STR IN VARCHAR2) RETURN BOOLEAN;
227
228 FUNCTION GET_VALUE(P_DEFINED_BALANCE_ID IN NUMBER
229 ,P_ASSIGNMENT_ACTION_ID IN NUMBER) RETURN NUMBER;
230
231 FUNCTION GET_VALUE(P_DEFINED_BALANCE_ID IN NUMBER
232 ,P_ASSIGNMENT_ACTION_ID IN NUMBER
233 ,P_ALWAYS_GET_DB_ITEM IN BOOLEAN) RETURN NUMBER;
234
235 FUNCTION GET_VALUE(P_DEFINED_BALANCE_ID IN NUMBER
236 ,P_ASSIGNMENT_ID IN NUMBER
237 ,P_VIRTUAL_DATE IN DATE) RETURN NUMBER;
238
239 FUNCTION GET_VALUE(P_DEFINED_BALANCE_ID IN NUMBER
240 ,P_ASSIGNMENT_ID IN NUMBER
241 ,P_VIRTUAL_DATE IN DATE
242 ,P_ALWAYS_GET_DB_ITEM IN BOOLEAN) RETURN NUMBER;
243
244 FUNCTION GET_VALUE_LOCK(P_DEFINED_BALANCE_ID IN NUMBER
245 ,P_ASSIGNMENT_ID IN NUMBER
246 ,P_VIRTUAL_DATE IN DATE
247 ,P_ASG_LOCK IN VARCHAR2) RETURN NUMBER;
248
249 FUNCTION GET_VALUE_LOCK(P_DEFINED_BALANCE_ID IN NUMBER
250 ,P_ASSIGNMENT_ID IN NUMBER
251 ,P_VIRTUAL_DATE IN DATE
252 ,P_ALWAYS_GET_DB_ITEM IN BOOLEAN
253 ,P_ASG_LOCK IN VARCHAR2) RETURN NUMBER;
254
255 END PAY_PAYGBACT_XMLP_PKG;