[Home] [Help]
PACKAGE BODY: APPS.HRI_OLTP_PMV_LBRCSTHDCNT_GRAPH
Source
1 PACKAGE BODY HRI_OLTP_PMV_LBRCSTHDCNT_GRAPH AS
2 /* $Header: hrioplhg.pkb 120.9 2005/12/16 03:54:29 rlpatil noship $ */
3
4
5 l_currency VARCHAR2(10);
6 l_rateType VARCHAR2(10);
7
8
9 -- ----------------------------------------------------
10 -- This procedure frames the Query for the Report Labor Cost with Headcount Trend.
11 -- ----------------------------------------------------
12
13 PROCEDURE GET_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
14 x_custom_sql OUT NOCOPY VARCHAR2,
15 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
16
17 l_sqltext VARCHAR2(32767);
18 l_custom_rec BIS_QUERY_ATTRIBUTES;
19 l_trend_table VARCHAR2(4000);
20 l_previous_periods NUMBER;
21 l_projection_periods NUMBER;
22
23 /* Parameter values */
24 l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
25 l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
26
27
28 BEGIN
29
30 /* Initialize out parameters */
31
32 l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
33 x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34
35
36 /* Get common parameter values */
37 hri_oltp_pmv_util_param.get_parameters_from_table
38 (p_page_parameter_tbl => p_page_parameter_tbl,
39 p_parameter_rec => l_parameter_rec,
40 p_bind_tab => l_bind_tab);
41
42 HRI_OLTP_PMV_QUERY_TIME.GET_TIME_CLAUSE
43 (p_projection_type => 'N'
44 ,p_page_period_type => l_parameter_rec.page_period_type
45 ,p_page_comp_type => l_parameter_rec.time_comparison_type
46 ,o_trend_table => l_trend_table
47 ,o_previous_periods => l_previous_periods
48 ,o_projection_periods => l_projection_periods );
49
50
51 l_currency:= l_parameter_rec.currency_code;
52
53 IF l_currency =bis_common_parameters.get_currency_code THEN
54 l_rateType:=bis_common_parameters.get_rate_type;
55 ELSIF l_currency =bis_common_parameters.get_secondary_currency_code THEN
56 l_rateType:=bis_common_parameters.get_secondary_rate_type;
57 END IF;
58
59 /* Build query */
60 l_sqltext :=
61 'SELECT --Labor Cost with Headcount Trend
62 hc.period_as_of_date VIEWBYID
63 ,hc.period_as_of_date VIEWBY
64 ,hc.period_order HRI_P_ORDER_BY_1
65 ,hc.period_as_of_date HRI_P_GRAPH_X_LABEL_TIME
66 ,x.budgeted_amount HRI_P_MEASURE1
67 ,x.actual_amount + x.committed_amount HRI_P_MEASURE2
68 ,hc.budgeted HRI_P_MEASURE3
69 ,hc.actual HRI_P_MEASURE4
70 ,to_char(hc.period_as_of_date,''DD/MM/YYYY'') HRI_P_CHAR1_GA
71 FROM
72 (
73 SELECT b.period_as_of_date,
74 b.period_order,
75 b.budgeted_amount,
76 a.actual_amount,
77 a.committed_amount
78 FROM
79 (
80 SELECT prds.period_as_of_date
81 ,prds.period_order
82 ,hri_oltp_view_currency.convert_currency_amount
83 (bgt.CURRENCY_CODE,
84 '''||l_currency||''',
85 &BIS_CURRENT_ASOF_DATE,
86 SUM(BUDGET_VALUE),
87 '''||l_rateType||''') budgeted_amount
88 FROM ' || l_trend_table || ' prds,
89 HRI_MDP_BDGTS_LBRCST_MV bgt
90 WHERE bgt.ORGMGR_ID(+) = &HRI_PERSON+HRI_PER_USRDR_H
91 AND prds.period_start_date <= bgt.EFFECTIVE_END_DATE(+)
92 AND prds.period_end_date >= bgt.EFFECTIVE_START_DATE(+)
93 GROUP BY prds.period_as_of_date,
94 prds.period_order,
95 bgt.CURRENCY_CODE ) b,
96 (
97 SELECT prds.period_as_of_date
98 ,prds.period_order
99 ,hri_oltp_view_currency.convert_currency_amount
100 (act.CURRENCY_CODE,
101 '''||l_currency||''',
102 &BIS_CURRENT_ASOF_DATE,
103 sum(act.ACTUAL_VALUE),
104 '''||l_rateType||''') actual_amount
105 ,hri_oltp_view_currency.convert_currency_amount
106 (act.CURRENCY_CODE,
107 '''||l_currency||''',
108 &BIS_CURRENT_ASOF_DATE,
109 sum(act.COMMITMENT_VALUE),
110 '''||l_rateType||''') committed_amount
111 FROM ' || l_trend_table || ' prds,
112 HRI_MDP_CMNTS_ACTLS_MV act
113 WHERE act.ORGMGR_ID(+) = &HRI_PERSON+HRI_PER_USRDR_H
114 AND prds.period_start_date <= act.EFFECTIVE_END_DATE(+)
115 AND prds.period_end_date >= act.EFFECTIVE_START_DATE(+)
116 GROUP BY prds.period_as_of_date,
117 prds.period_order,
118 act.CURRENCY_CODE ) a
119 WHERE a.period_as_of_date = b.period_as_of_date) x,
120 (
121 SELECT a.period_as_of_date,
122 a.period_order,
123 b.total budgeted,
124 a.total actual
125 FROM
126 (
127 SELECT prds.period_as_of_date
128 ,prds.period_order
129 ,NVL(sum(act.total_headcount),0) total
130 FROM ' || l_trend_table || ' prds,
131 HRI_MDP_WRKFC_MV act
132 WHERE prds.PERIOD_AS_OF_DATE BETWEEN act.EFFECTIVE_START_DATE(+) AND act.EFFECTIVE_END_DATE(+)
133 AND act.ORGMGR_ID(+) = &HRI_PERSON+HRI_PER_USRDR_H
134 GROUP BY prds.period_as_of_date,
135 prds.period_order )a,
136 (
137 SELECT period_as_of_date
138 ,period_order
139 ,SUM(TOTAL) TOTAL
140 FROM
141 (
142 SELECT prds.period_as_of_date
143 ,prds.period_order
144 ,bgt.ORGANIZATION_ID
145 ,bgt.POSITION_ID
146 ,CASE WHEN bgt.BUDGET_AGGREGATE = ''ACCUMULATE'' THEN SUM(bgt.HEADCOUNT_VALUE)
147 WHEN bgt.BUDGET_AGGREGATE = ''AVERAGE'' THEN AVG(bgt.HEADCOUNT_VALUE)
148 WHEN bgt.BUDGET_AGGREGATE = ''MAXIMUM'' THEN MAX(bgt.HEADCOUNT_VALUE)
149 ELSE SUM(bgt.HEADCOUNT_VALUE)
150 END TOTAL
151 FROM ' || l_trend_table || ' prds,
152 HRI_MDP_BDGTS_HDCNT_ORGMGR_CT bgt
153 WHERE bgt.ORGMGR_ID(+) = &HRI_PERSON+HRI_PER_USRDR_H
154 AND prds.period_start_date <= bgt.EFFECTIVE_END_DATE(+)
155 AND prds.period_end_date >= bgt.EFFECTIVE_START_DATE(+)
156 GROUP BY prds.period_as_of_date,
157 prds.period_order,
158 bgt.BUDGET_AGGREGATE,
159 bgt.ORGANIZATION_ID,
160 bgt.POSITION_ID
161 )
162 GROUP BY period_as_of_date,
163 period_order
164 )b
165 WHERE a.period_as_of_date=b.period_as_of_date ) hc
166 WHERE hc.period_as_of_date = x.period_as_of_date
167 ORDER BY hc.period_as_of_date
168 ';
169
170 x_custom_sql := l_SQLText;
171
172 l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
173 l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
174 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
175 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
176 x_custom_output.extend;
177 x_custom_output(1) := l_custom_rec;
178
179 l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
180 l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
181 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
182 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
183 x_custom_output.extend;
184 x_custom_output(2) := l_custom_rec;
185
186 l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
187 l_custom_rec.attribute_value := l_previous_periods;
188 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
189 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
190 x_custom_output.extend;
191 x_custom_output(3) := l_custom_rec;
192
193 l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
194 l_custom_rec.attribute_value := l_parameter_rec.currency_code;
195 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
196 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
197 x_custom_output.extend;
198 x_custom_output(4) := l_custom_rec;
199
200 l_custom_rec.attribute_name := ':GLOBAL_RATE';
201 l_custom_rec.attribute_value := l_parameter_rec.rate_type;
202 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
203 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
204 x_custom_output.extend;
205 x_custom_output(5) := l_custom_rec;
206
207 END GET_SQL;
208
209 -- ----------------------------------------------------
210 -- This procedure frames the Query for the Report Budgeted and Projected Labor Cost Trend.
211 -- ----------------------------------------------------
212
213
214 PROCEDURE GET_LBRCST_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
215 x_custom_sql OUT NOCOPY VARCHAR2,
216 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
217
218 l_sqltext VARCHAR2(32767);
219 l_custom_rec BIS_QUERY_ATTRIBUTES;
220 l_trend_table VARCHAR2(4000);
221 l_previous_periods NUMBER;
222 l_projection_periods NUMBER;
223
224 /* Parameter values */
225 l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
226 l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
227
228
229 BEGIN
230
231 /* Initialize out parameters */
232
233 l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
234 x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
235
236
237 /* Get common parameter values */
238 hri_oltp_pmv_util_param.get_parameters_from_table
239 (p_page_parameter_tbl => p_page_parameter_tbl,
240 p_parameter_rec => l_parameter_rec,
241 p_bind_tab => l_bind_tab);
242
243 HRI_OLTP_PMV_QUERY_TIME.GET_TIME_CLAUSE
244 (p_projection_type => 'N'
245 ,p_page_period_type => l_parameter_rec.page_period_type
246 ,p_page_comp_type => l_parameter_rec.time_comparison_type
247 ,o_trend_table => l_trend_table
248 ,o_previous_periods => l_previous_periods
249 ,o_projection_periods => l_projection_periods );
250
251
252 l_currency:= l_parameter_rec.currency_code;
253
254 IF l_currency =bis_common_parameters.get_currency_code THEN
255 l_rateType:=bis_common_parameters.get_rate_type;
256 ELSIF l_currency =bis_common_parameters.get_secondary_currency_code THEN
257 l_rateType:=bis_common_parameters.get_secondary_rate_type;
258 END IF;
259
260
261
262 /* Build query */
263 l_sqltext :=
264 'SELECT --Budgeted and Projected Labor Cost Trend
265 a.period_as_of_date VIEWBYID
266 ,a.period_as_of_date VIEWBY
267 ,a.period_order HRI_P_ORDER_BY_1
268 ,a.period_as_of_date HRI_P_GRAPH_X_LABEL_TIME
269 ,b.budgeted_amount HRI_P_MEASURE2
270 ,a.actual_amount + a.committed_amount HRI_P_MEASURE4
271 ,to_char(a.period_as_of_date,''DD/MM/YYYY'') HRI_P_CHAR1_GA
272 FROM
273 (
274 SELECT prds.period_as_of_date
275 ,prds.period_order
276 ,hri_oltp_view_currency.convert_currency_amount
277 (bgt.CURRENCY_CODE,
278 '''||l_currency||''',
279 &BIS_CURRENT_ASOF_DATE,
280 SUM(BUDGET_VALUE),
281 '''||l_rateType||''') budgeted_amount
282 FROM ' || l_trend_table || ' prds,
283 HRI_MDP_BDGTS_LBRCST_ORG_MV bgt
284 WHERE bgt.ORGMGR_ID(+) = &HRI_PERSON+HRI_PER_USRDR_H
285 AND prds.period_start_date <= bgt.EFFECTIVE_END_DATE(+)
286 AND prds.period_end_date >= bgt.EFFECTIVE_START_DATE(+)
287 GROUP BY prds.period_as_of_date,
288 prds.period_order,
289 bgt.CURRENCY_CODE ) b,
290 (
291 SELECT prds.period_as_of_date
292 ,prds.period_order
293 ,hri_oltp_view_currency.convert_currency_amount
294 (act.CURRENCY_CODE,
295 '''||l_currency||''',
296 &BIS_CURRENT_ASOF_DATE,
297 sum(act.ACTUAL_VALUE),
298 '''||l_rateType||''') actual_amount
299 ,hri_oltp_view_currency.convert_currency_amount
300 (act.CURRENCY_CODE,
301 '''||l_currency||''',
302 &BIS_CURRENT_ASOF_DATE,
303 sum(act.COMMITMENT_VALUE),
304 '''||l_rateType||''') committed_amount
305 FROM ' || l_trend_table || ' prds,
306 HRI_MDP_CMNTS_ACTLS_ORG_MV act
307 WHERE act.ORGMGR_ID(+) = &HRI_PERSON+HRI_PER_USRDR_H
308 AND prds.period_start_date <= act.EFFECTIVE_END_DATE(+)
309 AND prds.period_end_date >= act.EFFECTIVE_START_DATE(+)
310 GROUP BY prds.period_as_of_date,
311 prds.period_order,
312 act.CURRENCY_CODE)a
313 WHERE b.PERIOD_AS_OF_DATE=a.PERIOD_AS_OF_DATE
314 ORDER BY a.period_as_of_date
315 ';
316
317 x_custom_sql := l_SQLText;
318
319 l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
320 l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
321 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
322 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
323 x_custom_output.extend;
324 x_custom_output(1) := l_custom_rec;
325
326 l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
327 l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
328 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
329 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
330 x_custom_output.extend;
331 x_custom_output(2) := l_custom_rec;
332
333 l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
334 l_custom_rec.attribute_value := l_previous_periods;
335 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
336 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
337 x_custom_output.extend;
338 x_custom_output(3) := l_custom_rec;
339
340 l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
341 l_custom_rec.attribute_value := l_parameter_rec.currency_code;
342 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
343 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
344 x_custom_output.extend;
345 x_custom_output(4) := l_custom_rec;
346
347 l_custom_rec.attribute_name := ':GLOBAL_RATE';
348 l_custom_rec.attribute_value := l_parameter_rec.rate_type;
349 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
350 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
351 x_custom_output.extend;
352 x_custom_output(5) := l_custom_rec;
353
354 END GET_LBRCST_SQL;
355
356
357 -- ----------------------------------------------------
358 -- This procedure frames the Query for the Report Budgeted and Actual Headcount Trend.
359 -- ----------------------------------------------------
360
361 PROCEDURE GET_HDCNT_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
362 x_custom_sql OUT NOCOPY VARCHAR2,
363 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
364
365 l_sqltext VARCHAR2(32767);
366 l_custom_rec BIS_QUERY_ATTRIBUTES;
367 l_trend_table VARCHAR2(4000);
368 l_previous_periods NUMBER;
369 l_projection_periods NUMBER;
370
371 /* Parameter values */
372 l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
373 l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
374
375
376 BEGIN
377
381 x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
378 /* Initialize out parameters */
379
380 l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
382
383
384 /* Get common parameter values */
385 hri_oltp_pmv_util_param.get_parameters_from_table
386 (p_page_parameter_tbl => p_page_parameter_tbl,
387 p_parameter_rec => l_parameter_rec,
388 p_bind_tab => l_bind_tab);
389
390
391 HRI_OLTP_PMV_QUERY_TIME.GET_TIME_CLAUSE
392 (p_projection_type => 'N'
393 ,p_page_period_type => l_parameter_rec.page_period_type
394 ,p_page_comp_type => l_parameter_rec.time_comparison_type
395 ,o_trend_table => l_trend_table
396 ,o_previous_periods => l_previous_periods
397 ,o_projection_periods => l_projection_periods );
398
399
400 /* Build query */
401 l_sqltext :=
402 'SELECT -- Headcount Budget Trend
403 a.period_as_of_date VIEWBYID
404 ,a.period_as_of_date VIEWBY
405 ,a.period_order HRI_P_ORDER_BY_1
406 ,a.period_as_of_date HRI_P_GRAPH_X_LABEL_TIME
407 ,b.total HRI_P_MEASURE1
408 ,a.total HRI_P_MEASURE2
409 ,to_char(a.period_as_of_date,''DD/MM/YYYY'') HRI_P_CHAR1_GA
410 FROM
411 (
412 SELECT prds.period_as_of_date
413 ,prds.period_order
414 ,NVL(sum(act.total_headcount),0) total
415 FROM ' || l_trend_table || ' prds,
416 HRI_MDP_WRKFC_MV act
417 WHERE prds.PERIOD_AS_OF_DATE BETWEEN act.EFFECTIVE_START_DATE(+) AND act.EFFECTIVE_END_DATE(+)
418 AND act.ORGMGR_ID(+) = &HRI_PERSON+HRI_PER_USRDR_H
419 Group by prds.PERIOD_AS_OF_DATE
420 ,prds.PERIOD_ORDER )a,
421 (
422 SELECT period_as_of_date
423 ,period_order
424 ,SUM(TOTAL) TOTAL
425 FROM
426 (
427 SELECT prds.period_as_of_date
428 ,prds.period_order
429 ,bgt.ORGANIZATION_ID
430 ,bgt.POSITION_ID
431 ,CASE WHEN bgt.BUDGET_AGGREGATE = ''ACCUMULATE'' THEN SUM(bgt.HEADCOUNT_VALUE)
432 WHEN bgt.BUDGET_AGGREGATE = ''AVERAGE'' THEN AVG(bgt.HEADCOUNT_VALUE)
433 WHEN bgt.BUDGET_AGGREGATE = ''MAXIMUM'' THEN MAX(bgt.HEADCOUNT_VALUE)
434 ELSE SUM(bgt.HEADCOUNT_VALUE)
435 END TOTAL
436 FROM ' || l_trend_table || ' prds,
437 HRI_MDP_BDGTS_HDCNT_ORGMGR_CT bgt
438 WHERE bgt.ORGMGR_ID(+) = &HRI_PERSON+HRI_PER_USRDR_H
439 AND prds.period_start_date <= bgt.EFFECTIVE_END_DATE(+)
440 AND prds.period_end_date >= bgt.EFFECTIVE_START_DATE(+)
441 GROUP BY prds.period_as_of_date,
442 prds.period_order,
443 bgt.BUDGET_AGGREGATE,
444 bgt.ORGANIZATION_ID,
445 bgt.POSITION_ID
446 )
447 GROUP BY period_as_of_date,
448 period_order
449 )b
450 WHERE a.period_as_of_date=b.period_as_of_date
451 ORDER BY a.period_as_of_date';
452
453 x_custom_sql := l_SQLText;
454
455 l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
456 l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
457 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
458 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
459 x_custom_output.extend;
460 x_custom_output(1) := l_custom_rec;
461
462 l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
463 l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
464 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
465 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
466 x_custom_output.extend;
467 x_custom_output(2) := l_custom_rec;
468
469 l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
470 l_custom_rec.attribute_value := l_previous_periods;
471 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
472 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
473 x_custom_output.extend;
474 x_custom_output(3) := l_custom_rec;
475
476 l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
477 l_custom_rec.attribute_value := l_parameter_rec.currency_code;
478 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
479 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
480 x_custom_output.extend;
481 x_custom_output(4) := l_custom_rec;
482
483 l_custom_rec.attribute_name := ':GLOBAL_RATE';
484 l_custom_rec.attribute_value := l_parameter_rec.rate_type;
485 l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
486 l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
487 x_custom_output.extend;
488 x_custom_output(5) := l_custom_rec;
489
490 END GET_HDCNT_SQL;
491
492 END HRI_OLTP_PMV_LBRCSTHDCNT_GRAPH;
493