APPS.FII_GL_BOOK_M_C dependencies on EDW_GL_BOOK_FA_BOOK_LSTG

Line 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);

59:
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;

Line 89: Procedure Push_EDW_GL_BOOK_FA_BOOK_LSTG(p_from_date IN date, p_to_date IN DATE) IS

85: commit;
86: End;
87:
88:
89: Procedure Push_EDW_GL_BOOK_FA_BOOK_LSTG(p_from_date IN date, p_to_date IN DATE) IS
90: l_date1 DATE;
91: l_date2 DATE;
92: l_rows_inserted NUMBER :=0;
93:

Line 95: edw_log.put_line('Starting Push_EDW_GL_BOOK_FA_BOOK_LSTG');

91: l_date2 DATE;
92: l_rows_inserted NUMBER :=0;
93:
94: BEGIN
95: edw_log.put_line('Starting Push_EDW_GL_BOOK_FA_BOOK_LSTG');
96: l_date1 := p_from_date;
97: l_date2 := p_to_date;
98:
99: Insert Into EDW_GL_BOOK_FA_BOOK_LSTG(

Line 99: Insert Into EDW_GL_BOOK_FA_BOOK_LSTG(

95: edw_log.put_line('Starting Push_EDW_GL_BOOK_FA_BOOK_LSTG');
96: l_date1 := p_from_date;
97: l_date2 := p_to_date;
98:
99: Insert Into EDW_GL_BOOK_FA_BOOK_LSTG(
100: BOOK_FK,
101: BOOK_TYPE_NAME,
102: CURRENCY_CODE,
103: DELETION_DATE,

Line 144: edw_log.put_line('Commiting records for EDW_GL_BOOK_FA_BOOK_LSTG');

140: where last_update_date between l_date1 and l_date2;
141:
142: l_rows_inserted := sql%rowcount;
143: g_row_count := g_row_count + l_rows_inserted ;
144: edw_log.put_line('Commiting records for EDW_GL_BOOK_FA_BOOK_LSTG');
145: commit;
146:
147: edw_log.put_line('Completed Push_EDW_GL_BOOK_FA_BOOK_LSTG');
148:

Line 147: edw_log.put_line('Completed Push_EDW_GL_BOOK_FA_BOOK_LSTG');

143: g_row_count := g_row_count + l_rows_inserted ;
144: edw_log.put_line('Commiting records for EDW_GL_BOOK_FA_BOOK_LSTG');
145: commit;
146:
147: edw_log.put_line('Completed Push_EDW_GL_BOOK_FA_BOOK_LSTG');
148:
149: Exception When others then
150: raise;
151: commit;