DBA Data[Home] [Help]

APPS.IBE_BI_SM_KPI_PVT dependencies on IBE_BI_PMV_UTIL_PVT

Line 64: l_record_type_id := IBE_BI_PMV_UTIL_PVT.GET_RECORD_TYPE_ID(l_period_type);

60: l_minisite_id := p_pmv_parameters(i).parameter_id;
61: END IF;
62: END LOOP;
63:
64: l_record_type_id := IBE_BI_PMV_UTIL_PVT.GET_RECORD_TYPE_ID(l_period_type);
65:
66:
67: l_prev_date := IBE_BI_PMV_UTIL_PVT.GET_PREV_DATE(
68: p_asof_date => l_asof_date,

Line 67: l_prev_date := IBE_BI_PMV_UTIL_PVT.GET_PREV_DATE(

63:
64: l_record_type_id := IBE_BI_PMV_UTIL_PVT.GET_RECORD_TYPE_ID(l_period_type);
65:
66:
67: l_prev_date := IBE_BI_PMV_UTIL_PVT.GET_PREV_DATE(
68: p_asof_date => l_asof_date,
69: p_period_type => l_period_type,
70: p_comparison_type => l_comparison_type );
71:

Line 246: l_record_type_id := IBE_BI_PMV_UTIL_PVT.GET_RECORD_TYPE_ID(l_period_type);

242: l_minisite_id := p_pmv_parameters(i).parameter_id;
243: END IF;
244: END LOOP;
245:
246: l_record_type_id := IBE_BI_PMV_UTIL_PVT.GET_RECORD_TYPE_ID(l_period_type);
247:
248: l_c_filter := '';
249:
250: /*

Line 271: l_prev_date := IBE_BI_PMV_UTIL_PVT.GET_PREV_DATE(

267: ' AND FACT.MINISITE_ID in (&SITE+SITE)' ;
268: END IF;
269:
270:
271: l_prev_date := IBE_BI_PMV_UTIL_PVT.GET_PREV_DATE(
272: p_asof_date => l_asof_date,
273: p_period_type => l_period_type,
274: p_comparison_type => l_comparison_type );
275: