APPS.IBW_BI_PROD_REF_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 20: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

16:
17: PROCEDURE GET_WEB_REF_SQL
18: ( 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: )
22: IS
23: --Generic Variables
24: l_custom_sql VARCHAR2(15000) ; --Final Sql.

Line 35: l_custom_rec BIS_QUERY_ATTRIBUTES;

31: l_from VARCHAR2(3200) ;
32: l_where VARCHAR2(3200) ;
33: l_outer_select VARCHAR2(3000) ;
34: l_inner_select VARCHAR2(3000) ;
35: l_custom_rec BIS_QUERY_ATTRIBUTES;
36: l_inner_group_by VARCHAR2(1000);
37: l_having VARCHAR2(1000);
38:
39: --Un wanted Variables

Line 278: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

274:
275:
276:
277: --Build the Tokens
278: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
279:
280:
281: l_custom_rec.attribute_name := ':l_currency' ;
282: l_custom_rec.attribute_value:= l_currency;

Line 317: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )

313: PROCEDURE GET_PROD_INT_SQL
314: (
315: p_param IN BIS_PMV_PAGE_PARAMETER_TBL ,
316: x_custom_sql OUT NOCOPY VARCHAR2,
317: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )
318: IS
319:
320: -- Generic Variables
321:

Line 323: l_custom_rec BIS_QUERY_ATTRIBUTES;

319:
320: -- Generic Variables
321:
322: l_custom_sql VARCHAR2(15000) ; --Final Sql.
323: l_custom_rec BIS_QUERY_ATTRIBUTES;
324: l_site VARCHAR2(3200); --Site Id
325: l_period_type VARCHAR2(1000); --Period Type
326: l_prod_catg VARCHAR2(3200); -- Product Category
327: l_prod VARCHAR2(3200); -- Product

Line 807: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

803:
804:
805: x_custom_sql := l_custom_sql;
806:
807: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
808:
809: l_custom_rec.attribute_name := ':l_currency' ;
810: l_custom_rec.attribute_value:= l_currency;
811: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;