DBA Data[Home] [Help]

APPS.MSD_PULL_TIME_DATA dependencies on MSD_COMMON_UTILITIES

Line 11: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.TIME_STAGING_TABLE ;

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: *********************************************************************/

Line 12: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.TIME_FACT_TABLE ;

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 */