APPS.IBW_BI_CUSTOMER_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 19: x_custom_output OUT NOCOPY bis_query_attributes_TBL )

15:
16: PROCEDURE GET_CUST_ACQUIS_TREND_SQL(
17: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
18: x_custom_sql OUT NOCOPY VARCHAR2,
19: x_custom_output OUT NOCOPY bis_query_attributes_TBL )
20: IS
21: -- Generic Variables
22:
23: l_custom_sql VARCHAR2(15000) ; --Final Sql.

Line 24: l_custom_rec BIS_QUERY_ATTRIBUTES;

20: IS
21: -- Generic Variables
22:
23: l_custom_sql VARCHAR2(15000) ; --Final Sql.
24: l_custom_rec BIS_QUERY_ATTRIBUTES;
25: l_site VARCHAR2(3200); --Site Id
26: l_period_type VARCHAR2(1000); --Period Type
27: l_page VARCHAR2(3200); -- Page
28: l_site_area VARCHAR2(3200); -- Site Area

Line 335: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

331: END IF;
332:
333: x_custom_sql := l_custom_sql;
334:
335: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
336:
337: l_custom_rec.attribute_name := ':l_currency' ;
338: l_custom_rec.attribute_value:= l_currency;
339: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 386: x_custom_output OUT NOCOPY bis_query_attributes_TBL)

382:
383: PROCEDURE GET_CUST_ACTY_TREND_SQL(
384: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
385: x_custom_sql OUT NOCOPY VARCHAR2,
386: x_custom_output OUT NOCOPY bis_query_attributes_TBL)
387: IS
388: -- Generic Variables
389:
390: l_custom_sql VARCHAR2(15000) ; --Final Sql.

Line 391: l_custom_rec BIS_QUERY_ATTRIBUTES;

387: IS
388: -- Generic Variables
389:
390: l_custom_sql VARCHAR2(15000) ; --Final Sql.
391: l_custom_rec BIS_QUERY_ATTRIBUTES;
392: l_site VARCHAR2(3200); --Site Id
393: l_period_type VARCHAR2(1000); --Period Type
394: l_page VARCHAR2(3200); -- Page
395: l_site_area VARCHAR2(3200); -- Site Area

Line 769: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

765: END IF;
766:
767: x_custom_sql := l_custom_sql;
768:
769: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
770:
771: l_custom_rec.attribute_name := ':l_currency' ;
772: l_custom_rec.attribute_value:= l_currency;
773: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 820: x_custom_output OUT NOCOPY bis_query_attributes_TBL)

816:
817: PROCEDURE GET_CUST_ACTY_SQL(
818: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
819: x_custom_sql OUT NOCOPY VARCHAR2,
820: x_custom_output OUT NOCOPY bis_query_attributes_TBL)
821: IS
822: -- Generic Variables
823:
824: l_custom_sql VARCHAR2(15000) ; --Final Sql.

Line 825: l_custom_rec BIS_QUERY_ATTRIBUTES;

821: IS
822: -- Generic Variables
823:
824: l_custom_sql VARCHAR2(15000) ; --Final Sql.
825: l_custom_rec BIS_QUERY_ATTRIBUTES;
826: l_site VARCHAR2(3200); --Site Id
827: l_period_type VARCHAR2(1000); --Period Type
828: l_page VARCHAR2(3200); -- Page
829: l_site_area VARCHAR2(3200); -- Site Area

Line 1241: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1237: END IF;
1238:
1239: x_custom_sql := l_custom_sql;
1240:
1241: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1242:
1243: l_custom_rec.attribute_name := ':l_currency' ;
1244: l_custom_rec.attribute_value:= l_currency;
1245: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;