62:
63: Procedure Push_EDW_BRES_PLANT(
64: p_from_date IN Date,
65: p_to_date IN Date) IS
66: l_staging_table_name Varchar2(30) :='EDW_BRES_PLANT_LSTG' ;
67: L_PUSH_DATE_RANGE1 Date:=Null;
68: L_PUSH_DATE_RANGE2 Date:=Null;
69: l_rows_inserted Number:=0;
70:
83:
84: edw_log.put_line(' ');
85: edw_log.put_line('Pushing EDW_BRES_PLANT');
86:
87: Insert Into EDW_BRES_PLANT_LSTG(
88: ALL_FK,
89: ALL_FK_KEY,
90: CREATION_DATE,
91: DESCRIPTION,
151:
152: Procedure Push_EDW_BRES_PLANT1(
153: p_from_date IN Date,
154: p_to_date IN Date) IS
155: l_staging_table_name Varchar2(30) :='EDW_BRES_PLANT_LSTG' ;
156: L_PUSH_DATE_RANGE1 Date:=Null;
157: L_PUSH_DATE_RANGE2 Date:=Null;
158: l_rows_inserted Number:=0;
159: