[Home] [Help]
PACKAGE: APPS.PQH_MGMT_RPT_PKG
Source
1 PACKAGE pqh_mgmt_rpt_pkg AUTHID CURRENT_USER AS
2 /* $Header: pqmgtpkg.pkh 115.8 2003/04/03 19:45:52 kgowripe noship $ */
3 --
4 --
5 FUNCTION get_position_actual_cmmtmnts
6 (
7 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
8 p_position_id IN per_positions.position_id%TYPE,
9 p_start_date IN pqh_budgets.budget_start_date%TYPE,
10 p_end_date IN pqh_budgets.budget_end_date%TYPE,
11 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
12 p_value_type IN varchar2 DEFAULT 'T',
13 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
14 )
15 RETURN NUMBER;
16 --
17 --
18 FUNCTION get_assignment_actuals
19 (
20 p_assignment_id IN number,
21 p_element_type_id IN number default NULL,
22 p_actuals_start_date IN date,
23 p_actuals_end_date IN date,
24 p_unit_of_measure_id IN number
25 )
26 RETURN NUMBER;
27 --
28 --
29 FUNCTION get_assignment_commitment
30 (
31 p_assignment_id IN number,
32 p_budget_version_id IN number default NULL,
33 p_period_start_date IN date,
34 p_period_end_date IN date,
35 p_unit_of_measure_id IN number
36 )
37 RETURN NUMBER;
38 --
39 --
40 FUNCTION get_position_budget_amt
41 (
42 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
43 p_position_id IN per_positions.position_id%TYPE,
44 p_start_date IN pqh_budgets.budget_start_date%TYPE,
45 p_end_date IN pqh_budgets.budget_end_date%TYPE,
46 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
47 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
48 )
49 RETURN NUMBER;
50 --
51 --
52 FUNCTION get_posn_element_bdgt_amt
53 (
54 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
55 p_position_id IN per_positions.position_id%TYPE,
56 p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
57 p_start_date IN pqh_budgets.budget_start_date%TYPE,
58 p_end_date IN pqh_budgets.budget_end_date%TYPE,
59 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
60 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
61 )
62 RETURN NUMBER;
63 --
64 --
65 FUNCTION get_posn_bset_bdgt_amt
66 (
67 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
68 p_position_id IN per_positions.position_id%TYPE,
69 p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
70 p_start_date IN pqh_budgets.budget_start_date%TYPE,
71 p_end_date IN pqh_budgets.budget_end_date%TYPE,
72 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
73 )
74 RETURN NUMBER;
75 --
76 --
77 FUNCTION get_posn_elmnt_actual_cmmtmnts
78 (
79 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
80 p_position_id IN per_positions.position_id%TYPE,
81 p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
82 p_start_date IN pqh_budgets.budget_start_date%TYPE,
83 p_end_date IN pqh_budgets.budget_end_date%TYPE,
84 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
85 p_value_type IN varchar2 DEFAULT 'T',
86 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
87 )
88 RETURN NUMBER;
89 --
90 --
91 FUNCTION get_posn_bset_actual_cmmtmnts
92 (
93 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
94 p_position_id IN per_positions.position_id%TYPE,
95 p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
96 p_start_date IN pqh_budgets.budget_start_date%TYPE,
97 p_end_date IN pqh_budgets.budget_end_date%TYPE,
98 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
99 p_value_type IN varchar2 DEFAULT 'T'
100 )
101 RETURN NUMBER;
102 --
103 --
104 --
105 FUNCTION get_org_posn_budget_amt
106 (
107 p_organization_id IN pqh_budget_details.organization_id%TYPE,
108 p_start_date IN pqh_budgets.budget_start_date%TYPE,
109 p_end_date IN pqh_budgets.budget_end_date%TYPE,
110 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
111 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
112 )
113 RETURN NUMBER;
114 --
115 --
116 FUNCTION get_org_posn_actual_cmmtmnts
117 (
118 p_organization_id IN pqh_budget_details.organization_id%TYPE,
119 p_start_date IN pqh_budgets.budget_start_date%TYPE,
120 p_end_date IN pqh_budgets.budget_end_date%TYPE,
121 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
122 p_value_type IN varchar2 DEFAULT 'T',
123 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
124 )
125 RETURN NUMBER;
126 --
127 --
128 FUNCTION get_bgrp_posn_budget_amt
129 (
130 p_business_group_id IN pqh_budgets.business_group_id%TYPE,
131 p_start_date IN pqh_budgets.budget_start_date%TYPE,
132 p_end_date IN pqh_budgets.budget_end_date%TYPE,
133 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
134 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
135 )
136 RETURN NUMBER;
137 --
138 --
139 FUNCTION get_bgrp_posn_actual_cmmtmnts
140 (
141 p_business_group_id IN pqh_budgets.business_group_id%TYPE,
142 p_start_date IN pqh_budgets.budget_start_date%TYPE,
143 p_end_date IN pqh_budgets.budget_end_date%TYPE,
144 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
145 p_value_type IN varchar2 DEFAULT 'T',
146 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
147 )
148 RETURN NUMBER;
149 --
150 --
151 FUNCTION get_elem_posn_budget_amt
152 (
153 p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
154 p_start_date IN pqh_budgets.budget_start_date%TYPE,
155 p_end_date IN pqh_budgets.budget_end_date%TYPE,
156 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
157 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
158 )
159 RETURN NUMBER;
160 --
161 --
162 FUNCTION get_elem_posn_actual_cmmtmnts
163 (
164 p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
165 p_start_date IN pqh_budgets.budget_start_date%TYPE,
166 p_end_date IN pqh_budgets.budget_end_date%TYPE,
167 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
168 p_value_type IN varchar2 DEFAULT 'T',
169 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
170 )
171 RETURN NUMBER;
172 --
173 --
174 FUNCTION get_position_type
175 (
176 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
177 p_position_id IN per_positions.position_id%TYPE,
178 p_start_date IN pqh_budgets.budget_start_date%TYPE,
179 p_end_date IN pqh_budgets.budget_end_date%TYPE,
180 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
181 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
182 )
183 RETURN VARCHAR2;
184 --
185 --
186
187 FUNCTION check_pos_type_and_variance
188 (
189 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
190 p_position_id IN per_positions.position_id%TYPE,
191 p_start_date IN pqh_budgets.budget_start_date%TYPE,
192 p_end_date IN pqh_budgets.budget_end_date%TYPE,
193 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
194 p_position_type IN VARCHAR2 DEFAULT 'Y',
195 p_variance_prcnt IN NUMBER DEFAULT 0,
196 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
197 )
198 RETURN VARCHAR2;
199 --
200 --
201 FUNCTION check_ent_type_and_variance
202 (
203 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
204 p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
205 p_entity_id IN pqh_budget_details.position_id%TYPE,
206 p_start_date IN pqh_budgets.budget_start_date%TYPE,
207 p_end_date IN pqh_budgets.budget_end_date%TYPE,
208 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
209 p_entity_type IN VARCHAR2 DEFAULT 'Y',
210 p_variance_prcnt IN NUMBER DEFAULT 0,
211 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
212 )
213 RETURN VARCHAR2;
214 --
215 --
216
217 FUNCTION get_ent_element_bdgt_amt
218 (
219 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
220 p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
221 p_entity_id IN pqh_budget_details.position_id%TYPE,
222 p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
223 p_start_date IN pqh_budgets.budget_start_date%TYPE,
224 p_end_date IN pqh_budgets.budget_end_date%TYPE,
225 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
226 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
227 )
228
229 RETURN NUMBER;
230 --
231 --
232 FUNCTION get_ent_elmnt_actual_cmmtmnts
233 (
234 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
235 p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
236 p_entity_id IN pqh_budget_details.position_id%TYPE,
237 p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
238 p_start_date IN pqh_budgets.budget_start_date%TYPE,
239 p_end_date IN pqh_budgets.budget_end_date%TYPE,
240 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
241 p_value_type IN varchar2 DEFAULT 'T',
242 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
243 )
244 RETURN NUMBER;
245 --
246 --
247 FUNCTION get_elem_ent_budget_amt
248 (
249 p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
250 p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
251 p_start_date IN pqh_budgets.budget_start_date%TYPE,
252 p_end_date IN pqh_budgets.budget_end_date%TYPE,
253 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
254 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
255 )
256 RETURN NUMBER;
257 --
258 --
259 FUNCTION get_elem_ent_actual_cmmtmnts
260 (
261 p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
262 p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
263 p_start_date IN pqh_budgets.budget_start_date%TYPE,
264 p_end_date IN pqh_budgets.budget_end_date%TYPE,
265 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
266 p_value_type IN varchar2 DEFAULT 'T',
267 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
268 )
269 RETURN NUMBER;
270 --
271 --
272 FUNCTION get_pos_org
273 (
274 p_position_id IN hr_all_positions_f.position_id%TYPE
275 )
276 RETURN VARCHAR2;
277 --
278 --
279 -- mvankada
280 FUNCTION get_entity_actual_cmmtmnts
281 (
282 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
283 p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
284 p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
285 p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
286 p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
287 p_start_date IN pqh_budgets.budget_start_date%TYPE,
288 p_end_date IN pqh_budgets.budget_end_date%TYPE,
289 p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
290 p_value_type IN varchar2 DEFAULT 'T',
291 p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
292 )
293 RETURN NUMBER;
294
295 Function GET_ENTITY_BUDGET_AMT( p_budgeted_entity_cd IN varchar2,
296 p_entity_id IN Number,
297 p_budget_version_id IN Number,
298 p_start_date IN DATE,
299 p_end_date IN DATE,
300 p_unit_of_measure_id IN Number) Return Number;
301 END pqh_mgmt_rpt_pkg;