7:
8: procedure pull_time_data(
9: errbuf OUT NOCOPY VARCHAR2,
10: retcode OUT NOCOPY VARCHAR2) IS
11: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.TIME_STAGING_TABLE ;
12: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.TIME_FACT_TABLE ;
13: /*********************************************************************
14: Cursor to get distinct Instance, Calendar_Code Max Data and Min Date
15: *********************************************************************/
8: procedure pull_time_data(
9: errbuf OUT NOCOPY VARCHAR2,
10: retcode OUT NOCOPY VARCHAR2) IS
11: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.TIME_STAGING_TABLE ;
12: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.TIME_FACT_TABLE ;
13: /*********************************************************************
14: Cursor to get distinct Instance, Calendar_Code Max Data and Min Date
15: *********************************************************************/
16: /* DWK. Fix Bug 2220983. Do not include instance = '0' in the cursor */