APPS.EDW_OE_SLCHNL_M_C dependencies on EDW_OE_SCHN_SCHN_LSTG

Line 54: Push_EDW_OE_SCHN_SCHN_LSTG(EDW_OE_SLCHNL_M_C.g_push_date_range1, EDW_OE_SLCHNL_M_C.g_push_date_range2);

50:
51: l_temp_date := sysdate;
52:
53:
54: Push_EDW_OE_SCHN_SCHN_LSTG(EDW_OE_SLCHNL_M_C.g_push_date_range1, EDW_OE_SLCHNL_M_C.g_push_date_range2);
55:
56:
57: l_duration := sysdate - l_temp_date;
58:

Line 79: Procedure Push_EDW_OE_SCHN_SCHN_LSTG(p_from_date IN date, p_to_date IN DATE) IS

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

Line 84: edw_log.put_line('Starting Push_EDW_OE_SCHN_SCHN_LSTG');

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

Line 88: EDW_OE_SCHN_SCHN_LSTG(

84: edw_log.put_line('Starting Push_EDW_OE_SCHN_SCHN_LSTG');
85: l_date1 := p_from_date;
86: l_date2 := p_to_date;
87: Insert Into
88: EDW_OE_SCHN_SCHN_LSTG(
89: ACTIVE_FROM_DATE,
90: ACTIVE_TO_DATE,
91: ALL_FK,
92: CREATION_DATE,

Line 133: edw_log.put_line('Commiting records for EDW_OE_SCHN_SCHN_LSTG');

129:
130:
131: l_rows_inserted := sql%rowcount;
132: EDW_OE_SLCHNL_M_C.g_row_count := EDW_OE_SLCHNL_M_C.g_row_count + l_rows_inserted ;
133: edw_log.put_line('Commiting records for EDW_OE_SCHN_SCHN_LSTG');
134: commit;
135:
136: edw_log.put_line('Completed Push_EDW_OE_SCHN_SCHN_LSTG');
137: Exception When others then

Line 136: edw_log.put_line('Completed Push_EDW_OE_SCHN_SCHN_LSTG');

132: EDW_OE_SLCHNL_M_C.g_row_count := EDW_OE_SLCHNL_M_C.g_row_count + l_rows_inserted ;
133: edw_log.put_line('Commiting records for EDW_OE_SCHN_SCHN_LSTG');
134: commit;
135:
136: edw_log.put_line('Completed Push_EDW_OE_SCHN_SCHN_LSTG');
137: Exception When others then
138: raise;
139: commit;
140: END;