APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CATEG5_LSTG

Line 78: Push_EDW_PROJ_CATEG5_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);
79: Push_EDW_PROJ_CATEG6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
80: Push_EDW_PROJ_CATEG7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
81:
82: l_duration := sysdate - l_temp_date;

Line 1303: Procedure Push_EDW_PROJ_CATEG5_LSTG(p_from_date IN date, p_to_date IN DATE) IS

1299:
1300: END;
1301:
1302:
1303: Procedure Push_EDW_PROJ_CATEG5_LSTG(p_from_date IN date, p_to_date IN DATE) IS
1304:
1305: l_date1 DATE;
1306: l_date2 DATE;
1307: l_rows_inserted NUMBER :=0;

Line 1312: edw_log.put_line('Starting Push_EDW_PROJ_CATEG5_LSTG');

1308:
1309: BEGIN
1310:
1311: if g_debug_flag = 'Y' then
1312: edw_log.put_line('Starting Push_EDW_PROJ_CATEG5_LSTG');
1313: end if;
1314:
1315: l_date1 := p_from_date;
1316: l_date2 := p_to_date;

Line 1318: Insert Into EDW_PROJ_CATEG5_LSTG

1314:
1315: l_date1 := p_from_date;
1316: l_date2 := p_to_date;
1317:
1318: Insert Into EDW_PROJ_CATEG5_LSTG
1319: (
1320: ALL_FK,
1321: DELETION_DATE,
1322: INSTANCE,

Line 1357: edw_log.put_line('Commiting records for EDW_PROJ_CATEG5_LSTG');

1353: l_rows_inserted := sql%rowcount;
1354: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1355:
1356: if g_debug_flag = 'Y' then
1357: edw_log.put_line('Commiting records for EDW_PROJ_CATEG5_LSTG');
1358: end if;
1359:
1360: commit;
1361:

Line 1363: edw_log.put_line('Completed Push_EDW_PROJ_CATEG5_LSTG');

1359:
1360: commit;
1361:
1362: if g_debug_flag = 'Y' then
1363: edw_log.put_line('Completed Push_EDW_PROJ_CATEG5_LSTG');
1364: end if;
1365:
1366: Exception
1367: