[Home] [Help]
PACKAGE: APPS.INV_EBI_ITEM_HELPER
Source
1 PACKAGE INV_EBI_ITEM_HELPER AS
2 /* $Header: INVEIHITS.pls 120.17.12010000.4 2009/02/13 09:41:18 prepatel 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
38 TYPE inv_ebi_name_value_pair_rec IS RECORD(
39 Name VARCHAR2(75)
40 ,Value VARCHAR2(150)
41 );
42
43 TYPE inv_ebi_name_value_pair_tbl IS TABLE OF inv_ebi_name_value_pair_rec;
44
45 FUNCTION id_col_value(
46 p_col_name IN VARCHAR2
47 ,p_pk_col_name_val_pairs IN INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl
48 ) RETURN VARCHAR2;
49
50 FUNCTION value_to_id(
51 p_pk_col_name_val_pairs IN INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl
52 ,p_entity_name IN VARCHAR2
53 ) RETURN NUMBER;
54
55 FUNCTION id_to_value(
56 p_pk_col_name_val_pairs IN INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl
57 ,p_entity_name IN VARCHAR2
58 ) RETURN VARCHAR2;
59
60 PROCEDURE initialize_item(
61 x_item IN OUT NOCOPY inv_ebi_item_obj
62 );
63
64
65 Procedure sync_item (
66 p_commit IN VARCHAR2 := fnd_api.g_false
67 ,p_operation IN VARCHAR2
68 ,p_item IN inv_ebi_item_obj
69 ,x_out OUT NOCOPY inv_ebi_item_output_obj
70 ) ;
71
72 PROCEDURE process_item_pvt(
73 p_commit IN VARCHAR2 := fnd_api.g_false
74 ,p_operation IN VARCHAR2
75 ,p_item IN inv_ebi_item_obj
76 ,x_out OUT NOCOPY inv_ebi_item_output_obj
77 ) ;
78
79 PROCEDURE process_item_uda (
80 p_api_version IN NUMBER DEFAULT 1.0
81 ,p_inventory_item_id IN NUMBER
82 ,p_organization_id IN NUMBER
83 ,p_item_catalog_group_id IN NUMBER DEFAULT NULL
84 ,p_revision_id IN NUMBER DEFAULT NULL
85 ,p_revision_code IN VARCHAR2 DEFAULT NULL
86 ,p_uda_input_obj IN inv_ebi_uda_input_obj
87 ,p_commit IN VARCHAR2 := fnd_api.g_false
88 ,x_uda_output_obj OUT NOCOPY inv_ebi_item_output_obj
89 );
90
91 PROCEDURE process_org_id_assignments(
92 p_init_msg_list IN VARCHAR2
93 ,p_commit IN VARCHAR2 := fnd_api.g_false
94 ,p_inventory_item_id IN NUMBER
95 ,p_item_number IN VARCHAR2
96 ,p_org_id_tbl IN inv_ebi_org_tbl
97 ,x_out OUT NOCOPY inv_ebi_item_output_obj
98 );
99
100 PROCEDURE process_category_assignments(
101 p_api_version IN NUMBER DEFAULT 1.0
102 ,p_init_msg_list IN VARCHAR2
103 ,p_commit IN VARCHAR2 := fnd_api.g_false
104 ,p_inventory_item_id IN NUMBER
105 ,p_organization_id IN NUMBER
106 ,p_category_id_tbl IN inv_ebi_category_obj_tbl_type
107 ,x_out OUT NOCOPY inv_ebi_item_output_obj
108 );
109
110 PROCEDURE process_part_num_association(
111 p_commit IN VARCHAR2 := fnd_api.g_false
112 ,p_organization_id IN NUMBER
113 ,p_inventory_item_id IN NUMBER
114 ,p_mfg_part_obj IN inv_ebi_manufacturer_part_obj
115 ,x_out OUT NOCOPY inv_ebi_item_output_obj
116 );
117
118 PROCEDURE get_item_balance(
119 p_item_balance_input IN inv_ebi_item_bal_input_list
120 ,x_item_balance_output OUT NOCOPY inv_ebi_item_bal_output_list
121 ,x_return_status OUT NOCOPY VARCHAR2
122 ,x_msg_count OUT NOCOPY NUMBER
123 ,x_msg_data OUT NOCOPY VARCHAR2
124 );
125
126 PROCEDURE get_item_attributes(
127 p_get_item_inp_obj IN inv_ebi_get_item_input
128 ,x_item_tbl_obj OUT NOCOPY inv_ebi_item_attr_tbl_obj
129 ,x_return_status OUT NOCOPY VARCHAR2
130 ,x_msg_count OUT NOCOPY NUMBER
131 ,x_msg_data OUT NOCOPY VARCHAR2
132 );
133
134 PROCEDURE validate_get_item_request(
135 p_get_opr_attrs_rec IN inv_ebi_get_operational_attrs
136 ,x_status OUT NOCOPY VARCHAR2
137 ,x_msg_count OUT NOCOPY NUMBER
138 ,x_msg_data OUT NOCOPY VARCHAR2
139 );
140
141 FUNCTION is_engineering_item (
142 p_organization_id IN NUMBER
143 ,p_item_number IN VARCHAR2
144 ) RETURN VARCHAR;
145
146 FUNCTION is_item_exists (
147 p_organization_id IN NUMBER
148 ,p_item_number IN VARCHAR2
149 ) RETURN VARCHAR;
150
151 FUNCTION is_new_item_request_reqd(
152 p_item_catalog_group_id IN NUMBER
153 ) RETURN VARCHAR;
154
155 FUNCTION get_inventory_item_id(
156 p_organization_id IN NUMBER
157 ,p_item_number IN VARCHAR2
158 ) RETURN NUMBER;
159
160 FUNCTION get_item_num(
161 p_segment1 IN VARCHAR2
162 ,p_segment2 IN VARCHAR2
163 ,p_segment3 IN VARCHAR2
164 ,p_segment4 IN VARCHAR2
165 ,p_segment5 IN VARCHAR2
166 ,p_segment6 IN VARCHAR2
167 ,p_segment7 IN VARCHAR2
168 ,p_segment8 IN VARCHAR2
169 ,p_segment9 IN VARCHAR2
170 ,p_segment10 IN VARCHAR2
171 ,p_segment11 IN VARCHAR2
172 ,p_segment12 IN VARCHAR2
173 ,p_segment13 IN VARCHAR2
174 ,p_segment14 IN VARCHAR2
175 ,p_segment15 IN VARCHAR2
176 ,p_segment16 IN VARCHAR2
177 ,p_segment17 IN VARCHAR2
178 ,p_segment18 IN VARCHAR2
179 ,p_segment19 IN VARCHAR2
180 ,p_segment20 IN VARCHAR2
181 ) RETURN VARCHAR2;
182
183 FUNCTION get_organization_id ( p_organization_code IN VARCHAR2 ) RETURN NUMBER;
184
185 PROCEDURE get_item_attributes_list(
186 p_name_value_list IN inv_ebi_name_value_tbl
187 ,p_prog_id IN NUMBER
188 ,p_appl_id IN NUMBER
189 ,p_cross_reference_type IN VARCHAR2
190 ,x_items OUT NOCOPY inv_ebi_get_opr_attrs_tbl
191 ,x_return_status OUT NOCOPY VARCHAR2
192 ,x_msg_count OUT NOCOPY NUMBER
193 ,x_msg_data OUT NOCOPY VARCHAR2
194 );
195
196 FUNCTION get_default_master_org(
197 p_config IN inv_ebi_name_value_tbl
198 ) RETURN NUMBER;
199
200 FUNCTION get_last_run_date(
201 p_conc_prog_id IN NUMBER
202 ,p_appl_id IN NUMBER
203 ) RETURN DATE;
204
205 FUNCTION parse_input_string(
206 p_input_string IN VARCHAR2
207 ) RETURN FND_TABLE_OF_VARCHAR2_255;
208
209 PROCEDURE get_item_balance_list(
210 p_name_value_list IN inv_ebi_name_value_tbl
211 ,p_prog_id IN NUMBER
212 ,p_appl_id IN NUMBER
213 ,p_cross_reference_type IN VARCHAR2
214 ,x_items OUT NOCOPY inv_ebi_get_opr_attrs_tbl
215 ,x_return_status OUT NOCOPY VARCHAR2
216 ,x_msg_count OUT NOCOPY NUMBER
217 ,x_msg_data OUT NOCOPY VARCHAR2
218 );
219
220 PROCEDURE populate_item_ids(
221 p_item IN inv_ebi_item_obj
222 ,x_out OUT NOCOPY inv_ebi_item_output_obj
223 ,x_item OUT NOCOPY inv_ebi_item_obj
224 );
225
226 PROCEDURE get_uda_attributes(
227 p_classification_id IN NUMBER,
228 p_attr_group_type IN VARCHAR2,
229 p_application_id IN NUMBER,
230 p_attr_grp_id_tbl IN FND_TABLE_OF_NUMBER,
231 p_data_level IN VARCHAR2,
232 p_revision_id IN NUMBER,
233 p_object_name IN VARCHAR2,
234 p_pk_data IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
235 x_uda_obj OUT NOCOPY inv_ebi_uda_input_obj,
236 x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj
237 ) ;
238
239
240 PROCEDURE get_Operating_unit
241 (p_oranization_id IN NUMBER
242 ,x_operating_unit OUT NOCOPY VARCHAR2
243 ,x_ouid OUT NOCOPY NUMBER
244 );
245
246 PROCEDURE set_server_time_zone;
247
248 FUNCTION convert_date_str(p_datetime IN DATE)
249 RETURN VARCHAR2;
250
251 END INV_EBI_ITEM_HELPER;