DBA Data[Home] [Help]

APPS.ISC_DBI_FR_COST_PER_W_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 21: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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

Line 42: l_custom_rec BIS_QUERY_ATTRIBUTES;

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

Line 116: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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