APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_TASK_LSTG

Line 63: Push_EDW_PROJ_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

59: end if;
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);

Line 115: Procedure Push_EDW_PROJ_TASK_LSTG(p_from_date IN date, p_to_date IN DATE) IS

111:
112: End;
113:
114:
115: Procedure Push_EDW_PROJ_TASK_LSTG(p_from_date IN date, p_to_date IN DATE) IS
116:
117: l_date1 DATE;
118: l_date2 DATE;
119: l_rows_inserted NUMBER := 0;

Line 124: edw_log.put_line('Starting Push_EDW_PROJ_TASK_LSTG');

120:
121: BEGIN
122:
123: if g_debug_flag = 'Y' then
124: edw_log.put_line('Starting Push_EDW_PROJ_TASK_LSTG');
125: end if;
126:
127: l_date1 := p_from_date;
128: l_date2 := p_to_date;

Line 130: Insert Into EDW_PROJ_TASK_LSTG

126:
127: l_date1 := p_from_date;
128: l_date2 := p_to_date;
129:
130: Insert Into EDW_PROJ_TASK_LSTG
131: (
132: TASK_PK,
133: TOP_TASK_FK,
134: NAME,

Line 187: edw_log.put_line('Commiting records for EDW_PROJ_TASK_LSTG');

183: l_rows_inserted := sql%rowcount;
184: g_row_count := g_row_count + l_rows_inserted ;
185:
186: if g_debug_flag = 'Y' then
187: edw_log.put_line('Commiting records for EDW_PROJ_TASK_LSTG');
188: end if;
189:
190: commit;
191:

Line 193: edw_log.put_line('Completed Push_EDW_PROJ_TASK_LSTG');

189:
190: commit;
191:
192: if g_debug_flag = 'Y' then
193: edw_log.put_line('Completed Push_EDW_PROJ_TASK_LSTG');
194: end if;
195:
196: Exception
197: