APPS.ISC_DBI_TS_ARR_PERF_TR_PKG dependencies on POA_DBI_UTIL_PKG

Line 29: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;

25: l_cur_suffix VARCHAR2(10);
26: l_currency VARCHAR2(10);
27: l_custom_sql VARCHAR2 (10000);
28:
29: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
33:

Line 30: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;

26: l_currency VARCHAR2(10);
27: l_custom_sql VARCHAR2 (10000);
28:
29: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
33:
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

27: l_custom_sql VARCHAR2 (10000);
28:
29: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
33:
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
35:

Line 32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

28:
29: l_col_tbl1 poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
33:
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
35:
36: l_where_clause VARCHAR2 (2000);

Line 34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

30: l_col_tbl2 poa_dbi_util_pkg.POA_DBI_COL_TBL;
31: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
32: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
33:
34: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
35:
36: l_where_clause VARCHAR2 (2000);
37: l_mv1 VARCHAR2 (30);
38: l_mv2 VARCHAR2 (30);

Line 53: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

49: l_aggregation_level_flag1 := '0';
50: l_aggregation_level_flag2 := '0';
51:
52: -- clear out the tables.
53: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
54: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
56: x_custom_sql := l_query;
57:

Line 54: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

50: l_aggregation_level_flag2 := '0';
51:
52: -- clear out the tables.
53: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
54: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
56: x_custom_sql := l_query;
57:
58: -- get all the query parameters

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

51:
52: -- clear out the tables.
53: l_col_tbl1 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
54: l_col_tbl2 := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
56: x_custom_sql := l_query;
57:
58: -- get all the query parameters
59: isc_dbi_sutil_pkg.process_parameters (

Line 81: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

77:
78: -- Add measure columns that need to be aggregated
79: -- No Grand totals required.
80:
81: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
82: p_col_name => 'stop_arrivals',
83: p_alias_name => 'stop_arrivals',
84: p_grand_total => 'N',
85: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

Line 85: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

81: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
82: p_col_name => 'stop_arrivals',
83: p_alias_name => 'stop_arrivals',
84: p_grand_total => 'N',
85: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
86: p_to_date_type => 'XTD');
87:
88: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
89: p_col_name => 'early_stop_arrivals',

Line 88: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

84: p_grand_total => 'N',
85: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
86: p_to_date_type => 'XTD');
87:
88: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
89: p_col_name => 'early_stop_arrivals',
90: p_alias_name => 'early_arrivals',
91: p_grand_total => 'N',
92: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

Line 92: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

88: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
89: p_col_name => 'early_stop_arrivals',
90: p_alias_name => 'early_arrivals',
91: p_grand_total => 'N',
92: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
93: p_to_date_type => 'XTD');
94:
95: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
96: p_col_name => 'late_stop_arrivals',

Line 95: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

91: p_grand_total => 'N',
92: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
93: p_to_date_type => 'XTD');
94:
95: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
96: p_col_name => 'late_stop_arrivals',
97: p_alias_name => 'late_arrivals',
98: p_grand_total => 'N',
99: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

Line 99: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

95: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
96: p_col_name => 'late_stop_arrivals',
97: p_alias_name => 'late_arrivals',
98: p_grand_total => 'N',
99: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
100: p_to_date_type => 'XTD');
101:
102: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
103: p_col_name => 'on_time_stop_arrivals',

Line 102: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,

98: p_grand_total => 'N',
99: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
100: p_to_date_type => 'XTD');
101:
102: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
103: p_col_name => 'on_time_stop_arrivals',
104: p_alias_name => 'ot_arrivals',
105: p_grand_total => 'N',
106: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

Line 106: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

102: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1,
103: p_col_name => 'on_time_stop_arrivals',
104: p_alias_name => 'ot_arrivals',
105: p_grand_total => 'N',
106: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
107: p_to_date_type => 'XTD');
108:
109: isc_dbi_sutil_pkg.process_parameters (
110: p_param => p_param,

Line 130: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,

126: p_in_join_tbl => l_in_join_tbl);
127:
128: -- Add measure columns that need to be aggregated
129: -- No Grand totals required.
130: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
131: p_col_name => 'planned_stop_arrivals',
132: p_alias_name => 'plan_arrivals',
133: p_grand_total => 'N',
134: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

Line 134: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

130: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2,
131: p_col_name => 'planned_stop_arrivals',
132: p_alias_name => 'plan_arrivals',
133: p_grand_total => 'N',
134: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
135: p_to_date_type => 'XTD');
136:
137:
138: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

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

134: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
135: p_to_date_type => 'XTD');
136:
137:
138: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
139:
140: l_mv_tbl.extend;
141: l_mv_tbl(1).mv_name := l_mv1;
142: l_mv_tbl(1).mv_col := l_col_tbl1;

Line 174: poa_dbi_util_pkg.get_custom_trend_binds (

170:
171: -- get all the basic binds used by POA queries
172: -- Do this before adding any of our binds, since the procedure
173: -- reinitializes the output table
174: poa_dbi_util_pkg.get_custom_trend_binds (
175: p_xtd => l_xtd2,
176: p_comparison_type => l_comparison_type,
177: x_custom_output => x_custom_output);
178: