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_SCRAP_REASON_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 4: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

1: PACKAGE BODY OPI_DBI_SCRAP_REASON_RPT_PKG AS
2: /*$Header: OPIDSBRRPTB.pls 120.0 2005/09/18 22:10 sberi noship $ */
3: FUNCTION GET_SCRAP_REASON_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_join_tbl IN
4: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
5: RETURN VARCHAR2;
6:
7:
8: /* -------------------------------------------------------------------------------------------

Line 29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

25: l_comparison_type VARCHAR2(1);
26: l_cur_suffix VARCHAR2(5);
27: l_custom_sql VARCHAR2 (10000);
28: l_subinv_val VARCHAR2 (120) := NULL;
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
31: l_where_clause VARCHAR2 (2000);
32: l_mv VARCHAR2 (30);
33: l_aggregation_level_flag VARCHAR2(10);

Line 30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

26: l_cur_suffix VARCHAR2(5);
27: l_custom_sql VARCHAR2 (10000);
28: l_subinv_val VARCHAR2 (120) := NULL;
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
31: l_where_clause VARCHAR2 (2000);
32: l_mv VARCHAR2 (30);
33: l_aggregation_level_flag VARCHAR2(10);
34: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 35: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

31: l_where_clause VARCHAR2 (2000);
32: l_mv VARCHAR2 (30);
33: l_aggregation_level_flag VARCHAR2(10);
34: l_custom_rec BIS_QUERY_ATTRIBUTES;
35: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
36:
37: BEGIN
38: -- initialization block
39: l_comparison_type := 'Y';

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

39: l_comparison_type := 'Y';
40: l_aggregation_level_flag := '0';
41:
42: -- clear out the column and Join info tables.
43: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
44: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
45: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
46:
47: -- get all the query parameters

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

40: l_aggregation_level_flag := '0';
41:
42: -- clear out the column and Join info tables.
43: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
44: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
45: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
46:
47: -- get all the query parameters
48: opi_dbi_rpt_util_pkg.process_parameters (

Line 45: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

41:
42: -- clear out the column and Join info tables.
43: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
44: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
45: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
46:
47: -- get all the query parameters
48: opi_dbi_rpt_util_pkg.process_parameters (
49: p_param => p_param,

Line 67: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

63: p_mv_set => 'SBR',
64: p_mv_flag_type => 'TRX_REASON_LEVEL');
65: -- Add measure columns that need to be aggregated
66:
67: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
68: p_col_name =>'scrap_val_' || l_cur_suffix,
69: p_alias_name =>'scrap_val',
70: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
71: p_grand_total => 'Y',

Line 70: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

66:
67: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
68: p_col_name =>'scrap_val_' || l_cur_suffix,
69: p_alias_name =>'scrap_val',
70: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
71: p_grand_total => 'Y',
72: p_to_date_type => 'XTD'
73: );
74:

Line 92: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

88: -- prepare output for bind variables
89: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
90: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
91: -- set the basic bind variables for the status SQL
92: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
93:
94: -- Passing OPI_AGGREGATION_LEVEL_FLAGS to PMV
95: l_custom_rec.attribute_name := ':OPI_TRX_REASON_FLAG';
96: l_custom_rec.attribute_value := l_aggregation_level_flag;

Line 116: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

112: ----------------------------------------------------------------------------------------------
113: */
114:
115: FUNCTION GET_SCRAP_REASON_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_join_tbl IN
116: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
117: RETURN VARCHAR2
118: IS
119: l_sel_clause VARCHAR2(15000);
120: l_view_by_col_name VARCHAR2(120);