APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CLS7_LSTG

Line 73: Push_EDW_PROJ_CLS7_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);
77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 944: Procedure Push_EDW_PROJ_CLS7_LSTG(p_from_date IN date, p_to_date IN DATE) IS

940:
941: END;
942:
943:
944: Procedure Push_EDW_PROJ_CLS7_LSTG(p_from_date IN date, p_to_date IN DATE) IS
945:
946: l_date1 DATE;
947: l_date2 DATE;
948: l_rows_inserted NUMBER :=0;

Line 953: edw_log.put_line('Starting Push_EDW_PROJ_CLS7_LSTG');

949:
950: BEGIN
951:
952: if g_debug_flag = 'Y' then
953: edw_log.put_line('Starting Push_EDW_PROJ_CLS7_LSTG');
954: end if;
955:
956: l_date1 := p_from_date;
957: l_date2 := p_to_date;

Line 959: Insert Into EDW_PROJ_CLS7_LSTG

955:
956: l_date1 := p_from_date;
957: l_date2 := p_to_date;
958:
959: Insert Into EDW_PROJ_CLS7_LSTG
960: (
961: DELETION_DATE,
962: INSTANCE,
963: NAME,

Line 998: edw_log.put_line('Commiting records for EDW_PROJ_CLS7_LSTG');

994: l_rows_inserted := sql%rowcount;
995: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
996:
997: if g_debug_flag = 'Y' then
998: edw_log.put_line('Commiting records for EDW_PROJ_CLS7_LSTG');
999: end if;
1000:
1001: commit;
1002:

Line 1004: edw_log.put_line('Completed Push_EDW_PROJ_CLS7_LSTG');

1000:
1001: commit;
1002:
1003: if g_debug_flag = 'Y' then
1004: edw_log.put_line('Completed Push_EDW_PROJ_CLS7_LSTG');
1005: end if;
1006:
1007: Exception
1008: