APPS.ISC_DEPOT_RPT_UTIL_PKG dependencies on POA_DBI_UTIL_PKG

Line 24: x_dim_map out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map);

20: -- 'MDTL' - Mean Time To Repair Detail Report
21:
22: -- Local Functions
23: PROCEDURE init_dim_map ( p_mv_set IN VARCHAR2,
24: x_dim_map out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map);
25:
26: PROCEDURE get_join_info (p_view_by IN varchar2,
27: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
28: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,

Line 27: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,

23: PROCEDURE init_dim_map ( p_mv_set IN VARCHAR2,
24: x_dim_map out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map);
25:
26: PROCEDURE get_join_info (p_view_by IN varchar2,
27: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
28: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
29: p_mv_set IN VARCHAR2,
30: p_category_flag IN VARCHAR2 );
31:

Line 28: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,

24: x_dim_map out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map);
25:
26: PROCEDURE get_join_info (p_view_by IN varchar2,
27: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
28: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
29: p_mv_set IN VARCHAR2,
30: p_category_flag IN VARCHAR2 );
31:
32: PROCEDURE get_mv (p_mv_set IN VARCHAR2,

Line 74: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl,

70: x_xtd OUT NOCOPY VARCHAR2,
71: x_cur_suffix OUT NOCOPY VARCHAR2,
72: x_where_clause OUT NOCOPY VARCHAR2,
73: x_mv OUT NOCOPY VARCHAR2,
74: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl,
75: x_mv_type OUT NOCOPY VARCHAR2,
76: x_aggregation_flag OUT NOCOPY NUMBER,
77: p_mv_set IN VARCHAR2,
78: p_trend IN VARCHAR2,

Line 82: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;

78: p_trend IN VARCHAR2,
79: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
80:
81: IS
82: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
83: l_dim_bmap NUMBER := 0;
84: l_as_of_date DATE;
85: l_prev_as_of_date DATE;
86: l_not_used NUMBER;

Line 146: poa_dbi_util_pkg.get_parameter_values (p_param => p_param, --IN

142: write('BIS_ISC_DEPOT_UTIL : ',l_err_stage,C_DEBUG_LEVEL);
143: END IF;
144: -- Get the various parameter values from the utility package.
145: -- This package will also compute the l_dim_bmap
146: poa_dbi_util_pkg.get_parameter_values (p_param => p_param, --IN
147: p_dim_map => l_dim_map, --IN
148: p_view_by => x_view_by, --OUT
149: p_comparison_type => x_comparison_type, --OUT
150: p_xtd => x_xtd, --OUT

Line 221: x_where_clause := poa_dbi_util_pkg.get_where_clauses (p_dim_map => l_dim_map,

217: END IF;
218: END IF;
219:
220: -- Get the dimension level specific where clauses
221: x_where_clause := poa_dbi_util_pkg.get_where_clauses (p_dim_map => l_dim_map,
222: p_trend => p_trend);
223:
224: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
225: l_err_stage:= 'x_where_clause before ''additional where clause'' -> ' || x_where_clause;

Line 270: x_dim_map out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map)

266: -- will never be recorded.
267:
268:
269: PROCEDURE init_dim_map ( p_mv_set IN VARCHAR2,
270: x_dim_map out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map)
271: IS
272:
273: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;
274:

Line 273: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;

269: PROCEDURE init_dim_map ( p_mv_set IN VARCHAR2,
270: x_dim_map out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map)
271: IS
272:
273: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;
274:
275: BEGIN
276:
277: -- Organzation dimension level

Line 325: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,

321:
322: /* Function: get_join_info
323: */
324: PROCEDURE get_join_info (p_view_by IN varchar2,
325: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
326: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
327: p_mv_set IN VARCHAR2,
328: p_category_flag IN VARCHAR2)
329: IS

Line 326: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,

322: /* Function: get_join_info
323: */
324: PROCEDURE get_join_info (p_view_by IN varchar2,
325: p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map,
326: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
327: p_mv_set IN VARCHAR2,
328: p_category_flag IN VARCHAR2)
329: IS
330: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

Line 330: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

326: x_join_tbl OUT NOCOPY poa_dbi_util_pkg.POA_DBI_JOIN_TBL,
327: p_mv_set IN VARCHAR2,
328: p_category_flag IN VARCHAR2)
329: IS
330: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
331: l_stmt_id NUMBER;
332: BEGIN
333:
334: -- reinitialize the join table

Line 335: x_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

331: l_stmt_id NUMBER;
332: BEGIN
333:
334: -- reinitialize the join table
335: x_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
336:
337: -- The view by table
338: l_join_rec.table_name := p_dim_map(p_view_by).view_by_table;
339: l_join_rec.table_alias := 'v';