APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CLS2_LSTG

Line 68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 585: Procedure Push_EDW_PROJ_CLS2_LSTG(p_from_date IN date, p_to_date IN DATE) IS

581:
582: END;
583:
584:
585: Procedure Push_EDW_PROJ_CLS2_LSTG(p_from_date IN date, p_to_date IN DATE) IS
586:
587: l_date1 DATE;
588: l_date2 DATE;
589: l_rows_inserted NUMBER :=0;

Line 594: edw_log.put_line('Starting Push_EDW_PROJ_CLS2_LSTG');

590:
591: BEGIN
592:
593: if g_debug_flag = 'Y' then
594: edw_log.put_line('Starting Push_EDW_PROJ_CLS2_LSTG');
595: end if;
596:
597: l_date1 := p_from_date;
598: l_date2 := p_to_date;

Line 600: Insert Into EDW_PROJ_CLS2_LSTG

596:
597: l_date1 := p_from_date;
598: l_date2 := p_to_date;
599:
600: Insert Into EDW_PROJ_CLS2_LSTG
601: (
602: DELETION_DATE,
603: INSTANCE,
604: NAME,

Line 638: edw_log.put_line('Commiting records for EDW_PROJ_CLS2_LSTG');

634: l_rows_inserted := sql%rowcount;
635: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
636:
637: if g_debug_flag = 'Y' then
638: edw_log.put_line('Commiting records for EDW_PROJ_CLS2_LSTG');
639: end if;
640:
641: commit;
642:

Line 644: edw_log.put_line('Completed Push_EDW_PROJ_CLS2_LSTG');

640:
641: commit;
642:
643: if g_debug_flag = 'Y' then
644: edw_log.put_line('Completed Push_EDW_PROJ_CLS2_LSTG');
645: end if;
646:
647: Exception
648: