APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_PROJECT_LSTG

Line 65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

61: l_temp_date := sysdate;
62:
63: Push_EDW_PROJ_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_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);

Line 287: Procedure Push_EDW_PROJ_PROJECT_LSTG(p_from_date IN date, p_to_date IN DATE) IS

283:
284: END;
285:
286:
287: Procedure Push_EDW_PROJ_PROJECT_LSTG(p_from_date IN date, p_to_date IN DATE) IS
288:
289: l_date1 DATE;
290: l_date2 DATE;
291: l_rows_inserted NUMBER := 0;

Line 296: edw_log.put_line('Starting Push_EDW_PROJ_PROJECT_LSTG');

292:
293: BEGIN
294:
295: if g_debug_flag = 'Y' then
296: edw_log.put_line('Starting Push_EDW_PROJ_PROJECT_LSTG');
297: end if;
298:
299: l_date1 := p_from_date;
300: l_date2 := p_to_date;

Line 302: Insert Into EDW_PROJ_PROJECT_LSTG

298:
299: l_date1 := p_from_date;
300: l_date2 := p_to_date;
301:
302: Insert Into EDW_PROJ_PROJECT_LSTG
303: (
304: PROJECT_PK,
305: PRJ_TYP_FK,
306: PROJ_CLS1_FK,

Line 363: edw_log.put_line('Commiting records for EDW_PROJ_PROJECT_LSTG');

359: l_rows_inserted := sql%rowcount;
360: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
361:
362: if g_debug_flag = 'Y' then
363: edw_log.put_line('Commiting records for EDW_PROJ_PROJECT_LSTG');
364: end if;
365:
366: commit;
367:

Line 369: edw_log.put_line('Completed Push_EDW_PROJ_PROJECT_LSTG');

365:
366: commit;
367:
368: if g_debug_flag = 'Y' then
369: edw_log.put_line('Completed Push_EDW_PROJ_PROJECT_LSTG');
370: end if;
371:
372: Exception
373: