APPS.FII_AR_TRX_TYPE_M_C dependencies on EDW_ARTT_CODE_LSTG

Line 52: Push_EDW_ARTT_CODE_LSTG(FII_AR_TRX_TYPE_M_C.g_push_date_range1, FII_AR_TRX_TYPE_M_C.g_push_date_range2);

48: l_temp_date := sysdate;
49:
50:
51: Push_EDW_ARTT_TYPE_LSTG(FII_AR_TRX_TYPE_M_C.g_push_date_range1, FII_AR_TRX_TYPE_M_C.g_push_date_range2);
52: Push_EDW_ARTT_CODE_LSTG(FII_AR_TRX_TYPE_M_C.g_push_date_range1, FII_AR_TRX_TYPE_M_C.g_push_date_range2);
53:
54:
55: l_duration := sysdate - l_temp_date;
56:

Line 173: Procedure Push_EDW_ARTT_CODE_LSTG(p_from_date IN date, p_to_date IN DATE) IS

169: commit;
170: END;
171:
172:
173: Procedure Push_EDW_ARTT_CODE_LSTG(p_from_date IN date, p_to_date IN DATE) IS
174: l_date1 DATE;
175: l_date2 DATE;
176: l_rows_inserted NUMBER :=0;
177: BEGIN

Line 178: edw_log.put_line('Starting Push_EDW_ARTT_CODE_LSTG');

174: l_date1 DATE;
175: l_date2 DATE;
176: l_rows_inserted NUMBER :=0;
177: BEGIN
178: edw_log.put_line('Starting Push_EDW_ARTT_CODE_LSTG');
179: l_date1 := p_from_date;
180: l_date2 := p_to_date;
181: Insert Into
182: EDW_ARTT_CODE_LSTG(

Line 182: EDW_ARTT_CODE_LSTG(

178: edw_log.put_line('Starting Push_EDW_ARTT_CODE_LSTG');
179: l_date1 := p_from_date;
180: l_date2 := p_to_date;
181: Insert Into
182: EDW_ARTT_CODE_LSTG(
183: ALL_FK,
184: CREATION_DATE,
185: DESCRIPTION,
186: ENABLED_FLAG,

Line 223: edw_log.put_line('Commiting records for EDW_ARTT_CODE_LSTG');

219: from FII_AR_ARTT_CODE_LCV
220: where last_update_date between l_date1 and l_date2;
221:
222:
223: edw_log.put_line('Commiting records for EDW_ARTT_CODE_LSTG');
224: commit;
225:
226: edw_log.put_line('Completed Push_EDW_ARTT_CODE_LSTG');
227: Exception When others then

Line 226: edw_log.put_line('Completed Push_EDW_ARTT_CODE_LSTG');

222:
223: edw_log.put_line('Commiting records for EDW_ARTT_CODE_LSTG');
224: commit;
225:
226: edw_log.put_line('Completed Push_EDW_ARTT_CODE_LSTG');
227: Exception When others then
228: raise;
229: commit;
230: END;