1 PACKAGE HR_DU_DO_DATAPUMP AUTHID CURRENT_USER AS
2 /* $Header: perdudp.pkh 115.12 2002/12/05 12:55:59 apholt noship $ */
3
4
5 TYPE r_insert_statement_type IS RECORD
6 (
7 r_api_id NUMBER,
8 r_upload_header_id NUMBER,
9 r_insert_string VARCHAR2(32767),
10 r_PVAL_string VARCHAR2(32767),
11 --String of pval*** to identify the correct columns for the keys
12 r_user_key_pval VARCHAR2(2000),
13 r_pval_parent_line_id VARCHAR2(50),
14 r_parent_api_module_number VARCHAR2(50),
15 r_pval_api_module_number VARCHAR2(50));
16
17
18
19 --this record will build up a table that helps to remember
20 --user keys so that less select statements are performed.
21 TYPE r_user_key_type IS RECORD
22 (
23 r_api_module_id NUMBER,
24 r_column_id NUMBER,
25 r_user_key VARCHAR2(50),
26 r_actual_user_key VARCHAR2(300));
27
28 TYPE REM_USER_KEYS_TABLE IS TABLE OF R_USER_KEY_TYPE
29 INDEX BY BINARY_INTEGER;
30
31 TYPE insert_table_type IS TABLE OF R_INSERT_STATEMENT_TYPE
32 INDEX BY BINARY_INTEGER;
33
34 --Holds all of the column headings
35 TYPE column_headings_table IS TABLE OF VARCHAR2(50)
36 INDEX BY BINARY_INTEGER;
37
38 /*--------------------------- GLOBAL VARIABLES ----------------------------*/
39
40 g_values_table INSERT_TABLE_TYPE;
41 g_column_headings COLUMN_HEADINGS_TABLE;
42 g_user_key_table REM_USER_KEYS_TABLE;
43
44
45 /*-------------------------------------------------------------------------*/
46
47
48
49 PROCEDURE VALIDATE(p_upload_id IN NUMBER);
50
51 PROCEDURE ROLLBACK(p_upload_id IN NUMBER);
52
53 PROCEDURE MAIN(p_upload_id IN NUMBER);
54
55 FUNCTION RETURN_CREATED_USER_KEY(
56 p_api_module_id IN NUMBER,
57 p_column_id IN NUMBER,
58 p_upload_id IN NUMBER,
59 p_user_key OUT NOCOPY VARCHAR2)
60 RETURN VARCHAR2;
61
62 FUNCTION RETURN_CREATED_USER_KEY_2(
63 p_column_id IN NUMBER,
64 p_api_module_id IN NUMBER,
65 p_upload_line_id IN NUMBER,
66 p_user_key OUT NOCOPY VARCHAR2)
67 RETURN VARCHAR2;
68
69 PROCEDURE STORE_COLUMN_HEADINGS (p_line_id IN NUMBER);
70
71 END HR_DU_DO_DATAPUMP;