APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CATEG4_LSTG

Line 77: Push_EDW_PROJ_CATEG4_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);
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:

Line 1231: Procedure Push_EDW_PROJ_CATEG4_LSTG(p_from_date IN date, p_to_date IN DATE) IS

1227:
1228: END;
1229:
1230:
1231: Procedure Push_EDW_PROJ_CATEG4_LSTG(p_from_date IN date, p_to_date IN DATE) IS
1232:
1233: l_date1 DATE;
1234: l_date2 DATE;
1235: l_rows_inserted NUMBER :=0;

Line 1240: edw_log.put_line('Starting Push_EDW_PROJ_CATEG4_LSTG');

1236:
1237: BEGIN
1238:
1239: if g_debug_flag = 'Y' then
1240: edw_log.put_line('Starting Push_EDW_PROJ_CATEG4_LSTG');
1241: end if;
1242:
1243: l_date1 := p_from_date;
1244: l_date2 := p_to_date;

Line 1246: Insert Into EDW_PROJ_CATEG4_LSTG

1242:
1243: l_date1 := p_from_date;
1244: l_date2 := p_to_date;
1245:
1246: Insert Into EDW_PROJ_CATEG4_LSTG
1247: (
1248: ALL_FK,
1249: DELETION_DATE,
1250: INSTANCE,

Line 1285: edw_log.put_line('Commiting records for EDW_PROJ_CATEG4_LSTG');

1281: l_rows_inserted := sql%rowcount;
1282: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1283:
1284: if g_debug_flag = 'Y' then
1285: edw_log.put_line('Commiting records for EDW_PROJ_CATEG4_LSTG');
1286: end if;
1287:
1288: commit;
1289:

Line 1291: edw_log.put_line('Completed Push_EDW_PROJ_CATEG4_LSTG');

1287:
1288: commit;
1289:
1290: if g_debug_flag = 'Y' then
1291: edw_log.put_line('Completed Push_EDW_PROJ_CATEG4_LSTG');
1292: end if;
1293:
1294: Exception
1295: