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.OPI_DBI_RES_UTL_PKG dependencies on POA_DBI_UTIL_PKG

Line 36: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

32: l_comparison_type VARCHAR2(1) := 'Y';
33: l_cur_suffix VARCHAR2(2);
34: l_custom_sql VARCHAR2 (10000);
35:
36: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
37: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
38:
39: l_where_clause VARCHAR2 (2000);
40: l_mv VARCHAR2 (30);

Line 37: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

33: l_cur_suffix VARCHAR2(2);
34: l_custom_sql VARCHAR2 (10000);
35:
36: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
37: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
38:
39: l_where_clause VARCHAR2 (2000);
40: l_mv VARCHAR2 (30);
41:

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

45:
46: BEGIN
47:
48: -- clear out the tables.
49: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
51:
52:
53: -- get all the query parameters

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

46: BEGIN
47:
48: -- clear out the tables.
49: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
51:
52:
53: -- get all the query parameters
54: opi_dbi_rpt_util_pkg.process_parameters (p_param,

Line 76: poa_dbi_util_pkg.add_column (l_col_tbl,

72: -- avail_val_ , actual_val_
73: -- If viewing by Resource, then sum up
74: -- avail_qty, actual_qty
75:
76: poa_dbi_util_pkg.add_column (l_col_tbl,
77: 'avail_val_' || l_cur_suffix,
78: 'avail_val');
79:
80: poa_dbi_util_pkg.add_column (l_col_tbl,

Line 80: poa_dbi_util_pkg.add_column (l_col_tbl,

76: poa_dbi_util_pkg.add_column (l_col_tbl,
77: 'avail_val_' || l_cur_suffix,
78: 'avail_val');
79:
80: poa_dbi_util_pkg.add_column (l_col_tbl,
81: 'actual_val_' || l_cur_suffix,
82: 'actual_val');
83:
84: -- Quantity columns are only needed for Resource viewby.

Line 86: poa_dbi_util_pkg.add_column (l_col_tbl,

82: 'actual_val');
83:
84: -- Quantity columns are only needed for Resource viewby.
85: -- IF (l_view_by = 'RESOURCE+ENI_RESOURCE') THEN
86: poa_dbi_util_pkg.add_column (l_col_tbl,
87: 'avail_qty',
88: 'avail_qty');
89:
90: poa_dbi_util_pkg.add_column (l_col_tbl,

Line 90: poa_dbi_util_pkg.add_column (l_col_tbl,

86: poa_dbi_util_pkg.add_column (l_col_tbl,
87: 'avail_qty',
88: 'avail_qty');
89:
90: poa_dbi_util_pkg.add_column (l_col_tbl,
91: 'actual_qty',
92: 'actual_qty');
93: -- END IF;
94:

Line 111: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

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

Line 270: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

266: l_resource_level_flag VARCHAR2(1) := '0';
267:
268: l_custom_rec BIS_QUERY_ATTRIBUTES;
269:
270: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
271: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
272:
273: BEGIN
274:

Line 271: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

267:
268: l_custom_rec BIS_QUERY_ATTRIBUTES;
269:
270: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
271: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
272:
273: BEGIN
274:
275: -- clear out the tables.

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

272:
273: BEGIN
274:
275: -- clear out the tables.
276: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
277: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
278:
279: -- get all the query parameters
280: opi_dbi_rpt_util_pkg.process_parameters (p_param,

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

273: BEGIN
274:
275: -- clear out the tables.
276: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
277: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
278:
279: -- get all the query parameters
280: opi_dbi_rpt_util_pkg.process_parameters (p_param,
281: l_view_by,

Line 300: poa_dbi_util_pkg.add_column (l_col_tbl,

296:
297: -- The measure columns that need to be aggregated are
298: -- avail_val_ , actual_val_
299: -- No Grand totals required.
300: poa_dbi_util_pkg.add_column (l_col_tbl,
301: 'actual_val_' || l_cur_suffix,
302: 'actual_val',
303: 'N');
304: poa_dbi_util_pkg.add_column (l_col_tbl,

Line 304: poa_dbi_util_pkg.add_column (l_col_tbl,

300: poa_dbi_util_pkg.add_column (l_col_tbl,
301: 'actual_val_' || l_cur_suffix,
302: 'actual_val',
303: 'N');
304: poa_dbi_util_pkg.add_column (l_col_tbl,
305: 'avail_val_' || l_cur_suffix,
306: 'avail_val',
307: 'N');
308:

Line 329: poa_dbi_util_pkg.get_custom_trend_binds (l_xtd, l_comparison_type,

325:
326: -- get all the basic binds used by POA queries
327: -- Do this before adding any of our binds, since the procedure
328: -- reinitializes the output table
329: poa_dbi_util_pkg.get_custom_trend_binds (l_xtd, l_comparison_type,
330: x_custom_output);
331:
332: -- put the custom OPI binds in
333: l_custom_rec.attribute_name := ':OPI_RESOURCE_LEVEL_FLAG';