APPS.ISC_DBI_FR_COST_PER_D_TR_PKG dependencies on POA_DBI_UTIL_PKG

Line 28: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

24: l_cur_suffix VARCHAR2(10);
25: l_currency VARCHAR2(10);
26: l_custom_sql VARCHAR2 (10000);
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: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
31:
32: l_where_clause VARCHAR2 (2000);

Line 29: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

25: l_currency VARCHAR2(10);
26: l_custom_sql VARCHAR2 (10000);
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: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
31:
32: l_where_clause VARCHAR2 (2000);
33: l_mv VARCHAR2 (30);

Line 30: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

26: l_custom_sql VARCHAR2 (10000);
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: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
31:
32: l_where_clause VARCHAR2 (2000);
33: l_mv VARCHAR2 (30);
34:

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

44: l_comparison_type := 'Y';
45: l_aggregation_level_flag := '0';
46:
47: -- clear out the tables.
48: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
49: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
50: x_custom_sql := l_query;
51:
52: -- get all the query parameters

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

45: l_aggregation_level_flag := '0';
46:
47: -- clear out the tables.
48: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
49: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
50: x_custom_sql := l_query;
51:
52: -- get all the query parameters
53: isc_dbi_sutil_pkg.process_parameters (

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

78: END IF;
79:
80: -- Add measure columns that need to be aggregated
81: -- No Grand totals required.
82: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
83: p_col_name => 'freight_cost_'||l_currency,
84: p_alias_name => 'freight_cost',
85: p_grand_total => 'N',
86: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 86: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

82: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
83: p_col_name => 'freight_cost_'||l_currency,
84: p_alias_name => 'freight_cost',
85: p_grand_total => 'N',
86: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
87: p_to_date_type => 'XTD');
88:
89: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
90: p_col_name => 'freight_distance_g',

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

85: p_grand_total => 'N',
86: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
87: p_to_date_type => 'XTD');
88:
89: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
90: p_col_name => 'freight_distance_g',
91: p_alias_name => 'freight_distance',
92: p_grand_total => 'N',
93: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 93: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

89: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
90: p_col_name => 'freight_distance_g',
91: p_alias_name => 'freight_distance',
92: p_grand_total => 'N',
93: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
94: p_to_date_type => 'XTD');
95:
96: -- bug fix 5230691
97:

Line 130: poa_dbi_util_pkg.get_custom_trend_binds (

126:
127: -- get all the basic binds used by POA queries
128: -- Do this before adding any of our binds, since the procedure
129: -- reinitializes the output table
130: poa_dbi_util_pkg.get_custom_trend_binds (
131: p_xtd => l_xtd,
132: p_comparison_type => l_comparison_type,
133: x_custom_output => x_custom_output);
134: