APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CLS3_LSTG

Line 69: Push_EDW_PROJ_CLS3_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);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 656: Procedure Push_EDW_PROJ_CLS3_LSTG(p_from_date IN date, p_to_date IN DATE) IS

652:
653: END;
654:
655:
656: Procedure Push_EDW_PROJ_CLS3_LSTG(p_from_date IN date, p_to_date IN DATE) IS
657:
658: l_date1 DATE;
659: l_date2 DATE;
660: l_rows_inserted NUMBER :=0;

Line 665: edw_log.put_line('Starting Push_EDW_PROJ_CLS3_LSTG');

661:
662: BEGIN
663:
664: if g_debug_flag = 'Y' then
665: edw_log.put_line('Starting Push_EDW_PROJ_CLS3_LSTG');
666: end if;
667:
668: l_date1 := p_from_date;
669: l_date2 := p_to_date;

Line 671: Insert Into EDW_PROJ_CLS3_LSTG

667:
668: l_date1 := p_from_date;
669: l_date2 := p_to_date;
670:
671: Insert Into EDW_PROJ_CLS3_LSTG
672: (
673: DELETION_DATE,
674: INSTANCE,
675: NAME,

Line 710: edw_log.put_line('Commiting records for EDW_PROJ_CLS3_LSTG');

706: l_rows_inserted := sql%rowcount;
707: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
708:
709: if g_debug_flag = 'Y' then
710: edw_log.put_line('Commiting records for EDW_PROJ_CLS3_LSTG');
711: end if;
712:
713: commit;
714:

Line 716: edw_log.put_line('Completed Push_EDW_PROJ_CLS3_LSTG');

712:
713: commit;
714:
715: if g_debug_flag = 'Y' then
716: edw_log.put_line('Completed Push_EDW_PROJ_CLS3_LSTG');
717: end if;
718:
719: Exception
720: