APPS.FII_GL_BOOK_M_C dependencies on EDW_GL_BOOK_BOOK_LSTG

Line 64: Push_EDW_GL_BOOK_BOOK_LSTG(FII_GL_BOOK_M_C.g_push_date_range1, FII_GL_BOOK_M_C.g_push_date_range2);

60: l_temp_date := sysdate;
61:
62:
63: Push_EDW_GL_BOOK_FA_BOOK_LSTG(FII_GL_BOOK_M_C.g_push_date_range1, FII_GL_BOOK_M_C.g_push_date_range2);
64: Push_EDW_GL_BOOK_BOOK_LSTG(FII_GL_BOOK_M_C.g_push_date_range1, FII_GL_BOOK_M_C.g_push_date_range2);
65:
66:
67: l_duration := sysdate - l_temp_date;
68:

Line 155: Procedure Push_EDW_GL_BOOK_BOOK_LSTG(p_from_date IN date, p_to_date IN DATE) IS

151: commit;
152: END;
153:
154:
155: Procedure Push_EDW_GL_BOOK_BOOK_LSTG(p_from_date IN date, p_to_date IN DATE) IS
156: l_date1 DATE;
157: l_date2 DATE;
158: l_rows_inserted NUMBER :=0;
159:

Line 162: edw_log.put_line('Starting Push_EDW_GL_BOOK_BOOK_LSTG');

158: l_rows_inserted NUMBER :=0;
159:
160: BEGIN
161:
162: edw_log.put_line('Starting Push_EDW_GL_BOOK_BOOK_LSTG');
163: l_date1 := p_from_date;
164: l_date2 := p_to_date;
165:
166: Insert Into EDW_GL_BOOK_BOOK_LSTG(

Line 166: Insert Into EDW_GL_BOOK_BOOK_LSTG(

162: edw_log.put_line('Starting Push_EDW_GL_BOOK_BOOK_LSTG');
163: l_date1 := p_from_date;
164: l_date2 := p_to_date;
165:
166: Insert Into EDW_GL_BOOK_BOOK_LSTG(
167: ACCT_PEIROD_TYPE,
168: ALL_FK,
169: BOOK_PK,
170: CHART_OF_ACCTS_ID,

Line 213: edw_log.put_line('Commiting records for EDW_GL_BOOK_BOOK_LSTG');

209: trunc(sysdate)
210: from FII_GL_BOOK_BOOK_LCV
211: where last_update_date between l_date1 and l_date2;
212:
213: edw_log.put_line('Commiting records for EDW_GL_BOOK_BOOK_LSTG');
214: commit;
215:
216: edw_log.put_line('Completed Push_EDW_GL_BOOK_BOOK_LSTG');
217:

Line 216: edw_log.put_line('Completed Push_EDW_GL_BOOK_BOOK_LSTG');

212:
213: edw_log.put_line('Commiting records for EDW_GL_BOOK_BOOK_LSTG');
214: commit;
215:
216: edw_log.put_line('Completed Push_EDW_GL_BOOK_BOOK_LSTG');
217:
218: Exception When others then
219: raise;
220: commit;