DBA Data[Home] [Help]

APPS.ISC_DBI_FR_COST_PER_V_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 22: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

18: Rated Freight Cost per Unit Volume Report Function
19: -------------------------------------------------*/
20: PROCEDURE get_tbl_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
21: x_custom_sql OUT NOCOPY VARCHAR2,
22: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
23: IS
24: l_query VARCHAR2(32767);
25: l_view_by VARCHAR2(120);
26: l_view_by_col VARCHAR2 (120);

Line 43: l_custom_rec BIS_QUERY_ATTRIBUTES;

39: l_mv VARCHAR2 (30);
40:
41: l_aggregation_level_flag VARCHAR2(10);
42:
43: l_custom_rec BIS_QUERY_ATTRIBUTES;
44:
45: BEGIN
46:
47: -- initialization block

Line 117: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

113: p_generate_viewby => 'Y',
114: p_in_join_tables => NULL);
115:
116: -- prepare output for bind variables
117: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
118: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
119:
120: -- set the basic bind variables for the status SQL
121: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);