APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_PRJ_TYP_LSTG

Line 66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

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);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 381: Procedure Push_EDW_PROJ_PRJ_TYP_LSTG(p_from_date IN date, p_to_date IN DATE) IS

377:
378: END;
379:
380:
381: Procedure Push_EDW_PROJ_PRJ_TYP_LSTG(p_from_date IN date, p_to_date IN DATE) IS
382:
383: l_date1 DATE;
384: l_date2 DATE;
385: l_rows_inserted NUMBER :=0;

Line 392: edw_log.put_line('Starting Push_EDW_PROJ_PRJ_TYP_LSTG');

388:
389: BEGIN
390:
391: if g_debug_flag = 'Y' then
392: edw_log.put_line('Starting Push_EDW_PROJ_PRJ_TYP_LSTG');
393: end if;
394:
395: l_date1 := p_from_date;
396: l_date2 := p_to_date;

Line 398: Insert Into EDW_PROJ_PRJ_TYP_LSTG

394:
395: l_date1 := p_from_date;
396: l_date2 := p_to_date;
397:
398: Insert Into EDW_PROJ_PRJ_TYP_LSTG
399: (
400: PRJ_TYP_PK,
401: ALL_FK,
402: NAME,

Line 455: Insert Into EDW_PROJ_PRJ_TYP_LSTG

451: -- insert record into the staging table.
452:
453: l_instance := edw_instance.get_code;
454:
455: Insert Into EDW_PROJ_PRJ_TYP_LSTG
456: (
457: PRJ_TYP_PK,
458: ALL_FK,
459: NAME,

Line 495: edw_log.put_line('Commiting records for EDW_PROJ_PRJ_TYP_LSTG');

491:
492: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
493:
494: if g_debug_flag = 'Y' then
495: edw_log.put_line('Commiting records for EDW_PROJ_PRJ_TYP_LSTG');
496: end if;
497:
498: commit;
499:

Line 501: edw_log.put_line('Completed Push_EDW_PROJ_PRJ_TYP_LSTG');

497:
498: commit;
499:
500: if g_debug_flag = 'Y' then
501: edw_log.put_line('Completed Push_EDW_PROJ_PRJ_TYP_LSTG');
502: end if;
503:
504: Exception
505: