APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CATEG6_LSTG

Line 79: Push_EDW_PROJ_CATEG6_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;
83:

Line 1375: Procedure Push_EDW_PROJ_CATEG6_LSTG(p_from_date IN date, p_to_date IN DATE) IS

1371:
1372: END;
1373:
1374:
1375: Procedure Push_EDW_PROJ_CATEG6_LSTG(p_from_date IN date, p_to_date IN DATE) IS
1376:
1377: l_date1 DATE;
1378: l_date2 DATE;
1379: l_rows_inserted NUMBER :=0;

Line 1384: edw_log.put_line('Starting Push_EDW_PROJ_CATEG6_LSTG');

1380:
1381: BEGIN
1382:
1383: if g_debug_flag = 'Y' then
1384: edw_log.put_line('Starting Push_EDW_PROJ_CATEG6_LSTG');
1385: end if;
1386:
1387: l_date1 := p_from_date;
1388: l_date2 := p_to_date;

Line 1390: Insert Into EDW_PROJ_CATEG6_LSTG

1386:
1387: l_date1 := p_from_date;
1388: l_date2 := p_to_date;
1389:
1390: Insert Into EDW_PROJ_CATEG6_LSTG
1391: (
1392: ALL_FK,
1393: DELETION_DATE,
1394: INSTANCE,

Line 1429: edw_log.put_line('Commiting records for EDW_PROJ_CATEG6_LSTG');

1425: l_rows_inserted := sql%rowcount;
1426: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1427:
1428: if g_debug_flag = 'Y' then
1429: edw_log.put_line('Commiting records for EDW_PROJ_CATEG6_LSTG');
1430: end if;
1431:
1432: commit;
1433:

Line 1435: edw_log.put_line('Completed Push_EDW_PROJ_CATEG6_LSTG');

1431:
1432: commit;
1433:
1434: if g_debug_flag = 'Y' then
1435: edw_log.put_line('Completed Push_EDW_PROJ_CATEG6_LSTG');
1436: end if;
1437:
1438: Exception
1439: