DBA Data[Home] [Help]

APPS.OPI_DBI_PTP_RPT_PKG dependencies on FII_TIME_API

Line 860: l_period_end_date:=fii_time_api.cwk_start(l_curr_asof_date);

856: l_period_detail := 'FII_TIME_DAY_V';
857: l_period_id := 'WEEK_ID';
858: l_nested_pattern := 1;
859: l_pmv_nested_pattern := 11;
860: l_period_end_date:=fii_time_api.cwk_start(l_curr_asof_date);
861: l_period_select:= ' (bucket.start_date - :l_period_end_date) +1 name, ';
862: ELSIF l_period_type = 'FII_TIME_ENT_PERIOD' THEN
863: l_period_detail := 'FII_TIME_DAY_V';
864: l_period_id := 'ENT_PERIOD_ID';

Line 868: l_period_end_date :=fii_time_api.ent_cper_start(l_curr_asof_date);

864: l_period_id := 'ENT_PERIOD_ID';
865: l_nested_pattern := 1;
866: --l_nested_pattern := 11;
867: l_pmv_nested_pattern := 23;
868: l_period_end_date :=fii_time_api.ent_cper_start(l_curr_asof_date);
869: l_period_select:=' (bucket.start_date - :l_period_end_date) +1 name, ';
870: ELSIF l_period_type = 'FII_TIME_ENT_QTR' THEN
871: l_period_detail := 'FII_TIME_DAY_V';
872: l_period_id := 'ENT_QTR_ID';

Line 876: l_period_end_date :=fii_time_api.ent_cqtr_end(l_curr_asof_date) ;

872: l_period_id := 'ENT_QTR_ID';
873: l_nested_pattern := 1;
874: --l_nested_pattern := 11;
875: l_pmv_nested_pattern := 55;
876: l_period_end_date :=fii_time_api.ent_cqtr_end(l_curr_asof_date) ;
877: l_period_select :=' (bucket.start_date - :l_period_end_date) -1 name, ';
878: ELSE
879: l_period_detail := 'FII_TIME_ENT_PERIOD_V';
880: l_period_id := 'ENT_YEAR_ID';