APPS.ISC_DBI_SAM_AGR_ORD_DTL_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output out nocopy bis_query_attributes_tbl) is

2: /* $Header: ISCRGCLB.pls 120.6 2006/01/04 16:07:22 scheung noship $ */
3:
4: procedure get_sql ( p_param in bis_pmv_page_parameter_tbl,
5: x_custom_sql out nocopy varchar2,
6: x_custom_output out nocopy bis_query_attributes_tbl) is
7:
8: l_sgid varchar2(32000);
9: l_class varchar2(32000);
10: l_cust varchar2(32000);

Line 25: l_custom_rec bis_query_attributes;

21: l_prod_cat_from varchar2(32000);
22: l_prod_cat_where varchar2(32000);
23: l_item_where varchar2(32000);
24: l_query varchar2(32000);
25: l_custom_rec bis_query_attributes;
26:
27: begin
28:
29: -- Get all necessary parameters from PMV

Line 175: x_custom_output := bis_query_attributes_tbl();

171: &ORDER_BY_CLAUSE nulls last
172: ';
173:
174: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
175: x_custom_output := bis_query_attributes_tbl();
176:
177: l_custom_rec.attribute_name := ':ISC_SG';
178: l_custom_rec.attribute_value := to_char(l_sg_sg);
179: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;