1 PACKAGE ENG_CHANGE_ATTR_UTIL AUTHID CURRENT_USER AS
2 /* $Header: ENGVCAUS.pls 120.13 2007/05/10 16:38:43 asjohal ship $ */
3
4
5 G_ATTR_NULL_CHAR CONSTANT VARCHAR2(1) := '!';
6 G_ATTR_NULL_NUM CONSTANT NUMBER := -999;
7 G_ATTR_NULL_DATE CONSTANT DATE := FND_API.G_MISS_DATE ;
8 G_EXEC_MODE_IMPORT CONSTANT VARCHAR2(10) := 'IMPORT';
9
10
11 PROCEDURE INSERT_ITEM_ATTRS
12 (
13 p_api_version IN NUMBER
14 ,p_object_name IN VARCHAR2
15 ,p_application_id IN NUMBER
16 ,p_attr_group_type IN VARCHAR2
17 ,p_base_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
18 ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
19 ,x_return_status OUT NOCOPY VARCHAR2
20 ,x_errorcode OUT NOCOPY NUMBER
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2
23 ,p_exec_mode IN VARCHAR2
24 );
25
26 PROCEDURE UPDATE_ITEM_ATTRS
27 ( p_api_version IN NUMBER
28 ,p_object_name IN VARCHAR2
29 ,p_application_id IN NUMBER
30 ,p_attr_group_type IN VARCHAR2
31 ,p_base_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
32 ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
33 ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
34 ,x_return_status OUT NOCOPY VARCHAR2
35 ,x_errorcode OUT NOCOPY NUMBER
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 ,p_exec_mode IN VARCHAR2
39 );
40
41 PROCEDURE DELETE_ITEM_ATTRS
42 ( p_api_version IN NUMBER
43 ,p_object_name IN VARCHAR2
44 ,p_application_id IN NUMBER
45 ,p_attr_group_type IN VARCHAR2
46 ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_errorcode OUT NOCOPY NUMBER
49 ,x_msg_count OUT NOCOPY NUMBER
50 ,x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53
54 PROCEDURE INSERT_ITEM_USER_ATTRS
55 (
56 p_api_version IN NUMBER
57 ,p_object_name IN VARCHAR2
58 ,p_attr_group_id IN NUMBER
59 ,p_application_id IN NUMBER
60 ,p_attr_group_type IN VARCHAR2
61 ,p_attr_group_name IN VARCHAR2
62 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
63 ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
64 ,P_DATA_LEVEL_NAME IN VARCHAR2
65 ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY :=null
66 ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
67 ,p_mode IN VARCHAR2
68 ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
69 ,p_extension_id IN NUMBER
70 ,p_pending_b_table_name IN VARCHAR2
71 ,p_pending_tl_table_name IN VARCHAR2
72 ,p_pending_vl_name IN VARCHAR2
73 ,p_acd_type IN VARCHAR2
74 ,p_dml_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
75 ,p_api_caller IN VARCHAR2
76 ,p_key_attr_upd IN VARCHAR2
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_errorcode OUT NOCOPY NUMBER
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE VALIDATE_USER_ATTRS
84 (
85 p_api_version IN NUMBER
86 ,p_object_name IN VARCHAR2
87 ,p_attr_group_id IN NUMBER
88 ,p_attr_group_type IN VARCHAR2
89 ,p_application_id IN NUMBER
90 ,p_attr_group_name IN VARCHAR2
91 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
92 ,p_extension_id IN NUMBER
93 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
94 ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
95 ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
96 ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
97 ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
98 ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
99 ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
100 ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
101 ,p_row_identifier IN NUMBER DEFAULT NULL
102 ,p_validate_only IN VARCHAR2
103 ,p_mode IN VARCHAR2
104 ,p_acd_type IN VARCHAR2
105 ,p_init_fnd_msg_list IN VARCHAR2
106 ,p_add_errors_to_fnd_stack IN VARCHAR2
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_errorcode OUT NOCOPY NUMBER
109 ,x_msg_count OUT NOCOPY NUMBER
110 ,x_msg_data OUT NOCOPY VARCHAR2
111 ,p_key_attr_upd IN VARCHAR2
112 ,p_data_level_name IN VARCHAR2
113 ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
114 );
115
116 PROCEDURE SETUP_IMPL_ATTR_DATA_ROW
117 (
118 p_api_version IN NUMBER
119 ,p_object_name IN VARCHAR2
120 ,p_attr_group_id IN NUMBER
121 ,p_application_id IN NUMBER
122 ,p_attr_group_type IN VARCHAR2
123 ,p_attr_group_name IN VARCHAR2
124 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
125 ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
126 ,p_data_level_name IN VARCHAR2
127 ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
128 ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
129 ,x_setup_attr_data OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
130 ,x_return_status OUT NOCOPY VARCHAR2
131 ,x_errorcode OUT NOCOPY NUMBER
132 ,x_msg_count OUT NOCOPY NUMBER
133 ,x_msg_data OUT NOCOPY VARCHAR2
134 );
135
136 PROCEDURE VALIDATE_GDSN_RECORDS(p_inventory_item_id IN NUMBER
137 ,p_organization_id IN NUMBER
138 ,p_attr_group_type IN VARCHAR2
139 ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
140 ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
141 ,x_return_status OUT NOCOPY VARCHAR2
142 ,x_msg_count OUT NOCOPY NUMBER
143 ,x_msg_data OUT NOCOPY VARCHAR2
144
145 );
146
147 PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
148 ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
149 ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
150 ,P_OBJECT_NAME VARCHAR2
151 ,P_APPLICATION_ID NUMBER);
152
153
154 PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE
155 ,x_rec_column OUT NOCOPY VARCHAR2
156 ,p_attr_name IN VARCHAR2);
157
158 PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE
159 ,x_rec_column OUT NOCOPY NUMBER
160 ,p_attr_name IN VARCHAR2);
161
162 PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE
163 ,x_rec_column OUT NOCOPY DATE
164 ,p_attr_name IN VARCHAR2);
165
166
167 PROCEDURE GET_ATTR_GRP_VO_DEF
168 (
169 p_change_attr_group_type IN VARCHAR2
170 ,p_object_name IN VARCHAR2
171 ,p_application_short_name IN VARCHAR2
172 ,x_vo_def OUT NOCOPY VARCHAR2
173 );
174
175 PROCEDURE GET_ATTR_GRP_VO_INSTANCE
176 (
177 p_change_attr_group_type IN VARCHAR2
178 ,p_object_name IN VARCHAR2
179 ,p_application_short_name IN VARCHAR2
180 ,x_vo_instance OUT NOCOPY VARCHAR2
181 );
182
183 PROCEDURE GET_ATTR_GRP_VO_ROW_CLASS
184 (
185 p_change_attr_group_type IN VARCHAR2
186 ,p_object_name IN VARCHAR2
187 ,p_application_short_name IN VARCHAR2
188 ,x_vo_row_class OUT NOCOPY VARCHAR2
189 );
190
191 PROCEDURE GET_ATTR_GRP_EO_DEF
192 (
193 p_change_attr_group_type IN VARCHAR2
194 ,p_object_name IN VARCHAR2
195 ,p_application_short_name IN VARCHAR2
196 ,x_eo_def OUT NOCOPY VARCHAR2
197 );
198
199 PROCEDURE GET_ATTR_GRP_BASE_TABLE
200 (
201 p_change_attr_group_type IN VARCHAR2
202 ,p_object_name IN VARCHAR2
203 ,p_application_short_name IN VARCHAR2
204 ,x_base_table OUT NOCOPY VARCHAR2
205 );
206
207 PROCEDURE GET_ATTR_GRP_TL_TABLE
208 (
209 p_change_attr_group_type IN VARCHAR2
210 ,p_object_name IN VARCHAR2
211 ,p_application_short_name IN VARCHAR2
212 ,x_tl_table OUT NOCOPY VARCHAR2
213 );
214
215 PROCEDURE GET_ATTR_GRP_VL_NAME
216 (
217 p_change_attr_group_type IN VARCHAR2
218 ,p_object_name IN VARCHAR2
219 ,p_application_short_name IN VARCHAR2
220 ,x_vl_name OUT NOCOPY VARCHAR2
221 );
222
223 PROCEDURE GET_CONTEXT_VALUE
224 (
225 p_change_attr_group_type IN VARCHAR2
226 ,p_object_name IN VARCHAR2
227 ,p_application_short_name IN VARCHAR2
228 ,p_context_type IN VARCHAR2
229 ,x_context_value OUT NOCOPY VARCHAR2
230 );
231
232 PROCEDURE DEL_PEND_ATTR_CHGS
233 (
234 P_MODE IN VARCHAR2
235 ,P_CHANGE_ID IN NUMBER
236 ,P_CHANGE_LINE_ID IN NUMBER
237 ,P_ORG_ID IN NUMBER
238 ,P_DATA_LEVEL_NAME IN VARCHAR2
239 ,P_DATA_LEVEL_NAME_VALUE_PAIRS IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
240 );
241
242 PROCEDURE SAVE_ITEM_NUM_DESC( p_change_id IN NUMBER
243 , p_change_line_id IN number
244 , p_organization_id IN NUMBER
245 , p_item_id IN NUMBER
246 , p_item_num IN VARCHAR2 DEFAULT NULL
247 , p_item_desc IN VARCHAR2 DEFAULT NULL
248 ,p_transaction_mode IN VARCHAR2
249 , x_return_status OUT NOCOPY VARCHAR2
250 );
251
252 END ENG_CHANGE_ATTR_UTIL;