APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CATEG1_LSTG

Line 74: Push_EDW_PROJ_CATEG1_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);
78: Push_EDW_PROJ_CATEG5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 1016: Procedure Push_EDW_PROJ_CATEG1_LSTG(p_from_date IN date, p_to_date IN DATE) IS

1012:
1013: END;
1014:
1015:
1016: Procedure Push_EDW_PROJ_CATEG1_LSTG(p_from_date IN date, p_to_date IN DATE) IS
1017:
1018: l_date1 DATE;
1019: l_date2 DATE;
1020: l_rows_inserted NUMBER :=0;

Line 1025: edw_log.put_line('Starting Push_EDW_PROJ_CATEG1_LSTG');

1021:
1022: BEGIN
1023:
1024: if g_debug_flag = 'Y' then
1025: edw_log.put_line('Starting Push_EDW_PROJ_CATEG1_LSTG');
1026: end if;
1027:
1028: l_date1 := p_from_date;
1029: l_date2 := p_to_date;

Line 1031: Insert Into EDW_PROJ_CATEG1_LSTG

1027:
1028: l_date1 := p_from_date;
1029: l_date2 := p_to_date;
1030:
1031: Insert Into EDW_PROJ_CATEG1_LSTG
1032: (
1033: ALL_FK,
1034: DELETION_DATE,
1035: INSTANCE,

Line 1070: edw_log.put_line('Commiting records for EDW_PROJ_CATEG1_LSTG');

1066: l_rows_inserted := sql%rowcount;
1067: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1068:
1069: if g_debug_flag = 'Y' then
1070: edw_log.put_line('Commiting records for EDW_PROJ_CATEG1_LSTG');
1071: end if;
1072:
1073: commit;
1074:

Line 1076: edw_log.put_line('Completed Push_EDW_PROJ_CATEG1_LSTG');

1072:
1073: commit;
1074:
1075: if g_debug_flag = 'Y' then
1076: edw_log.put_line('Completed Push_EDW_PROJ_CATEG1_LSTG');
1077: end if;
1078:
1079: Exception
1080: