DBA Data[Home] [Help]

APPS.CN_CALC_ROLLUP_PVT dependencies on CN_API

Line 642: l_date_range_tbl cn_api.date_range_tbl_type;

638: l_msg_count NUMBER( 15 );
639: l_msg_data VARCHAR2( 1000 );
640: l_start_date DATE;
641: l_end_date DATE;
642: l_date_range_tbl cn_api.date_range_tbl_type;
643: l_comp_group_id NUMBER;
644: i PLS_INTEGER := 0;
645: l_dummy NUMBER;
646: l_rollup_level PLS_INTEGER;

Line 738: cn_api.get_date_range_overlap( a_start_date => l_ancestors_tbl( l_ancestor ).start_date

734: IF ( l_descendants_tbl.COUNT > 0 ) THEN
735: FOR l_ancestor IN l_ancestors_tbl.FIRST .. l_ancestors_tbl.LAST LOOP
736: FOR l_descendant IN l_descendants_tbl.FIRST .. l_descendants_tbl.LAST LOOP
737: -- Get the date range which are overlapping
738: cn_api.get_date_range_overlap( a_start_date => l_ancestors_tbl( l_ancestor ).start_date
739: , a_end_date => l_ancestors_tbl( l_ancestor ).end_date
740: , b_start_date => l_descendants_tbl( l_descendant ).start_date
741: , b_end_date => l_descendants_tbl( l_descendant ).end_date
742: , p_org_id => g_org_id