[Home] [Help]
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')
27: l_CartLabel VARCHAR2(300);
28: l_YesLabel VARCHAR2(300);
29: l_NoLabel VARCHAR2(300);
30: l_OrderBy VARCHAR2(2000);
31: l_custom_rec BIS_QUERY_ATTRIBUTES;
32: l_fnd_rec FND_CURSOR%ROWTYPE;
33: dbg_msg VARCHAR2(3200);
34:
35: l_global_primary VARCHAR2(15);
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' ;
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')
313: l_NoLabel VARCHAR2(300);
314: l_OrderableLabel VARCHAR2(300);
315: l_ExpiredLabel VARCHAR2(300);
316: l_OrderBy VARCHAR2(2000);
317: l_custom_rec BIS_QUERY_ATTRIBUTES ;
318: l_fnd_rec FND_CURSOR%ROWTYPE;
319: dbg_msg VARCHAR2(3200);
320: l_global_primary VARCHAR2(15);
321: l_global_secondary VARCHAR2(15);
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' ;
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;
585: l_minisite_id VARCHAR2(3200);
586: l_msiteFilter VARCHAR2(1000);
587: l_tableList VARCHAR2(1000);
588: l_OrderBy VARCHAR2(2000);
589: l_custom_rec BIS_QUERY_ATTRIBUTES;
590: dbg_msg VARCHAR2(3200);
591: l_global_primary VARCHAR2(15) ;
592: l_global_secondary VARCHAR2(15) ;
593: BEGIN
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' ;
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;
819: l_minisite_id VARCHAR2(3200);
820: l_msiteFilter VARCHAR2(1000);
821: l_tableList VARCHAR2(1000);
822: l_OrderBy VARCHAR2(2000);
823: l_custom_rec BIS_QUERY_ATTRIBUTES ;
824: dbg_msg VARCHAR2(3200);
825: l_global_primary VARCHAR2(15) ;
826: l_global_secondary VARCHAR2(15) ;
827: BEGIN
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' ;