APPS.ISC_DBI_OT_ARR_RT_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 46: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

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

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

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

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

68: p_in_join_tbl => l_in_join_tbl);
69:
70: -- Add measure columns that need to be aggregated
71: -- No Grand totals required.
72: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
73: p_col_name => 'trip_arrivals',
74: p_alias_name => 'trip_arrivals',
75: p_grand_total => 'N',
76: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 76: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

72: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
73: p_col_name => 'trip_arrivals',
74: p_alias_name => 'trip_arrivals',
75: p_grand_total => 'N',
76: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
77: p_to_date_type => 'XTD');
78:
79: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
80: p_col_name => 'stop_arrivals',

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

75: p_grand_total => 'N',
76: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
77: p_to_date_type => 'XTD');
78:
79: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
80: p_col_name => 'stop_arrivals',
81: p_alias_name => 'stop_arrivals',
82: p_grand_total => 'N',
83: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 83: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

79: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
80: p_col_name => 'stop_arrivals',
81: p_alias_name => 'stop_arrivals',
82: p_grand_total => 'N',
83: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
84: p_to_date_type => 'XTD');
85:
86: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
87: p_col_name => 'on_time_stop_arrivals',

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

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

Line 90: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

86: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
87: p_col_name => 'on_time_stop_arrivals',
88: p_alias_name => 'ot_arrivals',
89: p_grand_total => 'N',
90: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
91: p_to_date_type => 'XTD');
92:
93: -- Merge Outer and Inner Query
94: l_query := get_trd_sel_clause(l_view_by) ||

Line 112: poa_dbi_util_pkg.get_custom_trend_binds (

108:
109: -- get all the basic binds used by POA queries
110: -- Do this before adding any of our binds, since the procedure
111: -- reinitializes the output table
112: poa_dbi_util_pkg.get_custom_trend_binds (
113: p_xtd => l_xtd,
114: p_comparison_type => l_comparison_type,
115: x_custom_output => x_custom_output);
116: