[Home] [Help]
PACKAGE: APPS.INV_EBI_ITEM_HELPER
Source
1 PACKAGE INV_EBI_ITEM_HELPER AUTHID CURRENT_USER AS
2 /* $Header: INVEIHITS.pls 120.22 2011/01/20 16:07:43 smukka ship $ */
3
4 G_TEMPLATE CONSTANT NUMBER := 1;
5 G_INVENTORY_ITEM CONSTANT NUMBER := 2;
6 G_ORGANIZATION CONSTANT NUMBER := 3;
7 G_ITEM_CATALOG_GROUP CONSTANT NUMBER := 4;
8 G_LIFECYCLE CONSTANT NUMBER := 5;
9 G_CURRENT_PHASE CONSTANT NUMBER := 6;
10 G_REVISION CONSTANT NUMBER := 7;
11 G_HAZARD_CLASS CONSTANT NUMBER := 8;
12 G_ASSET_CATEGORY CONSTANT NUMBER := 9;
13 G_BASE_ITEM CONSTANT NUMBER := 10;
14 G_MANUFACTURER CONSTANT NUMBER := 11;
15 G_CATEGORY_SET CONSTANT NUMBER := 12;
16 G_CATEGORY CONSTANT NUMBER := 13;
17 G_ASSET_MGMT_ATTRS CONSTANT VARCHAR2(20) := 'ASSET_ATTRS';
18 G_BOM_ATTRS CONSTANT VARCHAR2(20) := 'BOM_ATTRS';
19 G_COSTING_ATTRS CONSTANT VARCHAR2(20) := 'COSTING_ATTRS';
20 G_GPLAN_ATTRS CONSTANT VARCHAR2(20) := 'GPLAN_ATTRS';
21 G_INVENTORY_ATTRS CONSTANT VARCHAR2(20) := 'INVENTORY_ATTRS';
22 G_INVOICE_ATTRS CONSTANT VARCHAR2(20) := 'INVOICE_ATTRS';
23 G_LEAD_TIME_ATTRS CONSTANT VARCHAR2(20) := 'LEAD_TIME_ATTRS';
24 G_MPSMRP_ATTRS CONSTANT VARCHAR2(20) := 'MPSMRP_ATTRS';
25 G_ORDER_ATTRS CONSTANT VARCHAR2(20) := 'ORDER_ATTRS';
26 G_PHYSICAL_ATTRS CONSTANT VARCHAR2(20) := 'PHYSICAL_ATTRS';
27 G_PROCESS_ATTRS CONSTANT VARCHAR2(20) := 'PROCESS_ATTRS';
28 G_PURCHASING_ATTRS CONSTANT VARCHAR2(20) := 'PURCHASING_ATTRS';
29 G_RECEVING_ATTRS CONSTANT VARCHAR2(20) := 'RECEIVING_ATTRS';
30 G_SERVICE_ATTRS CONSTANT VARCHAR2(20) := 'SERVICE_ATTRS';
31 G_WEB_OPTION_ATTRS CONSTANT VARCHAR2(20) := 'WEB_OPTION_ATTRS';
32 G_WIP_ATTRS CONSTANT VARCHAR2(20) := 'WIP_ATTRS';
33 G_ITEM_ATTRS CONSTANT VARCHAR2(20) := 'ITEM_ATTRS';
34 G_DEFAULT_COST_GROUP_ID CONSTANT VARCHAR2(25) := 'DEFAULT_ITEM_COST_GROUP';
35 G_DEFAULT_COST_TYPE_ID CONSTANT VARCHAR2(25) := 'DEFAULT_ITEM_COST_TYPE';
36 G_TIME_ZONE_OFFSET VARCHAR2(25) ;
37 G_ALLOW_LIFECYCLE_PHASE_SKIP CONSTANT VARCHAR2(30) := 'ALLOW_LIFECYCLE_PHASE_SKIP';-- Added for bug 11066016
38
39 TYPE inv_ebi_name_value_pair_rec IS RECORD(
40 Name VARCHAR2(75)
41 ,Value VARCHAR2(150)
42 );
43
44 TYPE inv_ebi_name_value_pair_tbl IS TABLE OF inv_ebi_name_value_pair_rec;
45
46 FUNCTION id_col_value(
47 p_col_name IN VARCHAR2
48 ,p_pk_col_name_val_pairs IN INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl
49 ) RETURN VARCHAR2;
50
51 FUNCTION value_to_id(
52 p_pk_col_name_val_pairs IN INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl
53 ,p_entity_name IN VARCHAR2
54 ) RETURN NUMBER;
55
56 FUNCTION id_to_value(
57 p_pk_col_name_val_pairs IN INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl
58 ,p_entity_name IN VARCHAR2
59 ) RETURN VARCHAR2;
60
61 PROCEDURE initialize_item(
62 x_item IN OUT NOCOPY inv_ebi_item_obj
63 );
64
65
66 Procedure sync_item (
67 p_commit IN VARCHAR2 := fnd_api.g_false
68 ,p_operation IN VARCHAR2
69 ,p_item IN inv_ebi_item_obj
70 ,x_out OUT NOCOPY inv_ebi_item_output_obj
71 ) ;
72
73 PROCEDURE process_item_pvt(
74 p_commit IN VARCHAR2 := fnd_api.g_false
75 ,p_operation IN VARCHAR2
76 ,p_item IN inv_ebi_item_obj
77 ,x_out OUT NOCOPY inv_ebi_item_output_obj
78 ) ;
79
80 PROCEDURE process_item_uda (
81 p_api_version IN NUMBER DEFAULT 1.0
82 ,p_inventory_item_id IN NUMBER
83 ,p_organization_id IN NUMBER
84 ,p_item_catalog_group_id IN NUMBER DEFAULT NULL
85 ,p_revision_id IN NUMBER DEFAULT NULL
86 ,p_revision_code IN VARCHAR2 DEFAULT NULL
87 ,p_uda_input_obj IN inv_ebi_uda_input_obj
88 ,p_commit IN VARCHAR2 := fnd_api.g_false
89 ,x_uda_output_obj OUT NOCOPY inv_ebi_item_output_obj
90 );
91
92 PROCEDURE process_org_id_assignments(
93 p_init_msg_list IN VARCHAR2
94 ,p_commit IN VARCHAR2 := fnd_api.g_false
95 ,p_inventory_item_id IN NUMBER
96 ,p_item_number IN VARCHAR2
97 ,p_org_id_tbl IN inv_ebi_org_tbl
98 ,x_out OUT NOCOPY inv_ebi_item_output_obj
99 );
100
101 PROCEDURE process_category_assignments(
102 p_api_version IN NUMBER DEFAULT 1.0
103 ,p_init_msg_list IN VARCHAR2
104 ,p_commit IN VARCHAR2 := fnd_api.g_false
105 ,p_inventory_item_id IN NUMBER
106 ,p_organization_id IN NUMBER
107 ,p_category_id_tbl IN inv_ebi_category_obj_tbl_type
108 ,x_out OUT NOCOPY inv_ebi_item_output_obj
109 );
110
111 PROCEDURE process_part_num_association(
112 p_commit IN VARCHAR2 := fnd_api.g_false
113 ,p_organization_id IN NUMBER
114 ,p_inventory_item_id IN NUMBER
115 ,p_mfg_part_obj IN inv_ebi_manufacturer_part_obj
116 ,x_out OUT NOCOPY inv_ebi_item_output_obj
117 );
118
119 PROCEDURE get_item_balance(
120 p_item_balance_input IN inv_ebi_item_bal_input_list
121 ,x_item_balance_output OUT NOCOPY inv_ebi_item_bal_output_list
122 ,x_return_status OUT NOCOPY VARCHAR2
123 ,x_msg_count OUT NOCOPY NUMBER
124 ,x_msg_data OUT NOCOPY VARCHAR2
125 );
126
127 PROCEDURE get_item_attributes(
128 p_get_item_inp_obj IN inv_ebi_get_item_input
129 ,x_item_tbl_obj OUT NOCOPY inv_ebi_item_attr_tbl_obj
130 ,x_return_status OUT NOCOPY VARCHAR2
131 ,x_msg_count OUT NOCOPY NUMBER
132 ,x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE validate_get_item_request(
136 p_get_opr_attrs_rec IN inv_ebi_get_operational_attrs
137 ,x_status OUT NOCOPY VARCHAR2
138 ,x_msg_count OUT NOCOPY NUMBER
139 ,x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142 FUNCTION is_engineering_item (
143 p_organization_id IN NUMBER
144 ,p_item_number IN VARCHAR2
145 ) RETURN VARCHAR;
146
147 FUNCTION is_item_exists (
148 p_organization_id IN NUMBER
149 ,p_item_number IN VARCHAR2
150 ) RETURN VARCHAR;
151
152 FUNCTION is_new_item_request_reqd(
153 p_item_catalog_group_id IN NUMBER
154 ) RETURN VARCHAR;
155
156 FUNCTION get_inventory_item_id(
157 p_organization_id IN NUMBER
158 ,p_item_number IN VARCHAR2
159 ) RETURN NUMBER;
160
161 FUNCTION get_item_num(
162 p_segment1 IN VARCHAR2
163 ,p_segment2 IN VARCHAR2
164 ,p_segment3 IN VARCHAR2
165 ,p_segment4 IN VARCHAR2
166 ,p_segment5 IN VARCHAR2
167 ,p_segment6 IN VARCHAR2
168 ,p_segment7 IN VARCHAR2
169 ,p_segment8 IN VARCHAR2
170 ,p_segment9 IN VARCHAR2
171 ,p_segment10 IN VARCHAR2
172 ,p_segment11 IN VARCHAR2
173 ,p_segment12 IN VARCHAR2
174 ,p_segment13 IN VARCHAR2
175 ,p_segment14 IN VARCHAR2
176 ,p_segment15 IN VARCHAR2
177 ,p_segment16 IN VARCHAR2
178 ,p_segment17 IN VARCHAR2
179 ,p_segment18 IN VARCHAR2
180 ,p_segment19 IN VARCHAR2
181 ,p_segment20 IN VARCHAR2
182 ) RETURN VARCHAR2;
183
184 FUNCTION get_organization_id ( p_organization_code IN VARCHAR2 ) RETURN NUMBER;
185
186 PROCEDURE get_item_attributes_list(
187 p_name_value_list IN inv_ebi_name_value_tbl
188 ,p_prog_id IN NUMBER
189 ,p_appl_id IN NUMBER
190 ,p_cross_reference_type IN VARCHAR2
191 ,x_items OUT NOCOPY inv_ebi_get_opr_attrs_tbl
192 ,x_return_status OUT NOCOPY VARCHAR2
193 ,x_msg_count OUT NOCOPY NUMBER
194 ,x_msg_data OUT NOCOPY VARCHAR2
195 );
196
197 FUNCTION get_default_master_org(
198 p_config IN inv_ebi_name_value_tbl
199 ) RETURN NUMBER;
200
201 FUNCTION get_last_run_date(
202 p_conc_prog_id IN NUMBER
203 ,p_appl_id IN NUMBER
204 ) RETURN DATE;
205
206 FUNCTION parse_input_string(
207 p_input_string IN VARCHAR2
208 ) RETURN FND_TABLE_OF_VARCHAR2_255;
209
210 PROCEDURE get_item_balance_list(
211 p_name_value_list IN inv_ebi_name_value_tbl
212 ,p_prog_id IN NUMBER
213 ,p_appl_id IN NUMBER
214 ,p_cross_reference_type IN VARCHAR2
215 ,x_items OUT NOCOPY inv_ebi_get_opr_attrs_tbl
216 ,x_return_status OUT NOCOPY VARCHAR2
217 ,x_msg_count OUT NOCOPY NUMBER
218 ,x_msg_data OUT NOCOPY VARCHAR2
219 );
220
221 PROCEDURE populate_item_ids(
222 p_item IN inv_ebi_item_obj
223 ,x_out OUT NOCOPY inv_ebi_item_output_obj
224 ,x_item OUT NOCOPY inv_ebi_item_obj
225 );
226
227 PROCEDURE get_uda_attributes(
228 p_classification_id IN NUMBER,
229 p_attr_group_type IN VARCHAR2,
230 p_application_id IN NUMBER,
231 p_attr_grp_id_tbl IN FND_TABLE_OF_NUMBER,
232 p_data_level IN VARCHAR2,
233 p_revision_id IN NUMBER,
234 p_object_name IN VARCHAR2,
235 p_pk_data IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
236 x_uda_obj OUT NOCOPY inv_ebi_uda_input_obj,
237 x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj
238 ) ;
239
240
241 PROCEDURE get_Operating_unit
242 (p_oranization_id IN NUMBER
243 ,x_operating_unit OUT NOCOPY VARCHAR2
244 ,x_ouid OUT NOCOPY NUMBER
245 );
246
247 PROCEDURE set_server_time_zone;
248
249 FUNCTION convert_date_str(p_datetime IN DATE)
250 RETURN VARCHAR2;
251
252 PROCEDURE process_update_item_lifecycle(
253 p_commit IN VARCHAR2 := FND_API.g_false
254 ,p_update_item_tbl IN inv_ebi_item_attr_tbl
255 ,x_out OUT NOCOPY inv_ebi_item_output_obj
256 ) ;
257
258 END INV_EBI_ITEM_HELPER;