1 PACKAGE BIS_DIMLEVEL_ERRS_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVEDES.pls 115.4 2002/12/16 10:25:33 rchandra ship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BISVGDLS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Private Script for reporting inconsistencies in the dimension levels
13 REM | of EDW like missing table for values, missing PK Key, start_Date |
14 REM | end_Date etc |
15 REM | This package has limited error handling for file activities. |
16 REM | |
17 REM | HISTORY |
18 REM | December-2000 amkulkar Creation |
19 REM +=======================================================================+
20 */
21 --
22 -- CONSTANTS
23 EDW_ERRORS VARCHAR2(2000) := 'DIMLEVELERRORS.log';
24 PROCEDURE FILE_OPEN
25 (p_file_name IN VARCHAR2 DEFAULT EDW_ERRORS
26 ,x_file_handle OUT NOCOPY UTL_FILE.FILE_TYPE
27 );
28 PROCEDURE WRITE_TO_FILE
29 (p_text IN VARCHAR2
30 ,p_file_handle IN UTL_FILE.FILE_TYPE
31 );
32 PROCEDURE REPORT_ERRORS
33 (p_Dim_Level_Name IN VARCHAR2 DEFAULT NULL
34 ,p_file_name IN VARCHAR2 DEFAULT NULL
35 );
36 END BIS_DIMLEVEL_ERRS_PVT;