1 PACKAGE DDR_ODI AUTHID CURRENT_USER AS
2 /* $Header: ddrodis.pls 120.4.12020000.3 2012/08/04 02:32:30 gglover noship $ */
3
4 --Type and global variable declarations
5 TYPE code_type IS TABLE OF VARCHAR2(10000) INDEX BY BINARY_INTEGER;
6 TYPE account_array IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
7
8 /*Duplicate Check*/
9 PROCEDURE DUP_CHECK (
10 p_src_tbl_name IN VARCHAR2,
11 p_err_tbl_name IN VARCHAR2,
12 p_key_cols IN VARCHAR2,
13 p_src_typ IN VARCHAR2,
14 p_load_id IN NUMBER
15 );
16 /*Move Errors*/
17 PROCEDURE MOVE_ERRORS (
18 p_src_tbl_name IN VARCHAR2,
19 p_err_tbl_name IN VARCHAR2,
20 p_trgt_tbl_name IN VARCHAR2,
21 p_src_typ IN VARCHAR2,
22 p_load_id IN NUMBER
23 );
24 /*Error Processing*/
25 FUNCTION GET_ERROR (
26 p_error_cd IN VARCHAR2
27 ) RETURN VARCHAR2;
28
29 PROCEDURE IS_VALID (
30 p_src_tab IN VARCHAR2,
31 p_src_clm IN VARCHAR2,
32 p_tgt_tab IN VARCHAR2,
33 p_tgt_clm IN VARCHAR2,
34 p_null_chk IN VARCHAR2 DEFAULT 'N',
35 p_where IN VARCHAR2 DEFAULT NULL,
36 p_error_cols IN VARCHAR2 DEFAULT NULL,
37 p_error_cd IN VARCHAR2,
38 p_load_id IN NUMBER
39 );
40
41 PROCEDURE NULL_CHECK (
42 p_src_tab IN VARCHAR2,
43 p_src_clm IN VARCHAR2,
44 p_error_cd IN VARCHAR2,
45 p_load_id IN NUMBER
46 );
47
48 PROCEDURE ALLOC_MOVE_ERR (
49 p_src_tbl_name IN VARCHAR2,
50 p_err_tbl_name IN VARCHAR2,
51 p_trgt_tbl_name IN VARCHAR2,
52 p_run_typ IN VARCHAR2,
53 p_load_id IN NUMBER,
54 p_generic_err_msg IN VARCHAR2
55 );
56
57 PROCEDURE PARSE_PAD_ACCOUNTS (
58 p_max_level IN NUMBER DEFAULT 10
59 );
60
61 /*Move Errors with Filter*/
62 PROCEDURE MOVE_ERRORS (
63 p_src_tbl_name IN VARCHAR2,
64 p_err_tbl_name IN VARCHAR2,
65 p_trgt_tbl_name IN VARCHAR2,
66 p_src_typ IN VARCHAR2,
67 p_filter IN VARCHAR2,
68 p_load_id IN NUMBER
69 );
70
71 PROCEDURE TRUNC_TABLE (
72 p_table IN VARCHAR2
73 );
74
75
76 END DDR_ODI;