eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_FS_TECH_UTL_RPT_PKG dependencies on ISC_FS_RPT_UTIL_PKG

Line 15: isc_fs_rpt_util_pkg.bind_group_id

11: begin
12:
13: if p_report_type = 'ACTUAL_HRS' then
14:
15: isc_fs_rpt_util_pkg.bind_group_id
16: ( p_dim_bmap
17: , p_custom_output
18: , isc_fs_rpt_util_pkg.G_TASK_TYPE
19: );

Line 18: , isc_fs_rpt_util_pkg.G_TASK_TYPE

14:
15: isc_fs_rpt_util_pkg.bind_group_id
16: ( p_dim_bmap
17: , p_custom_output
18: , isc_fs_rpt_util_pkg.G_TASK_TYPE
19: );
20:
21: -- R12 resource type
22: return '(

Line 67: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

63: , x_custom_output out nocopy bis_query_attributes_tbl
64: )
65: is
66:
67: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
68: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
69: l_custom_output bis_query_attributes_tbl;
70: l_curr_suffix varchar2(3);
71: l_where_clause varchar2(10000);

Line 92: isc_fs_rpt_util_pkg.register_dimension_levels

88: l_to_date_type varchar2(20);
89:
90: begin
91:
92: isc_fs_rpt_util_pkg.register_dimension_levels
93: ( l_dimension_tbl
94: , l_dim_filter_map
95: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
96: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

Line 95: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'

91:
92: isc_fs_rpt_util_pkg.register_dimension_levels
93: ( l_dimension_tbl
94: , l_dim_filter_map
95: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
96: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
97: );
98:
99: isc_fs_rpt_util_pkg.check_district_filter

Line 96: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

92: isc_fs_rpt_util_pkg.register_dimension_levels
93: ( l_dimension_tbl
94: , l_dim_filter_map
95: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
96: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
97: );
98:
99: isc_fs_rpt_util_pkg.check_district_filter
100: ( p_param

Line 99: isc_fs_rpt_util_pkg.check_district_filter

95: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
96: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
97: );
98:
99: isc_fs_rpt_util_pkg.check_district_filter
100: ( p_param
101: , l_dim_filter_map
102: );
103:

Line 104: isc_fs_rpt_util_pkg.process_parameters

100: ( p_param
101: , l_dim_filter_map
102: );
103:
104: isc_fs_rpt_util_pkg.process_parameters
105: ( p_param => p_param
106: , p_dimension_tbl => l_dimension_tbl
107: , p_dim_filter_map => l_dim_filter_map
108: , p_trend => 'N'

Line 125: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value

121: else
122: l_to_date_type := 'RLX';
123: end if;
124:
125: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value
126: ( p_param
127: , 'VIEW_BY'
128: );
129:

Line 176: l_mv_tbl(2).mv_where := replace(l_where_clause, '&' || isc_fs_rpt_util_pkg.G_TASK_TYPE, '-999');

172:
173: l_mv_tbl.extend;
174: l_mv_tbl(2).mv_name := 'MV_PLACEHOLDER2';
175: l_mv_tbl(2).mv_col := l_col_tbl2;
176: l_mv_tbl(2).mv_where := replace(l_where_clause, '&' || isc_fs_rpt_util_pkg.G_TASK_TYPE, '-999');
177: l_mv_tbl(2).in_join_tbls := NULL;
178: l_mv_tbl(2).use_grp_id := 'N';
179:
180: l_stmt := poa_dbi_template_pkg.union_all_status_sql

Line 209: if l_view_by = isc_fs_rpt_util_pkg.G_TASK_TYPE then /* If View by Task Type, Total Plan hours are distributed to each task type */

205: );
206:
207: l_stmt := replace( l_stmt, 'MV_PLACEHOLDER2', l_mv );
208:
209: if l_view_by = isc_fs_rpt_util_pkg.G_TASK_TYPE then /* If View by Task Type, Total Plan hours are distributed to each task type */
210: l_cur_planned_hours := 'c_Total_Planned_Hrs_total' ;
211: l_prev_planned_hours := 'p_Total_Planned_Hrs_total';
212: else
213: l_cur_planned_hours := 'c_Total_Planned_Hrs' ;

Line 242: , ' || isc_fs_rpt_util_pkg.get_district_drill_down

238: , ISC_MEASURE_20
239: , ISC_MEASURE_21
240: , ISC_MEASURE_22
241: , ISC_MEASURE_23
242: , ' || isc_fs_rpt_util_pkg.get_district_drill_down
243: ( l_view_by
244: , 'ISC_FS_TECH_UTL_TBL_REP'
245: , 'ISC_ATTRIBUTE_2' ) || '
246: from (

Line 248: row_number() over(&ORDER_BY_CLAUSE nulls last, '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk

244: , 'ISC_FS_TECH_UTL_TBL_REP'
245: , 'ISC_ATTRIBUTE_2' ) || '
246: from (
247: select
248: row_number() over(&ORDER_BY_CLAUSE nulls last, '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
249: , iset.*
250: from ( select * from (
251: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
252: , ' || isc_fs_rpt_util_pkg.rate_column

Line 251: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '

247: select
248: row_number() over(&ORDER_BY_CLAUSE nulls last, '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
249: , iset.*
250: from ( select * from (
251: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
252: , ' || isc_fs_rpt_util_pkg.rate_column
253: ( 'p_Total_Act_Hrs'
254: , l_prev_planned_hours
255: , 'ISC_MEASURE_1'

Line 252: , ' || isc_fs_rpt_util_pkg.rate_column

248: row_number() over(&ORDER_BY_CLAUSE nulls last, '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
249: , iset.*
250: from ( select * from (
251: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
252: , ' || isc_fs_rpt_util_pkg.rate_column
253: ( 'p_Total_Act_Hrs'
254: , l_prev_planned_hours
255: , 'ISC_MEASURE_1'
256: ) || '

Line 257: , ' || isc_fs_rpt_util_pkg.rate_column

253: ( 'p_Total_Act_Hrs'
254: , l_prev_planned_hours
255: , 'ISC_MEASURE_1'
256: ) || '
257: , ' || isc_fs_rpt_util_pkg.rate_column
258: ( 'c_Total_Act_Hrs'
259: , l_cur_planned_hours
260: , 'ISC_MEASURE_2'
261: ) || '

Line 262: , ' || isc_fs_rpt_util_pkg.change_column

258: ( 'c_Total_Act_Hrs'
259: , l_cur_planned_hours
260: , 'ISC_MEASURE_2'
261: ) || '
262: , ' || isc_fs_rpt_util_pkg.change_column
263: ( isc_fs_rpt_util_pkg.rate_column
264: ( 'c_Total_Act_Hrs'
265: , l_cur_planned_hours
266: , null

Line 263: ( isc_fs_rpt_util_pkg.rate_column

259: , l_cur_planned_hours
260: , 'ISC_MEASURE_2'
261: ) || '
262: , ' || isc_fs_rpt_util_pkg.change_column
263: ( isc_fs_rpt_util_pkg.rate_column
264: ( 'c_Total_Act_Hrs'
265: , l_cur_planned_hours
266: , null
267: )

Line 268: , isc_fs_rpt_util_pkg.rate_column

264: ( 'c_Total_Act_Hrs'
265: , l_cur_planned_hours
266: , null
267: )
268: , isc_fs_rpt_util_pkg.rate_column
269: ( 'p_Total_Act_Hrs'
270: , l_prev_planned_hours
271: , null
272: )

Line 277: , ' || isc_fs_rpt_util_pkg.rate_column

273: , 'ISC_MEASURE_3'
274: , 'N'
275: ) || '
276: , nvl(c_Total_Planned_Hrs,0) ISC_MEASURE_13
277: , ' || isc_fs_rpt_util_pkg.rate_column
278: ( 'p_Labor_Hrs'
279: , l_prev_planned_hours
280: , 'ISC_MEASURE_6'
281: ) || '

Line 282: , ' || isc_fs_rpt_util_pkg.rate_column

278: ( 'p_Labor_Hrs'
279: , l_prev_planned_hours
280: , 'ISC_MEASURE_6'
281: ) || '
282: , ' || isc_fs_rpt_util_pkg.rate_column
283: ( 'p_Travel_Hrs'
284: , l_cur_planned_hours
285: , 'ISC_MEASURE_10'
286: ) || '

Line 288: , ' || isc_fs_rpt_util_pkg.rate_column

284: , l_cur_planned_hours
285: , 'ISC_MEASURE_10'
286: ) || '
287: , nvl(c_Labor_Hrs,0) ISC_MEASURE_5
288: , ' || isc_fs_rpt_util_pkg.rate_column
289: ( 'c_Labor_Hrs'
290: , l_cur_planned_hours
291: , 'ISC_MEASURE_7'
292: ) || '

Line 293: , ' || isc_fs_rpt_util_pkg.change_column

289: ( 'c_Labor_Hrs'
290: , l_cur_planned_hours
291: , 'ISC_MEASURE_7'
292: ) || '
293: , ' || isc_fs_rpt_util_pkg.change_column
294: ( isc_fs_rpt_util_pkg.rate_column
295: ( 'c_Labor_Hrs'
296: , l_cur_planned_hours
297: , null

Line 294: ( isc_fs_rpt_util_pkg.rate_column

290: , l_cur_planned_hours
291: , 'ISC_MEASURE_7'
292: ) || '
293: , ' || isc_fs_rpt_util_pkg.change_column
294: ( isc_fs_rpt_util_pkg.rate_column
295: ( 'c_Labor_Hrs'
296: , l_cur_planned_hours
297: , null
298: )

Line 299: , isc_fs_rpt_util_pkg.rate_column

295: ( 'c_Labor_Hrs'
296: , l_cur_planned_hours
297: , null
298: )
299: , isc_fs_rpt_util_pkg.rate_column
300: ( 'p_Labor_Hrs'
301: , l_prev_planned_hours
302: , null
303: )

Line 308: , ' || isc_fs_rpt_util_pkg.rate_column

304: , 'ISC_MEASURE_8'
305: , 'N'
306: ) || '
307: , nvl(c_Travel_Hrs,0) ISC_MEASURE_9
308: , ' || isc_fs_rpt_util_pkg.rate_column
309: ( 'c_Travel_Hrs'
310: , l_cur_planned_hours
311: , 'ISC_MEASURE_11'
312: ) || '

Line 313: , ' || isc_fs_rpt_util_pkg.change_column

309: ( 'c_Travel_Hrs'
310: , l_cur_planned_hours
311: , 'ISC_MEASURE_11'
312: ) || '
313: , ' || isc_fs_rpt_util_pkg.change_column
314: ( isc_fs_rpt_util_pkg.rate_column
315: ( 'c_Travel_Hrs'
316: , l_cur_planned_hours
317: , null

Line 314: ( isc_fs_rpt_util_pkg.rate_column

310: , l_cur_planned_hours
311: , 'ISC_MEASURE_11'
312: ) || '
313: , ' || isc_fs_rpt_util_pkg.change_column
314: ( isc_fs_rpt_util_pkg.rate_column
315: ( 'c_Travel_Hrs'
316: , l_cur_planned_hours
317: , null
318: )

Line 319: , isc_fs_rpt_util_pkg.rate_column

315: ( 'c_Travel_Hrs'
316: , l_cur_planned_hours
317: , null
318: )
319: , isc_fs_rpt_util_pkg.rate_column
320: ( 'p_Travel_Hrs'
321: , l_prev_planned_hours
322: , null
323: )

Line 327: , ' || isc_fs_rpt_util_pkg.rate_column

323: )
324: , 'ISC_MEASURE_12'
325: , 'N'
326: ) || '
327: , ' || isc_fs_rpt_util_pkg.rate_column
328: ( 'p_Total_Act_Hrs_total'
329: , 'p_Total_Planned_Hrs_total'
330: , 'ISC_MEASURE_15'
331: ) || '

Line 332: , ' || isc_fs_rpt_util_pkg.rate_column

328: ( 'p_Total_Act_Hrs_total'
329: , 'p_Total_Planned_Hrs_total'
330: , 'ISC_MEASURE_15'
331: ) || '
332: , ' || isc_fs_rpt_util_pkg.rate_column
333: ( 'c_Total_Act_Hrs_total'
334: , 'c_Total_Planned_Hrs_total'
335: , 'ISC_MEASURE_16'
336: ) || '

Line 337: , ' || isc_fs_rpt_util_pkg.change_column

333: ( 'c_Total_Act_Hrs_total'
334: , 'c_Total_Planned_Hrs_total'
335: , 'ISC_MEASURE_16'
336: ) || '
337: , ' || isc_fs_rpt_util_pkg.change_column
338: ( isc_fs_rpt_util_pkg.rate_column
339: ( 'c_Total_Act_Hrs_total'
340: , 'c_Total_Planned_Hrs_total'
341: , null

Line 338: ( isc_fs_rpt_util_pkg.rate_column

334: , 'c_Total_Planned_Hrs_total'
335: , 'ISC_MEASURE_16'
336: ) || '
337: , ' || isc_fs_rpt_util_pkg.change_column
338: ( isc_fs_rpt_util_pkg.rate_column
339: ( 'c_Total_Act_Hrs_total'
340: , 'c_Total_Planned_Hrs_total'
341: , null
342: )

Line 343: , isc_fs_rpt_util_pkg.rate_column

339: ( 'c_Total_Act_Hrs_total'
340: , 'c_Total_Planned_Hrs_total'
341: , null
342: )
343: , isc_fs_rpt_util_pkg.rate_column
344: ( 'p_Total_Act_Hrs_total'
345: , 'p_Total_Planned_Hrs_total'
346: , null
347: )

Line 353: , ' || isc_fs_rpt_util_pkg.rate_column

349: , 'N'
350: ) || '
351: , nvl(c_Total_Planned_Hrs_total,0) ISC_MEASURE_24
352: , nvl(c_Labor_Hrs_total,0) ISC_MEASURE_18
353: , ' || isc_fs_rpt_util_pkg.rate_column
354: ( 'c_Labor_Hrs_total'
355: , 'c_Total_Planned_Hrs_total'
356: , 'ISC_MEASURE_19'
357: ) || '

Line 358: , ' || isc_fs_rpt_util_pkg.change_column

354: ( 'c_Labor_Hrs_total'
355: , 'c_Total_Planned_Hrs_total'
356: , 'ISC_MEASURE_19'
357: ) || '
358: , ' || isc_fs_rpt_util_pkg.change_column
359: ( isc_fs_rpt_util_pkg.rate_column
360: ( 'c_Labor_Hrs_total'
361: , 'c_Total_Planned_Hrs_total'
362: , null

Line 359: ( isc_fs_rpt_util_pkg.rate_column

355: , 'c_Total_Planned_Hrs_total'
356: , 'ISC_MEASURE_19'
357: ) || '
358: , ' || isc_fs_rpt_util_pkg.change_column
359: ( isc_fs_rpt_util_pkg.rate_column
360: ( 'c_Labor_Hrs_total'
361: , 'c_Total_Planned_Hrs_total'
362: , null
363: )

Line 364: , isc_fs_rpt_util_pkg.rate_column

360: ( 'c_Labor_Hrs_total'
361: , 'c_Total_Planned_Hrs_total'
362: , null
363: )
364: , isc_fs_rpt_util_pkg.rate_column
365: ( 'p_Labor_Hrs_total'
366: , 'p_Total_Planned_Hrs_total'
367: , null
368: )

Line 373: , ' || isc_fs_rpt_util_pkg.rate_column

369: , 'ISC_MEASURE_20'
370: , 'N'
371: ) || '
372: , nvl(c_Travel_Hrs_total,0) ISC_MEASURE_21
373: , ' || isc_fs_rpt_util_pkg.rate_column
374: ( 'c_Travel_Hrs_total'
375: , 'c_Total_Planned_Hrs_total'
376: , 'ISC_MEASURE_22'
377: ) || '

Line 378: , ' || isc_fs_rpt_util_pkg.change_column

374: ( 'c_Travel_Hrs_total'
375: , 'c_Total_Planned_Hrs_total'
376: , 'ISC_MEASURE_22'
377: ) || '
378: , ' || isc_fs_rpt_util_pkg.change_column
379: ( isc_fs_rpt_util_pkg.rate_column
380: ( 'c_Travel_Hrs_total'
381: , 'c_Total_Planned_Hrs_total'
382: , null

Line 379: ( isc_fs_rpt_util_pkg.rate_column

375: , 'c_Total_Planned_Hrs_total'
376: , 'ISC_MEASURE_22'
377: ) || '
378: , ' || isc_fs_rpt_util_pkg.change_column
379: ( isc_fs_rpt_util_pkg.rate_column
380: ( 'c_Travel_Hrs_total'
381: , 'c_Total_Planned_Hrs_total'
382: , null
383: )

Line 384: , isc_fs_rpt_util_pkg.rate_column

380: ( 'c_Travel_Hrs_total'
381: , 'c_Total_Planned_Hrs_total'
382: , null
383: )
384: , isc_fs_rpt_util_pkg.rate_column
385: ( 'p_Travel_Hrs_total'
386: , 'p_Total_Planned_Hrs_total'
387: , null
388: )

Line 396: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);

392: from (' || l_stmt;
393:
394:
395: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
396: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
397:
398: poa_dbi_util_pkg.get_custom_rolling_binds
399: ( p_custom_output => l_custom_output
400: , p_xtd => l_xtd

Line 405: isc_fs_rpt_util_pkg.enhance_time_join

401: );
402:
403: x_custom_output := l_custom_output;
404:
405: isc_fs_rpt_util_pkg.enhance_time_join
406: ( l_stmt
407: , 'N'
408: );
409:

Line 422: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

418: , x_custom_output out nocopy bis_query_attributes_tbl
419: )
420: is
421:
422: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
423: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
424: l_custom_output bis_query_attributes_tbl;
425: l_curr_suffix varchar2(3);
426: l_where_clause varchar2(10000);

Line 442: isc_fs_rpt_util_pkg.register_dimension_levels

438: l_to_date_type varchar2(20);
439:
440: begin
441:
442: isc_fs_rpt_util_pkg.register_dimension_levels
443: ( l_dimension_tbl
444: , l_dim_filter_map
445: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
446: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

Line 445: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'

441:
442: isc_fs_rpt_util_pkg.register_dimension_levels
443: ( l_dimension_tbl
444: , l_dim_filter_map
445: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
446: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
447: );
448:
449: isc_fs_rpt_util_pkg.check_district_filter

Line 446: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

442: isc_fs_rpt_util_pkg.register_dimension_levels
443: ( l_dimension_tbl
444: , l_dim_filter_map
445: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
446: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
447: );
448:
449: isc_fs_rpt_util_pkg.check_district_filter
450: ( p_param

Line 449: isc_fs_rpt_util_pkg.check_district_filter

445: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
446: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
447: );
448:
449: isc_fs_rpt_util_pkg.check_district_filter
450: ( p_param
451: , l_dim_filter_map
452: );
453:

Line 454: isc_fs_rpt_util_pkg.process_parameters

450: ( p_param
451: , l_dim_filter_map
452: );
453:
454: isc_fs_rpt_util_pkg.process_parameters
455: ( p_param => p_param
456: , p_dimension_tbl => l_dimension_tbl
457: , p_dim_filter_map => l_dim_filter_map
458: , p_trend => 'Y'

Line 524: l_mv_tbl(2).mv_where := replace(l_where_clause, '&' || isc_fs_rpt_util_pkg.G_TASK_TYPE, '-999');

520:
521: l_mv_tbl.extend;
522: l_mv_tbl(2).mv_name := 'MV_PLACEHOLDER2';
523: l_mv_tbl(2).mv_col := l_col_tbl2;
524: l_mv_tbl(2).mv_where := replace(l_where_clause, '&' || isc_fs_rpt_util_pkg.G_TASK_TYPE, '-999');
525: l_mv_tbl(2).in_join_tbls := NULL;
526: l_mv_tbl(2).use_grp_id := 'N';
527: l_mv_tbl(2).mv_xtd := l_xtd;
528:

Line 556: , ' || isc_fs_rpt_util_pkg.rate_column

552: l_stmt := replace( l_stmt, 'MV_PLACEHOLDER2', l_mv );
553:
554: l_stmt := 'select
555: cal_name VIEWBY ' || '
556: , ' || isc_fs_rpt_util_pkg.rate_column
557: ( 'p_Total_Act_Hrs'
558: , 'p_Total_Planned_Hrs'
559: , 'ISC_MEASURE_1'
560: ) || '

Line 561: , ' || isc_fs_rpt_util_pkg.rate_column

557: ( 'p_Total_Act_Hrs'
558: , 'p_Total_Planned_Hrs'
559: , 'ISC_MEASURE_1'
560: ) || '
561: , ' || isc_fs_rpt_util_pkg.rate_column
562: ( 'c_Total_Act_Hrs'
563: , 'c_Total_Planned_Hrs'
564: , 'ISC_MEASURE_2'
565: ) || '

Line 566: , ' || isc_fs_rpt_util_pkg.change_column

562: ( 'c_Total_Act_Hrs'
563: , 'c_Total_Planned_Hrs'
564: , 'ISC_MEASURE_2'
565: ) || '
566: , ' || isc_fs_rpt_util_pkg.change_column
567: ( isc_fs_rpt_util_pkg.rate_column
568: ( 'c_Total_Act_Hrs'
569: , 'c_Total_Planned_Hrs'
570: , null

Line 567: ( isc_fs_rpt_util_pkg.rate_column

563: , 'c_Total_Planned_Hrs'
564: , 'ISC_MEASURE_2'
565: ) || '
566: , ' || isc_fs_rpt_util_pkg.change_column
567: ( isc_fs_rpt_util_pkg.rate_column
568: ( 'c_Total_Act_Hrs'
569: , 'c_Total_Planned_Hrs'
570: , null
571: )

Line 572: , isc_fs_rpt_util_pkg.rate_column

568: ( 'c_Total_Act_Hrs'
569: , 'c_Total_Planned_Hrs'
570: , null
571: )
572: , isc_fs_rpt_util_pkg.rate_column
573: ( 'p_Total_Act_Hrs'
574: , 'p_Total_Planned_Hrs'
575: , null
576: )

Line 580: , ' || isc_fs_rpt_util_pkg.rate_column

576: )
577: , 'ISC_MEASURE_3'
578: , 'N'
579: ) || '
580: , ' || isc_fs_rpt_util_pkg.rate_column
581: ( 'p_Labor_Hrs'
582: , 'p_Total_Planned_Hrs'
583: , 'ISC_MEASURE_6'
584: ) || '

Line 585: , ' || isc_fs_rpt_util_pkg.rate_column

581: ( 'p_Labor_Hrs'
582: , 'p_Total_Planned_Hrs'
583: , 'ISC_MEASURE_6'
584: ) || '
585: , ' || isc_fs_rpt_util_pkg.rate_column
586: ( 'c_Labor_Hrs'
587: , 'c_Total_Planned_Hrs'
588: , 'ISC_MEASURE_7'
589: ) || '

Line 590: , ' || isc_fs_rpt_util_pkg.change_column

586: ( 'c_Labor_Hrs'
587: , 'c_Total_Planned_Hrs'
588: , 'ISC_MEASURE_7'
589: ) || '
590: , ' || isc_fs_rpt_util_pkg.change_column
591: ( isc_fs_rpt_util_pkg.rate_column
592: ( 'c_Labor_Hrs'
593: , 'c_Total_Planned_Hrs'
594: , null

Line 591: ( isc_fs_rpt_util_pkg.rate_column

587: , 'c_Total_Planned_Hrs'
588: , 'ISC_MEASURE_7'
589: ) || '
590: , ' || isc_fs_rpt_util_pkg.change_column
591: ( isc_fs_rpt_util_pkg.rate_column
592: ( 'c_Labor_Hrs'
593: , 'c_Total_Planned_Hrs'
594: , null
595: )

Line 596: , isc_fs_rpt_util_pkg.rate_column

592: ( 'c_Labor_Hrs'
593: , 'c_Total_Planned_Hrs'
594: , null
595: )
596: , isc_fs_rpt_util_pkg.rate_column
597: ( 'p_Labor_Hrs'
598: , 'p_Total_Planned_Hrs'
599: , null
600: )

Line 604: , ' || isc_fs_rpt_util_pkg.rate_column

600: )
601: , 'ISC_MEASURE_8'
602: , 'N'
603: ) || '
604: , ' || isc_fs_rpt_util_pkg.rate_column
605: ( 'p_Travel_Hrs'
606: , 'p_Total_Planned_Hrs'
607: , 'ISC_MEASURE_10'
608: ) || '

Line 609: , ' || isc_fs_rpt_util_pkg.rate_column

605: ( 'p_Travel_Hrs'
606: , 'p_Total_Planned_Hrs'
607: , 'ISC_MEASURE_10'
608: ) || '
609: , ' || isc_fs_rpt_util_pkg.rate_column
610: ( 'c_Travel_Hrs'
611: , 'c_Total_Planned_Hrs'
612: , 'ISC_MEASURE_11'
613: ) || '

Line 614: , ' || isc_fs_rpt_util_pkg.change_column

610: ( 'c_Travel_Hrs'
611: , 'c_Total_Planned_Hrs'
612: , 'ISC_MEASURE_11'
613: ) || '
614: , ' || isc_fs_rpt_util_pkg.change_column
615: ( isc_fs_rpt_util_pkg.rate_column
616: ( 'c_Travel_Hrs'
617: , 'c_Total_Planned_Hrs'
618: , null

Line 615: ( isc_fs_rpt_util_pkg.rate_column

611: , 'c_Total_Planned_Hrs'
612: , 'ISC_MEASURE_11'
613: ) || '
614: , ' || isc_fs_rpt_util_pkg.change_column
615: ( isc_fs_rpt_util_pkg.rate_column
616: ( 'c_Travel_Hrs'
617: , 'c_Total_Planned_Hrs'
618: , null
619: )

Line 620: , isc_fs_rpt_util_pkg.rate_column

616: ( 'c_Travel_Hrs'
617: , 'c_Total_Planned_Hrs'
618: , null
619: )
620: , isc_fs_rpt_util_pkg.rate_column
621: ( 'p_Travel_Hrs'
622: , 'p_Total_Planned_Hrs'
623: , null
624: )

Line 628: isc_fs_rpt_util_pkg.get_trend_drill

624: )
625: , 'ISC_MEASURE_12'
626: , 'N'
627: ) ||
628: isc_fs_rpt_util_pkg.get_trend_drill
629: ( l_xtd
630: , 'ISC_FS_TECH_UTL_TRD_REP'
631: , 'ISC_ATTRIBUTE_1'
632: , 'ISC_ATTRIBUTE_2'

Line 639: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);

635: from
636: ' || l_stmt;
637:
638: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
639: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
640:
641: poa_dbi_util_pkg.get_custom_rolling_binds
642: ( p_custom_output => l_custom_output
643: , p_xtd => l_xtd

Line 665: isc_fs_rpt_util_pkg.enhance_time_join

661: l_stmt := replace( l_stmt, ', cal.start_date cal_start_date', ', cal.start_date cal_start_date, cal.end_date cal_end_date');
662: l_stmt := replace( l_stmt, ', cal_start_date', ', cal_start_date, cal_end_date');
663: -- l_stmt := replace( l_stmt, 'group by cal_name, cal_start_date', 'group by cal_name, cal_start_date, cal_end_date');
664:
665: isc_fs_rpt_util_pkg.enhance_time_join
666: ( l_stmt
667: , 'Y'
668: );
669: