DBA Data[Home] [Help]

APPS.ISC_DBI_OT_ARR_RT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 18: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

14: On-Time Arrival Rate Report Function
15: -------------------------------------------------*/
16: PROCEDURE get_tbl_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
17: x_custom_sql OUT NOCOPY VARCHAR2,
18: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
19: IS
20: l_query VARCHAR2(32767);
21: l_view_by VARCHAR2(120);
22: l_view_by_col VARCHAR2 (120);

Line 39: l_custom_rec BIS_QUERY_ATTRIBUTES;

35: l_mv VARCHAR2 (30);
36:
37: l_aggregation_level_flag VARCHAR2(10);
38:
39: l_custom_rec BIS_QUERY_ATTRIBUTES;
40:
41: BEGIN
42:
43: -- initialization block

Line 127: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

123: p_generate_viewby => 'Y',
124: p_in_join_tables => NULL);
125:
126: -- prepare output for bind variables
127: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
128: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
129:
130: -- set the basic bind variables for the status SQL
131: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);