DBA Data[Home] [Help]

APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CLS6_LSTG

Line 72: Push_EDW_PROJ_CLS6_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);
75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 872: Procedure Push_EDW_PROJ_CLS6_LSTG(p_from_date IN date, p_to_date IN DATE) IS

868:
869: END;
870:
871:
872: Procedure Push_EDW_PROJ_CLS6_LSTG(p_from_date IN date, p_to_date IN DATE) IS
873:
874: l_date1 DATE;
875: l_date2 DATE;
876: l_rows_inserted NUMBER :=0;

Line 881: edw_log.put_line('Starting Push_EDW_PROJ_CLS6_LSTG');

877:
878: BEGIN
879:
880: if g_debug_flag = 'Y' then
881: edw_log.put_line('Starting Push_EDW_PROJ_CLS6_LSTG');
882: end if;
883:
884: l_date1 := p_from_date;
885: l_date2 := p_to_date;

Line 887: Insert Into EDW_PROJ_CLS6_LSTG

883:
884: l_date1 := p_from_date;
885: l_date2 := p_to_date;
886:
887: Insert Into EDW_PROJ_CLS6_LSTG
888: (
889: DELETION_DATE,
890: INSTANCE,
891: NAME,

Line 926: edw_log.put_line('Commiting records for EDW_PROJ_CLS6_LSTG');

922: l_rows_inserted := sql%rowcount;
923: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
924:
925: if g_debug_flag = 'Y' then
926: edw_log.put_line('Commiting records for EDW_PROJ_CLS6_LSTG');
927: end if;
928:
929: commit;
930:

Line 932: edw_log.put_line('Completed Push_EDW_PROJ_CLS6_LSTG');

928:
929: commit;
930:
931: if g_debug_flag = 'Y' then
932: edw_log.put_line('Completed Push_EDW_PROJ_CLS6_LSTG');
933: end if;
934:
935: Exception
936: