1 PACKAGE pon_uda_import_pkg AUTHID CURRENT_USER AS
2 /* $Header: PON_UDA_IMPORT_PKG.pls 120.0.12020000.2 2013/02/09 11:27:50 hvutukur noship $ */
3
4 PROCEDURE POPULATE_STRUCTURES
5 (
6 p_attr_grp_type IN VARCHAR2
7 ,p_pk1_value IN NUMBER
8 ,p_pk2_value IN NUMBER
9 ,p_pk3_value IN NUMBER
10 ,p_pk4_value IN NUMBER
11 ,p_pk5_value IN NUMBER
12 ,x_base_object_name IN OUT NOCOPY VARCHAR2
13 ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
14 ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
15 ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
16 ,x_class_code_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
17 ,x_return_status OUT NOCOPY VARCHAR2
18 ,x_errorcode OUT NOCOPY NUMBER
19 ,x_msg_count OUT NOCOPY NUMBER
20 ,x_msg_data OUT NOCOPY VARCHAR2
21 );
22
23 PROCEDURE POPULATE_REMAINING_ATTRIBUTES
24 (
25 x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
26 ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
27 ,x_return_status OUT NOCOPY VARCHAR2
28 ,x_errorcode OUT NOCOPY NUMBER
29 ,x_msg_count OUT NOCOPY NUMBER
30 ,x_msg_data OUT NOCOPY VARCHAR2
31 );
32
33 PROCEDURE POPULATE_EMPTY_AGS
34 (
35 p_template_id IN NUMBER
36 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
37 ,p_external_attr_value_pairs IN EGO_COL_NAME_VALUE_PAIR_TABLE
38 ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
39 ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
40 ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
41 ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_errorcode OUT NOCOPY NUMBER
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 );
47
48 PROCEDURE EXECUTE_IMPORT_UDA_FUNCTION
49 (
50 p_template_id IN NUMBER
51 ,p_event IN VARCHAR2
52 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
53 ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
54 ,x_attr_name_value_pairs IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
55 ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_errorcode OUT NOCOPY NUMBER
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE IMPORT_UDA_ATTRS
63 (
64 p_attr_grp_type IN VARCHAR2
65 ,p_pk1_value IN NUMBER
66 ,p_pk2_value IN NUMBER DEFAULT NULL
67 ,p_pk3_value IN NUMBER DEFAULT NULL
68 ,p_pk4_value IN NUMBER DEFAULT NULL
69 ,p_pk5_value IN NUMBER DEFAULT NULL
70 ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
71 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_errorcode OUT NOCOPY NUMBER
74 ,x_msg_count OUT NOCOPY NUMBER
75 ,x_msg_data OUT NOCOPY VARCHAR2
76
77 );
78
79 PROCEDURE HANDLE_ERROR
80 (
81 p_msg IN VARCHAR2
82 ,p_msg_code IN VARCHAR2
83 ,p_attr_grp_id IN NUMBER
84 );
85
86 PROCEDURE UPDATE_STATUS
87 (
88 p_process_status IN NUMBER
89 ,p_pre_process_status IN NUMBER
90 ,p_process_phase IN VARCHAR2
91 ,p_pk1_value IN NUMBER
92 ,p_pk2_value IN NUMBER
93 ,p_pk3_value IN NUMBER
94 ,p_pk4_value IN NUMBER
95 ,p_pk5_value IN NUMBER
96 );
97
98 PROCEDURE CONSTRUCT_PK_OBJECT
99 (
100 p_obj_name IN VARCHAR2
101 ,p_pk1_value IN NUMBER
102 ,p_pk2_value IN NUMBER DEFAULT NULL
103 ,p_pk3_value IN NUMBER DEFAULT NULL
104 ,p_pk4_value IN NUMBER DEFAULT NULL
105 ,p_pk5_value IN NUMBER DEFAULT NULL
106 ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
107 );
108
109 PROCEDURE SET_EXT_ATTR_NAME_VALUE_PAIR
110 (
111 p_ext_attr_name IN VARCHAR2
112 ,p_ext_attr_value IN VARCHAR2
113 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
114 );
115
116 PROCEDURE GET_EXT_ATTR_NAME_VALUE_PAIR
117 (
118 p_ext_attr_name IN VARCHAR2
119 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
120 ,x_ext_name_val_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
121 );
122
123 PROCEDURE DEBUG
124 (
125 p_structure_array IN EGO_COL_NAME_VALUE_PAIR_ARRAY
126 ,p_progress IN NUMBER
127 );
128
129 PROCEDURE DEBUG
130 (
131 p_structure_array IN EGO_COL_NAME_VALUE_PAIR_TABLE
132 ,p_progress IN NUMBER
133 );
134
135 PROCEDURE DEBUG
136 (
137 p_structure_array IN EGO_ATTR_GROUP_REQUEST_TABLE
138 ,p_progress IN NUMBER
139 );
140
141 PROCEDURE DEBUG
142 (
143 p_structure_array IN EGO_USER_ATTR_DATA_TABLE
144 ,p_progress IN NUMBER
145 );
146
147 PROCEDURE DEBUG
148 (
149 p_structure_array IN EGO_USER_ATTR_ROW_TABLE
150 ,p_progress IN NUMBER
151 );
152
153 PROCEDURE DEBUG
154 (
155 p_structure_array IN PO_UDA_USAGE_OBJECT_ARRAY
156 ,p_progress IN NUMBER
157 );
158
159 PROCEDURE DEBUG
160 (
161 p_structure_array IN PO_TBL_NUMBER
162 ,p_progress IN NUMBER
163 );
164
165 PROCEDURE DEBUG
166 (
167 p_msg IN VARCHAR2
168 ,p_progress IN NUMBER
169 );
170
171 END PON_UDA_IMPORT_PKG;