APPS.OPI_DBI_MTL_VAR_RPT_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 54: opi_dbi_rpt_util_pkg.process_parameters (p_param,

50: END IF;
51: END LOOP;
52:
53: -- get all the query parameters
54: opi_dbi_rpt_util_pkg.process_parameters (p_param,
55: l_view_by,
56: l_view_by_col,
57: l_comparison_type,
58: l_xtd,

Line 129: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name(p_view_by_dim);

125:
126: /* Main Outer query */
127:
128: -- Column to get view by column name
129: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name(p_view_by_dim);
130:
131: l_description := get_description(p_view_by_dim);
132:
133: l_sel_clause :=

Line 135: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)

131: l_description := get_description(p_view_by_dim);
132:
133: l_sel_clause :=
134: 'SELECT
135: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
136: || l_view_by_col_name || ' OPI_ATTRIBUTE1,
137: '|| l_description || ' OPI_ATTRIBUTE2,';
138:
139: IF ((p_view_by_dim = 'ITEM+ENI_ITEM_ORG') AND (p_period_type = 'FII_TIME_WEEK' OR p_period_type =

Line 231: opi_dbi_rpt_util_pkg.process_parameters (p_param,

227: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
228: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
229:
230: -- get all the query parameters
231: opi_dbi_rpt_util_pkg.process_parameters (p_param,
232: l_view_by,
233: l_view_by_col,
234: l_comparison_type,
235: l_xtd,