APPS.FII_AP_RELEASE_M_C dependencies on EDW_RLSE_RELEASE_TYPE_LSTG

Line 52: P_EDW_RLSE_RELEASE_TYPE_LSTG(FII_AP_RELEASE_M_C.g_push_date_range1, FII_AP_RELEASE_M_C.g_push_date_range2);

48: l_temp_date := sysdate;
49:
50:
51: Push_EDW_RLSE_RELEASE_LSTG(FII_AP_RELEASE_M_C.g_push_date_range1, FII_AP_RELEASE_M_C.g_push_date_range2);
52: P_EDW_RLSE_RELEASE_TYPE_LSTG(FII_AP_RELEASE_M_C.g_push_date_range1, FII_AP_RELEASE_M_C.g_push_date_range2);
53:
54:
55: l_duration := sysdate - l_temp_date;
56:

Line 140: Procedure P_EDW_RLSE_RELEASE_TYPE_LSTG(p_from_date IN date, p_to_date IN DATE) IS

136: commit;
137: END;
138:
139:
140: Procedure P_EDW_RLSE_RELEASE_TYPE_LSTG(p_from_date IN date, p_to_date IN DATE) IS
141: l_date1 DATE;
142: l_date2 DATE;
143: l_rows_inserted NUMBER :=0;
144: BEGIN

Line 145: edw_log.put_line('Starting P_EDW_RLSE_RELEASE_TYPE_LSTG');

141: l_date1 DATE;
142: l_date2 DATE;
143: l_rows_inserted NUMBER :=0;
144: BEGIN
145: edw_log.put_line('Starting P_EDW_RLSE_RELEASE_TYPE_LSTG');
146: l_date1 := p_from_date;
147: l_date2 := p_to_date;
148: Insert Into
149: EDW_RLSE_RELEASE_TYPE_LSTG(

Line 149: EDW_RLSE_RELEASE_TYPE_LSTG(

145: edw_log.put_line('Starting P_EDW_RLSE_RELEASE_TYPE_LSTG');
146: l_date1 := p_from_date;
147: l_date2 := p_to_date;
148: Insert Into
149: EDW_RLSE_RELEASE_TYPE_LSTG(
150: ALL_FK,
151: CREATION_DATE,
152: DESCRIPTION,
153: INSTANCE,

Line 185: edw_log.put_line('Commiting records for EDW_RLSE_RELEASE_TYPE_LSTG');

181: 'READY'
182: from FII_AP_RLSE_RELEASE_TYPE_LCV;
183:
184:
185: edw_log.put_line('Commiting records for EDW_RLSE_RELEASE_TYPE_LSTG');
186: commit;
187:
188: edw_log.put_line('Completed P_EDW_RLSE_RELEASE_TYPE_LSTG');
189: Exception When others then

Line 188: edw_log.put_line('Completed P_EDW_RLSE_RELEASE_TYPE_LSTG');

184:
185: edw_log.put_line('Commiting records for EDW_RLSE_RELEASE_TYPE_LSTG');
186: commit;
187:
188: edw_log.put_line('Completed P_EDW_RLSE_RELEASE_TYPE_LSTG');
189: Exception When others then
190: raise;
191: commit;
192: END;