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_TASK_ACT_BAC_RPT_PKG dependencies on ISC_FS_RPT_UTIL_PKG

Line 19: when p_view_by in ( isc_fs_rpt_util_pkg.G_PRODUCT

15: begin
16:
17: return
18: case
19: when p_view_by in ( isc_fs_rpt_util_pkg.G_PRODUCT
20: , isc_fs_rpt_util_pkg.G_CUSTOMER
21: , isc_fs_rpt_util_pkg.G_TASK_TYPE ) then
22: '''pFunctionName=' || g_detail_rep_func ||
23: '&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'''

Line 20: , isc_fs_rpt_util_pkg.G_CUSTOMER

16:
17: return
18: case
19: when p_view_by in ( isc_fs_rpt_util_pkg.G_PRODUCT
20: , isc_fs_rpt_util_pkg.G_CUSTOMER
21: , isc_fs_rpt_util_pkg.G_TASK_TYPE ) then
22: '''pFunctionName=' || g_detail_rep_func ||
23: '&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'''
24: when p_view_by = isc_fs_rpt_util_pkg.G_DISTRICT then

Line 21: , isc_fs_rpt_util_pkg.G_TASK_TYPE ) then

17: return
18: case
19: when p_view_by in ( isc_fs_rpt_util_pkg.G_PRODUCT
20: , isc_fs_rpt_util_pkg.G_CUSTOMER
21: , isc_fs_rpt_util_pkg.G_TASK_TYPE ) then
22: '''pFunctionName=' || g_detail_rep_func ||
23: '&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'''
24: when p_view_by = isc_fs_rpt_util_pkg.G_DISTRICT then
25: 'decode(''-1'',&'|| isc_fs_rpt_util_pkg.G_DISTRICT_SHORT || ',null,decode(oset.record_type,''RESOURCE'',''pFunctionName=' || g_detail_rep_func ||

Line 24: when p_view_by = isc_fs_rpt_util_pkg.G_DISTRICT then

20: , isc_fs_rpt_util_pkg.G_CUSTOMER
21: , isc_fs_rpt_util_pkg.G_TASK_TYPE ) then
22: '''pFunctionName=' || g_detail_rep_func ||
23: '&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'''
24: when p_view_by = isc_fs_rpt_util_pkg.G_DISTRICT then
25: 'decode(''-1'',&'|| isc_fs_rpt_util_pkg.G_DISTRICT_SHORT || ',null,decode(oset.record_type,''RESOURCE'',''pFunctionName=' || g_detail_rep_func ||
26: '&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',null))'
27: else
28: 'null'

Line 25: 'decode(''-1'',&'|| isc_fs_rpt_util_pkg.G_DISTRICT_SHORT || ',null,decode(oset.record_type,''RESOURCE'',''pFunctionName=' || g_detail_rep_func ||

21: , isc_fs_rpt_util_pkg.G_TASK_TYPE ) then
22: '''pFunctionName=' || g_detail_rep_func ||
23: '&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'''
24: when p_view_by = isc_fs_rpt_util_pkg.G_DISTRICT then
25: 'decode(''-1'',&'|| isc_fs_rpt_util_pkg.G_DISTRICT_SHORT || ',null,decode(oset.record_type,''RESOURCE'',''pFunctionName=' || g_detail_rep_func ||
26: '&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',null))'
27: else
28: 'null'
29: end || ' ' || p_col_alias;

Line 40: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

36: , x_custom_output out nocopy bis_query_attributes_tbl
37: )
38: is
39:
40: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
41: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
42: l_custom_output bis_query_attributes_tbl;
43: l_curr_suffix varchar2(3);
44: l_where_clause varchar2(10000);

Line 62: isc_fs_rpt_util_pkg.register_dimension_levels

58: l_union_mv_rec poa_dbi_util_pkg.poa_dbi_mv_rec;
59:
60: begin
61:
62: isc_fs_rpt_util_pkg.register_dimension_levels
63: ( l_dimension_tbl
64: , l_dim_filter_map
65: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
66: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'

Line 65: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'

61:
62: isc_fs_rpt_util_pkg.register_dimension_levels
63: ( l_dimension_tbl
64: , l_dim_filter_map
65: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
66: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
67: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
68: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
69: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

Line 66: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'

62: isc_fs_rpt_util_pkg.register_dimension_levels
63: ( l_dimension_tbl
64: , l_dim_filter_map
65: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
66: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
67: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
68: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
69: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
70: );

Line 67: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'

63: ( l_dimension_tbl
64: , l_dim_filter_map
65: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
66: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
67: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
68: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
69: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
70: );
71:

Line 68: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'

64: , l_dim_filter_map
65: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
66: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
67: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
68: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
69: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
70: );
71:
72: isc_fs_rpt_util_pkg.check_district_filter

Line 69: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

65: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
66: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
67: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
68: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
69: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
70: );
71:
72: isc_fs_rpt_util_pkg.check_district_filter
73: ( p_param

Line 72: isc_fs_rpt_util_pkg.check_district_filter

68: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
69: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
70: );
71:
72: isc_fs_rpt_util_pkg.check_district_filter
73: ( p_param
74: , l_dim_filter_map
75: );
76:

