APPS.FII_AP_AP_PAYMENT_M_C dependencies on EDW_AP_APPY_PYMT_MTHD_LSTG

Line 53: P_EDW_AP_APPY_PYMT_MTHD_LSTG(FII_AP_AP_PAYMENT_M_C.g_push_date_range1, FII_AP_AP_PAYMENT_M_C.g_push_date_range2);

49:
50:
51: Push_EDW_AP_APPY_PAYMENT_LSTG(FII_AP_AP_PAYMENT_M_C.g_push_date_range1, FII_AP_AP_PAYMENT_M_C.g_push_date_range2);
52: Push_EDW_AP_APPY_CHECK_LSTG(FII_AP_AP_PAYMENT_M_C.g_push_date_range1, FII_AP_AP_PAYMENT_M_C.g_push_date_range2);
53: P_EDW_AP_APPY_PYMT_MTHD_LSTG(FII_AP_AP_PAYMENT_M_C.g_push_date_range1, FII_AP_AP_PAYMENT_M_C.g_push_date_range2);
54:
55:
56: l_duration := sysdate - l_temp_date;
57:

Line 196: Procedure P_EDW_AP_APPY_PYMT_MTHD_LSTG(p_from_date IN date, p_to_date IN DATE) IS

192: commit;
193: END;
194:
195:
196: Procedure P_EDW_AP_APPY_PYMT_MTHD_LSTG(p_from_date IN date, p_to_date IN DATE) IS
197: l_date1 DATE;
198: l_date2 DATE;
199: l_rows_inserted NUMBER :=0;
200: BEGIN

Line 201: edw_log.put_line('Starting P_EDW_AP_APPY_PYMT_MTHD_LSTG');

197: l_date1 DATE;
198: l_date2 DATE;
199: l_rows_inserted NUMBER :=0;
200: BEGIN
201: edw_log.put_line('Starting P_EDW_AP_APPY_PYMT_MTHD_LSTG');
202: l_date1 := p_from_date;
203: l_date2 := p_to_date;
204: Insert Into
205: EDW_AP_APPY_PYMT_MTHD_LSTG(

Line 205: EDW_AP_APPY_PYMT_MTHD_LSTG(

201: edw_log.put_line('Starting P_EDW_AP_APPY_PYMT_MTHD_LSTG');
202: l_date1 := p_from_date;
203: l_date2 := p_to_date;
204: Insert Into
205: EDW_AP_APPY_PYMT_MTHD_LSTG(
206: ALL_FK,
207: CREATION_DATE,
208: DESCRIPTION,
209: INSTANCE,

Line 241: edw_log.put_line('Commiting records for EDW_AP_APPY_PYMT_MTHD_LSTG');

237: 'READY'
238: from FII_AP_AP_APPY_PYMT_MTHD_LCV;
239:
240:
241: edw_log.put_line('Commiting records for EDW_AP_APPY_PYMT_MTHD_LSTG');
242: commit;
243:
244: edw_log.put_line('Completed P_EDW_AP_APPY_PYMT_MTHD_LSTG');
245: Exception When others then

Line 244: edw_log.put_line('Completed P_EDW_AP_APPY_PYMT_MTHD_LSTG');

240:
241: edw_log.put_line('Commiting records for EDW_AP_APPY_PYMT_MTHD_LSTG');
242: commit;
243:
244: edw_log.put_line('Completed P_EDW_AP_APPY_PYMT_MTHD_LSTG');
245: Exception When others then
246: raise;
247: commit;
248: END;