APPS.IBE_BI_TOP_ACT_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 7: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS

3:
4: PROCEDURE GET_TOP_ORDERS_SQL(
5: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS
8: CURSOR FND_CURSOR IS
9: SELECT LOOKUP_TYPE,LOOKUP_CODE, MEANING
10: FROM FND_LOOKUPS
11: WHERE LOOKUP_TYPE IN ('YES_NO', 'IBE_BI_GENERIC')

Line 201: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.query',l_custom_sql);
199: END IF;
200:
201: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
202:
203: x_custom_output.Extend(11);
204:
205: l_custom_rec.attribute_name := ':l_asof_date' ;

Line 293: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS

289:
290: PROCEDURE GET_TOP_CARTS_SQL(
291: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
292: x_custom_sql OUT NOCOPY VARCHAR2,
293: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS
294: CURSOR FND_CURSOR IS
295: SELECT LOOKUP_TYPE,LOOKUP_CODE, MEANING
296: FROM FND_LOOKUPS
297: WHERE LOOKUP_TYPE IN ('YES_NO', 'IBE_BI_GENERIC')

Line 482: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

478:
479: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
480: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.query',l_custom_sql);
481: END IF;
482: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
483:
484: x_custom_output.Extend(11);
485:
486: l_custom_rec.attribute_name := ':l_asof_date' ;

Line 575: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS

571:
572: PROCEDURE GET_TOP_CUSTOMERS_SQL(
573: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
574: x_custom_sql OUT NOCOPY VARCHAR2,
575: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS
576: l_custom_sql VARCHAR2(4000);
577: l_parameter_name VARCHAR2(3200);
578: l_asof_date DATE;
579: l_prev_date DATE;

Line 744: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

740: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.query',l_custom_sql);
742: END IF;
743:
744: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
745:
746: x_custom_output.Extend(7);
747:
748: l_custom_rec.attribute_name := ':l_asof_date' ;

Line 809: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS

805:
806: PROCEDURE GET_TOP_PRODUCTS_SQL(
807: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
808: x_custom_sql OUT NOCOPY VARCHAR2,
809: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS
810: l_custom_sql VARCHAR2(4000);
811: l_parameter_name VARCHAR2(3200);
812: l_asof_date DATE;
813: l_prev_date DATE;

Line 981: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

977: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.query',l_custom_sql);
979: END IF;
980:
981: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
982:
983: x_custom_output.Extend(7);
984:
985: l_custom_rec.attribute_name := ':l_asof_date' ;