DBA Data[Home] [Help]

APPS.ISC_DBI_CARR_BILL_PAY_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 20: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

16: Carrier Billing and Payment Variance Report Function
17: ----------------------------------------*/
18: PROCEDURE get_tbl_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
19: x_custom_sql OUT NOCOPY VARCHAR2,
20: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
21: IS
22: l_query VARCHAR2(32767);
23: l_view_by VARCHAR2(120);
24: l_view_by_col VARCHAR2 (120);

Line 47: l_custom_rec BIS_QUERY_ATTRIBUTES;

43:
44: l_aggregation_level_flag1 VARCHAR2(10);
45: l_aggregation_level_flag2 VARCHAR2(10);
46:
47: l_custom_rec BIS_QUERY_ATTRIBUTES;
48:
49: BEGIN
50:
51: -- initialization block

Line 189: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

185: p_paren_count => 3,
186: p_filter_where => NULL);
187:
188: -- prepare output for bind variables
189: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
190: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
191:
192: -- set the basic bind variables for the status SQL
193: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);