DBA Data[Home] [Help]

APPS.FII_PMV_UTIL dependencies on FII_TIME_API

Line 711: p_period_start := fii_time_api.cwk_start(l_as_of_date);

707: IF p_page_parameter_tbl(i).parameter_name = 'FII_TIME_WEEK_FROM' THEN
708: p_cur_period := to_number(p_page_parameter_tbl(i).parameter_id);
709: p_id_column := 'week_id';
710: select (to_date(l_as_of_date,'DD-MM-YYYY') - start_date) into p_days_into_period from fii_time_week where week_id = p_cur_period;
711: p_period_start := fii_time_api.cwk_start(l_as_of_date);
712: ELSIF p_page_parameter_tbl(i).parameter_name = 'FII_TIME_ENT_PERIOD_FROM' THEN
713: p_cur_period := p_page_parameter_tbl(i).parameter_id;
714: p_id_column := 'ent_period_id';
715: select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_period where ent_period_id = p_cur_period;

Line 716: p_period_start := fii_time_api.ent_cper_start(l_as_of_date);

712: ELSIF p_page_parameter_tbl(i).parameter_name = 'FII_TIME_ENT_PERIOD_FROM' THEN
713: p_cur_period := p_page_parameter_tbl(i).parameter_id;
714: p_id_column := 'ent_period_id';
715: select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_period where ent_period_id = p_cur_period;
716: p_period_start := fii_time_api.ent_cper_start(l_as_of_date);
717: ELSIF p_page_parameter_tbl(i).parameter_name = 'FII_TIME_ENT_QTR_FROM' THEN
718: p_cur_period := p_page_parameter_tbl(i).parameter_id;
719: p_id_column := 'ent_qtr_id';
720: select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_qtr where ent_qtr_id = p_cur_period;

Line 721: p_period_start := fii_time_api.ent_cqtr_start(l_as_of_date);

717: ELSIF p_page_parameter_tbl(i).parameter_name = 'FII_TIME_ENT_QTR_FROM' THEN
718: p_cur_period := p_page_parameter_tbl(i).parameter_id;
719: p_id_column := 'ent_qtr_id';
720: select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_qtr where ent_qtr_id = p_cur_period;
721: p_period_start := fii_time_api.ent_cqtr_start(l_as_of_date);
722: ELSIF p_page_parameter_tbl(i).parameter_name = 'FII_TIME_ENT_YEAR_FROM' THEN
723: p_cur_period := p_page_parameter_tbl(i).parameter_id;
724: p_id_column := 'ent_year_id';
725: select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_year where ent_year_id = p_cur_period;

Line 726: p_period_start := fii_time_api.ent_cyr_start(l_as_of_date);

722: ELSIF p_page_parameter_tbl(i).parameter_name = 'FII_TIME_ENT_YEAR_FROM' THEN
723: p_cur_period := p_page_parameter_tbl(i).parameter_id;
724: p_id_column := 'ent_year_id';
725: select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_year where ent_year_id = p_cur_period;
726: p_period_start := fii_time_api.ent_cyr_start(l_as_of_date);
727: END IF;
728: END LOOP;
729: END IF;
730: p_days_into_period := l_as_of_date - p_period_start;

Line 819: p_period_start := fii_time_api.cwk_start(l_as_of_date);

815: WHEN 'FII_TIME_WEEK' THEN
816: select week_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
817: p_id_column := 'week_id';
818: BEGIN
819: p_period_start := fii_time_api.cwk_start(l_as_of_date);
820: EXCEPTION
821: When no_data_found then
822: p_period_start := fii_time_api.cwk_start(sysdate);
823: END;

Line 822: p_period_start := fii_time_api.cwk_start(sysdate);

818: BEGIN
819: p_period_start := fii_time_api.cwk_start(l_as_of_date);
820: EXCEPTION
821: When no_data_found then
822: p_period_start := fii_time_api.cwk_start(sysdate);
823: END;
824: WHEN 'FII_TIME_ENT_PERIOD' THEN
825: select ent_period_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
826: p_id_column := 'ent_period_id';

Line 828: p_period_start := fii_time_api.ent_cper_start(l_as_of_date);

824: WHEN 'FII_TIME_ENT_PERIOD' THEN
825: select ent_period_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
826: p_id_column := 'ent_period_id';
827: BEGIN
828: p_period_start := fii_time_api.ent_cper_start(l_as_of_date);
829: EXCEPTION
830: When no_data_found then
831: p_period_start := fii_time_api.ent_cper_start(sysdate);
832: END;

Line 831: p_period_start := fii_time_api.ent_cper_start(sysdate);

827: BEGIN
828: p_period_start := fii_time_api.ent_cper_start(l_as_of_date);
829: EXCEPTION
830: When no_data_found then
831: p_period_start := fii_time_api.ent_cper_start(sysdate);
832: END;
833: WHEN 'FII_TIME_ENT_QTR' THEN
834: select ent_qtr_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
835: p_id_column := 'ent_qtr_id';

Line 837: p_period_start := fii_time_api.ent_cqtr_start(l_as_of_date);

833: WHEN 'FII_TIME_ENT_QTR' THEN
834: select ent_qtr_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
835: p_id_column := 'ent_qtr_id';
836: BEGIN
837: p_period_start := fii_time_api.ent_cqtr_start(l_as_of_date);
838: EXCEPTION
839: When no_data_found then
840: p_period_start := fii_time_api.ent_cqtr_start(sysdate);
841: END;

Line 840: p_period_start := fii_time_api.ent_cqtr_start(sysdate);

836: BEGIN
837: p_period_start := fii_time_api.ent_cqtr_start(l_as_of_date);
838: EXCEPTION
839: When no_data_found then
840: p_period_start := fii_time_api.ent_cqtr_start(sysdate);
841: END;
842: WHEN 'FII_TIME_ENT_YEAR' THEN
843: select ent_year_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
844: p_id_column := 'ent_year_id';

Line 846: p_period_start := fii_time_api.ent_cyr_start(l_as_of_date);

842: WHEN 'FII_TIME_ENT_YEAR' THEN
843: select ent_year_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
844: p_id_column := 'ent_year_id';
845: BEGIN
846: p_period_start := fii_time_api.ent_cyr_start(l_as_of_date);
847: EXCEPTION
848: When no_data_found then
849: p_period_start := fii_time_api.ent_cyr_start(sysdate);
850: END;

Line 849: p_period_start := fii_time_api.ent_cyr_start(sysdate);

845: BEGIN
846: p_period_start := fii_time_api.ent_cyr_start(l_as_of_date);
847: EXCEPTION
848: When no_data_found then
849: p_period_start := fii_time_api.ent_cyr_start(sysdate);
850: END;
851: END CASE;
852: End if;
853: END IF;