DBA Data[Home] [Help]

APPS.OPI_DBI_MFG_VAR_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 28: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

24: l_custom_sql VARCHAR2 (10000);
25: l_period_type VARCHAR2(255) := NULL;
26: l_org VARCHAR2(255) := NULL;
27:
28: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
30:
31: l_where_clause VARCHAR2 (2000);
32: l_mv VARCHAR2 (30);

Line 29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

25: l_period_type VARCHAR2(255) := NULL;
26: l_org VARCHAR2(255) := NULL;
27:
28: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
30:
31: l_where_clause VARCHAR2 (2000);
32: l_mv VARCHAR2 (30);
33:

Line 41: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

37:
38: BEGIN
39:
40: -- clear out the tables.
41: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
42: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
43:
44: FOR i IN 1..p_param.COUNT
45: LOOP

Line 42: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

38: BEGIN
39:
40: -- clear out the tables.
41: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
42: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
43:
44: FOR i IN 1..p_param.COUNT
45: LOOP
46: IF(p_param(i).parameter_name = 'PERIOD_TYPE')

Line 77: poa_dbi_util_pkg.add_column (l_col_tbl,

73: -- The measure columns that need to be aggregated are
74: -- Std_value_, Act_value_
75: -- If viewing by item, then sum up
76: -- Actual_Qty_Completed
77: poa_dbi_util_pkg.add_column (l_col_tbl,
78: 'Std_value_' || l_cur_suffix,
79: 'Std_value');
80:
81: poa_dbi_util_pkg.add_column (l_col_tbl,

Line 81: poa_dbi_util_pkg.add_column (l_col_tbl,

77: poa_dbi_util_pkg.add_column (l_col_tbl,
78: 'Std_value_' || l_cur_suffix,
79: 'Std_value');
80:
81: poa_dbi_util_pkg.add_column (l_col_tbl,
82: 'Act_value_' || l_cur_suffix,
83: 'Act_value');
84:
85:

Line 89: poa_dbi_util_pkg.add_column (l_col_tbl,

85:
86: -- Quantity columns are only needed for Item viewby.
87: IF (l_view_by = 'ITEM+ENI_ITEM_ORG') THEN
88:
89: poa_dbi_util_pkg.add_column (l_col_tbl,
90: 'Actual_Qty_Completed',
91: 'Act_Qty_Compl');
92: END IF;
93:

Line 109: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

105: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
106: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
107:
108: -- set the basic bind variables for the status SQL
109: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
110:
111: -- Passing OPI_ITEM_CAT_FLAG to PMV
112: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
113: l_custom_rec.attribute_value := l_item_cat_flag;

Line 240: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

236: l_item_cat_flag VARCHAR2(1) := '0';
237:
238: l_custom_rec BIS_QUERY_ATTRIBUTES;
239:
240: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
241: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
242:
243: BEGIN
244:

Line 241: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

237:
238: l_custom_rec BIS_QUERY_ATTRIBUTES;
239:
240: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
241: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
242:
243: BEGIN
244:
245: -- clear out the tables.

Line 246: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

242:
243: BEGIN
244:
245: -- clear out the tables.
246: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
247: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
248:
249: -- get all the query parameters
250: opi_dbi_rpt_util_pkg.process_parameters (p_param,

Line 247: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

243: BEGIN
244:
245: -- clear out the tables.
246: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
247: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
248:
249: -- get all the query parameters
250: opi_dbi_rpt_util_pkg.process_parameters (p_param,
251: l_view_by,

Line 271: poa_dbi_util_pkg.add_column (l_col_tbl,

267:
268: -- The measure columns that need to be aggregated are
269: -- Std_value_, Act_value_
270: -- No Grand totals required.
271: poa_dbi_util_pkg.add_column (l_col_tbl,
272: 'Std_value_' || l_cur_suffix,
273: 'Std_value',
274: 'N');
275: poa_dbi_util_pkg.add_column (l_col_tbl,

Line 275: poa_dbi_util_pkg.add_column (l_col_tbl,

271: poa_dbi_util_pkg.add_column (l_col_tbl,
272: 'Std_value_' || l_cur_suffix,
273: 'Std_value',
274: 'N');
275: poa_dbi_util_pkg.add_column (l_col_tbl,
276: 'Act_value_' || l_cur_suffix,
277: 'Act_value',
278: 'N');
279:

Line 300: poa_dbi_util_pkg.get_custom_trend_binds (l_xtd, l_comparison_type,

296:
297: -- get all the basic binds used by POA queries
298: -- Do this before adding any of our binds, since the procedure
299: -- reinitializes the output table
300: poa_dbi_util_pkg.get_custom_trend_binds (l_xtd, l_comparison_type,
301: x_custom_output);
302:
303: -- put the custom OPI binds in
304: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';