DBA Data[Home] [Help]

APPS.ISC_DBI_FR_COST_PER_D_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 22: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

18: Rated Freight Cost per Unit Distance 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: l_mode_val VARCHAR2 (120);
46:
47: BEGIN

Line 134: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

130: p_in_join_tables => NULL);
131:
132:
133: -- prepare output for bind variables
134: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
135: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
136:
137: -- set the basic bind variables for the status SQL
138: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);