DBA Data[Home] [Help]

APPS.OPI_DBI_CURR_VAR_RPT_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 59: opi_dbi_rpt_util_pkg.process_parameters (p_param,

55:
56: END LOOP;
57:
58: -- get all the query parameters
59: opi_dbi_rpt_util_pkg.process_parameters (p_param,
60: l_view_by,
61: l_view_by_col,
62: l_comparison_type,
63: l_xtd,

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

144:
145: /* Main Outer query */
146:
147: -- Column to get view by column name
148: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name(p_view_by_dim);
149:
150: -- Quantity column
151: get_qty_columns(p_view_by_dim, l_description, l_uom, l_qty);
152:

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

151: get_qty_columns(p_view_by_dim, l_description, l_uom, l_qty);
152:
153: l_sel_clause :=
154: 'SELECT
155: '|| opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
156: || l_view_by_col_name || ' OPI_ATTRIBUTE1,
157: '|| l_description || ' OPI_ATTRIBUTE2,
158: '|| l_uom || ' OPI_ATTRIBUTE3,';
159: