DBA Data[Home] [Help]

APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CLS4_LSTG

Line 70: Push_EDW_PROJ_CLS4_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);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 728: Procedure Push_EDW_PROJ_CLS4_LSTG(p_from_date IN date, p_to_date IN DATE) IS

724:
725: END;
726:
727:
728: Procedure Push_EDW_PROJ_CLS4_LSTG(p_from_date IN date, p_to_date IN DATE) IS
729:
730: l_date1 DATE;
731: l_date2 DATE;
732: l_rows_inserted NUMBER :=0;

Line 737: edw_log.put_line('Starting Push_EDW_PROJ_CLS4_LSTG');

733:
734: BEGIN
735:
736: if g_debug_flag = 'Y' then
737: edw_log.put_line('Starting Push_EDW_PROJ_CLS4_LSTG');
738: end if;
739:
740: l_date1 := p_from_date;
741: l_date2 := p_to_date;

Line 743: Insert Into EDW_PROJ_CLS4_LSTG

739:
740: l_date1 := p_from_date;
741: l_date2 := p_to_date;
742:
743: Insert Into EDW_PROJ_CLS4_LSTG
744: (
745: DELETION_DATE,
746: INSTANCE,
747: NAME,

Line 782: edw_log.put_line('Commiting records for EDW_PROJ_CLS4_LSTG');

778: l_rows_inserted := sql%rowcount;
779: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
780:
781: if g_debug_flag = 'Y' then
782: edw_log.put_line('Commiting records for EDW_PROJ_CLS4_LSTG');
783: end if;
784:
785: commit;
786:

Line 788: edw_log.put_line('Completed Push_EDW_PROJ_CLS4_LSTG');

784:
785: commit;
786:
787: if g_debug_flag = 'Y' then
788: edw_log.put_line('Completed Push_EDW_PROJ_CLS4_LSTG');
789: end if;
790:
791: Exception
792: