1 PACKAGE hr_du_dp_pc_conversion AUTHID CURRENT_USER AS
2 /* $Header: perdupc.pkh 115.10 2002/11/28 16:57:08 apholt noship $ */
3
4
5 TYPE r_insert_statement_type IS RECORD(
6
7 --api id for this record
8 r_api_id NUMBER,
9 --string of none referencing columns (PVAL numbers)
10 r_none_ref_PVAL VARCHAR2(32767),
11 --string of referencing columns (PVAL numbers)
12 r_ref_PVAL VARCHAR2(32767),
13 --string of referencing columns (mapped column names)
14 r_ref_Col_Names VARCHAR2(32767),
15 --string of comma separated entity id's relating to
16 --appropriate referencing column's entities
17 r_ref_Col_apis VARCHAR2(300),
18 --holds the current maximumn values of the id column
19 r_id_curval NUMBER(15),
20 --holds a string of api_ids separated by commas
21 r_string_apis VARCHAR2(100),
22 --holds a list of Pval's associated with the r_string_apis
23 --to identify the correct location in the lines of the
24 --column that will hold the value to point up to its parent
25 r_api_PVALS VARCHAR2(300),
26 --holds a pval for the position in lines where the generic
27 --location of the api table name is held. Used on such
28 --api's as per_phones
29 r_generic_pval VARCHAR2(30));
30
31
32 TYPE R_MAPPED_TYPE IS RECORD(
33 r_mapping_type VARCHAR2(1),
34 r_mapped_to_name VARCHAR2(50),
35 r_mapped_name VARCHAR2(50));
36
37
38 TYPE insert_table_type IS TABLE OF R_INSERT_STATEMENT_TYPE
39 INDEX BY BINARY_INTEGER;
40
41 --Holds all of the column headings
42 TYPE column_headings_table IS TABLE OF VARCHAR2(50)
43 INDEX BY BINARY_INTEGER;
44
45 --Holds all of the mappedto names in the column mappings
46 --for a particular API
47 TYPE column_mapped_to_table IS TABLE OF R_MAPPED_TYPE
48 INDEX BY BINARY_INTEGER;
49
50 --Holds all the upload_header_ids for the starting points
51 TYPE starting_point_table IS TABLE OF NUMBER
52 INDEX BY BINARY_INTEGER;
53
54
55
56 FUNCTION RETURN_PARENT_API_MODULE_ID (
57 p_api_module_id IN NUMBER,
58 p_reference_string IN VARCHAR2)
59 RETURN NUMBER;
60
61 PROCEDURE API_MODULE_ID_TO_TABLE_ID;
62
63 PROCEDURE SWITCH_REFERENCING_INITIAL(
64 p_upload_id IN NUMBER);
65
66 PROCEDURE INSERT_API_MODULE_IDS (
67 p_upload_id IN NUMBER);
68
69 PROCEDURE CREATE_INSERT_STRING(
70 p_api_module_id IN NUMBER,
71 p_upload_header_id IN NUMBER,
72 p_array_pos IN NUMBER);
73
74 FUNCTION RETURN_FIELD_VALUE (
75 p_table IN VARCHAR2,
76 p_record_id IN NUMBER,
77 p_field_pk IN VARCHAR2,
78 p_field_name IN VARCHAR2)
79 RETURN VARCHAR2;
80
81 FUNCTION GENERAL_REFERENCING_COLUMN(
82 p_pval_field IN VARCHAR2,
83 p_api_module_id IN NUMBER,
84 p_mapping_type IN VARCHAR2)
85 RETURN VARCHAR2;
86
87 PROCEDURE VALIDATE(p_upload_id IN NUMBER);
88
89 PROCEDURE ROLLBACK(p_upload_id IN NUMBER);
90
91 PROCEDURE PROCESS_LINE(
92 p_prev_upload_line_id IN NUMBER,
93 p_prev_table_number IN NUMBER,
94 p_target_ID IN NUMBER,
95 p_target_api_module in NUMBER,
96 p_upload_header_id IN NUMBER,
97 p_upload_id IN NUMBER);
98
99 PROCEDURE REMOVE_SPACES (p_word IN OUT NOCOPY VARCHAR2,
100 p_spaces OUT NOCOPY BOOLEAN);
101
102 END HR_DU_DP_PC_CONVERSION;