Line 77: isc_fs_rpt_util_pkg.process_parameters

73: ( p_param
74: , l_dim_filter_map
75: );
76:
77: isc_fs_rpt_util_pkg.process_parameters
78: ( p_param => p_param
79: , p_dimension_tbl => l_dimension_tbl
80: , p_dim_filter_map => l_dim_filter_map
81: , p_trend => 'N'

Line 98: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value

94: else
95: l_to_date_type := 'RLX';
96: end if;
97:
98: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value
99: ( p_param
100: , 'VIEW_BY'
101: );
102:

Line 103: if l_view_by = isc_fs_rpt_util_pkg.G_PRODUCT then

99: ( p_param
100: , 'VIEW_BY'
101: );
102:
103: if l_view_by = isc_fs_rpt_util_pkg.G_PRODUCT then
104: l_product := 'v4.description ISC_ATTRIBUTE_2';
105: else
106: l_product := 'null ISC_ATTRIBUTE_2';
107: end if;

Line 212: , ' || isc_fs_rpt_util_pkg.get_district_drill_down

208: , ISC_MEASURE_26
209: , ISC_MEASURE_27
210: , ISC_MEASURE_28
211: , ' || l_product || '
212: , ' || isc_fs_rpt_util_pkg.get_district_drill_down
213: ( l_view_by
214: , g_task_rep_func
215: , 'ISC_ATTRIBUTE_3' ) || '
216: , ' || isc_fs_rpt_util_pkg.get_category_drill_down

Line 216: , ' || isc_fs_rpt_util_pkg.get_category_drill_down

212: , ' || isc_fs_rpt_util_pkg.get_district_drill_down
213: ( l_view_by
214: , g_task_rep_func
215: , 'ISC_ATTRIBUTE_3' ) || '
216: , ' || isc_fs_rpt_util_pkg.get_category_drill_down
217: ( l_view_by
218: , g_task_rep_func
219: , 'ISC_ATTRIBUTE_4' ) || '
220: , ' || get_detail_drill( l_view_by, 'ISC_ATTRIBUTE_5' ) || '

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

219: , 'ISC_ATTRIBUTE_4' ) || '
220: , ' || get_detail_drill( l_view_by, 'ISC_ATTRIBUTE_5' ) || '
221: from (
222: select
223: row_number() over(&ORDER_BY_CLAUSE nulls last, '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
224: , iset.*
225: from ( select * from (
226: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
227: , nvl(p_backlog,0) ISC_MEASURE_1

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

222: select
223: row_number() over(&ORDER_BY_CLAUSE nulls last, '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
224: , iset.*
225: from ( select * from (
226: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
227: , nvl(p_backlog,0) ISC_MEASURE_1
228: , nvl(c_backlog,0) ISC_MEASURE_2
229: , ' || isc_fs_rpt_util_pkg.change_column
230: ( 'c_backlog'

Line 229: , ' || isc_fs_rpt_util_pkg.change_column

225: from ( select * from (
226: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
227: , nvl(p_backlog,0) ISC_MEASURE_1
228: , nvl(c_backlog,0) ISC_MEASURE_2
229: , ' || isc_fs_rpt_util_pkg.change_column
230: ( 'c_backlog'
231: , 'p_backlog'
232: , 'ISC_MEASURE_3' ) || '
233: , nvl(o_backlog,0) ISC_MEASURE_4

Line 240: , ' || isc_fs_rpt_util_pkg.change_column

236: , nvl(c_opened,0) ISC_MEASURE_7
237: , nvl(c_closed,0) ISC_MEASURE_8
238: , nvl(p_backlog_total,0) ISC_MEASURE_21
239: , nvl(c_backlog_total,0) ISC_MEASURE_22
240: , ' || isc_fs_rpt_util_pkg.change_column
241: ( 'c_backlog_total'
242: , 'p_backlog_total'
243: , 'ISC_MEASURE_23' ) || '
244: , nvl(o_backlog_total,0) ISC_MEASURE_24

Line 251: isc_fs_rpt_util_pkg.enhance_time_join

247: , nvl(c_opened_total,0) ISC_MEASURE_27
248: , nvl(c_closed_total,0) ISC_MEASURE_28
249: from (' || l_stmt;
250:
251: isc_fs_rpt_util_pkg.enhance_time_join
252: ( l_stmt
253: , 'N'
254: );
255:

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

253: , 'N'
254: );
255:
256: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
257: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
258:
259: x_custom_sql := l_stmt;
260:
261: poa_dbi_util_pkg.get_custom_balance_binds