APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_TOP_TASK_LSTG

Line 64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

60:
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);

Line 205: Procedure Push_EDW_PROJ_TOP_TASK_LSTG(p_from_date IN date, p_to_date IN DATE) IS

201:
202: END;
203:
204:
205: Procedure Push_EDW_PROJ_TOP_TASK_LSTG(p_from_date IN date, p_to_date IN DATE) IS
206:
207: l_date1 DATE;
208: l_date2 DATE;
209: l_rows_inserted NUMBER := 0;

Line 214: edw_log.put_line('Starting Push_EDW_PROJ_TOP_TASK_LSTG');

210:
211: BEGIN
212:
213: if g_debug_flag = 'Y' then
214: edw_log.put_line('Starting Push_EDW_PROJ_TOP_TASK_LSTG');
215: end if;
216:
217: l_date1 := p_from_date;
218: l_date2 := p_to_date;

Line 220: Insert Into EDW_PROJ_TOP_TASK_LSTG

216:
217: l_date1 := p_from_date;
218: l_date2 := p_to_date;
219:
220: Insert Into EDW_PROJ_TOP_TASK_LSTG
221: (
222: TOP_TASK_PK,
223: PROJECT_FK,
224: NAME,

Line 269: edw_log.put_line('Commiting records for EDW_PROJ_TOP_TASK_LSTG');

265: l_rows_inserted := sql%rowcount;
266: --g_row_count := g_row_count + l_rows_inserted ;
267:
268: if g_debug_flag = 'Y' then
269: edw_log.put_line('Commiting records for EDW_PROJ_TOP_TASK_LSTG');
270: end if;
271:
272: commit;
273:

Line 275: edw_log.put_line('Completed Push_EDW_PROJ_TOP_TASK_LSTG');

271:
272: commit;
273:
274: if g_debug_flag = 'Y' then
275: edw_log.put_line('Completed Push_EDW_PROJ_TOP_TASK_LSTG');
276: end if;
277:
278: Exception
279: