APPS.FII_AP_AP_PAYMENT_M_C dependencies on EDW_AP_APPY_PAYMENT_LSTG

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

47:
48: l_temp_date := sysdate;
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:

Line 78: Procedure Push_EDW_AP_APPY_PAYMENT_LSTG(p_from_date IN date, p_to_date IN DATE) IS

74: commit;
75: End;
76:
77:
78: Procedure Push_EDW_AP_APPY_PAYMENT_LSTG(p_from_date IN date, p_to_date IN DATE) IS
79: l_date1 DATE;
80: l_date2 DATE;
81: l_rows_inserted NUMBER :=0;
82: BEGIN

Line 83: edw_log.put_line('Starting Push_EDW_AP_APPY_PAYMENT_LSTG');

79: l_date1 DATE;
80: l_date2 DATE;
81: l_rows_inserted NUMBER :=0;
82: BEGIN
83: edw_log.put_line('Starting Push_EDW_AP_APPY_PAYMENT_LSTG');
84: l_date1 := p_from_date;
85: l_date2 := p_to_date;
86: Insert Into
87: EDW_AP_APPY_PAYMENT_LSTG(

Line 87: EDW_AP_APPY_PAYMENT_LSTG(

83: edw_log.put_line('Starting Push_EDW_AP_APPY_PAYMENT_LSTG');
84: l_date1 := p_from_date;
85: l_date2 := p_to_date;
86: Insert Into
87: EDW_AP_APPY_PAYMENT_LSTG(
88: CHECK_FK,
89: CREATION_DATE,
90: INSTANCE,
91: INVOICE_PAYMENT_ID,

Line 126: edw_log.put_line('Commiting records for EDW_AP_APPY_PAYMENT_LSTG');

122:
123:
124: l_rows_inserted := sql%rowcount;
125: g_row_count := g_row_count + l_rows_inserted ;
126: edw_log.put_line('Commiting records for EDW_AP_APPY_PAYMENT_LSTG');
127: commit;
128:
129: edw_log.put_line('Completed Push_EDW_AP_APPY_PAYMENT_LSTG');
130: Exception When others then

Line 129: edw_log.put_line('Completed Push_EDW_AP_APPY_PAYMENT_LSTG');

125: g_row_count := g_row_count + l_rows_inserted ;
126: edw_log.put_line('Commiting records for EDW_AP_APPY_PAYMENT_LSTG');
127: commit;
128:
129: edw_log.put_line('Completed Push_EDW_AP_APPY_PAYMENT_LSTG');
130: Exception When others then
131: raise;
132: commit;
133: END;