267: l_item_squence VARCHAR2(300);
268: l_style_item_id NUMBER;
269: l_icc_id NUMBER;
270: l_item_type VARCHAR2(1000);
271: l_ego_col_name_value_pair_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
272: l_style_item_num MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
273: BEGIN
274: SELECT EGO_DEMO_ITEM_NUMBER_S.NEXTVAL
275: INTO l_item_squence
277:
278: IF p_col_name_value_array IS NOT NULL THEN
279: FOR l_row_table_index IN p_col_name_value_array.first .. p_col_name_value_array.last
280: LOOP
281: l_ego_col_name_value_pair_obj := p_col_name_value_array(l_row_table_index);
282: IF l_ego_col_name_value_pair_obj.NAME = 'STYLE_ITEM_ID' THEN
283: l_style_item_id := l_ego_col_name_value_pair_obj.VALUE;
284: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_TYPE' THEN
285: l_item_type := l_ego_col_name_value_pair_obj.VALUE;
278: IF p_col_name_value_array IS NOT NULL THEN
279: FOR l_row_table_index IN p_col_name_value_array.first .. p_col_name_value_array.last
280: LOOP
281: l_ego_col_name_value_pair_obj := p_col_name_value_array(l_row_table_index);
282: IF l_ego_col_name_value_pair_obj.NAME = 'STYLE_ITEM_ID' THEN
283: l_style_item_id := l_ego_col_name_value_pair_obj.VALUE;
284: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_TYPE' THEN
285: l_item_type := l_ego_col_name_value_pair_obj.VALUE;
286: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_CATALOG_GROUP_ID' THEN
279: FOR l_row_table_index IN p_col_name_value_array.first .. p_col_name_value_array.last
280: LOOP
281: l_ego_col_name_value_pair_obj := p_col_name_value_array(l_row_table_index);
282: IF l_ego_col_name_value_pair_obj.NAME = 'STYLE_ITEM_ID' THEN
283: l_style_item_id := l_ego_col_name_value_pair_obj.VALUE;
284: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_TYPE' THEN
285: l_item_type := l_ego_col_name_value_pair_obj.VALUE;
286: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_CATALOG_GROUP_ID' THEN
287: l_icc_id := l_ego_col_name_value_pair_obj.VALUE;
280: LOOP
281: l_ego_col_name_value_pair_obj := p_col_name_value_array(l_row_table_index);
282: IF l_ego_col_name_value_pair_obj.NAME = 'STYLE_ITEM_ID' THEN
283: l_style_item_id := l_ego_col_name_value_pair_obj.VALUE;
284: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_TYPE' THEN
285: l_item_type := l_ego_col_name_value_pair_obj.VALUE;
286: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_CATALOG_GROUP_ID' THEN
287: l_icc_id := l_ego_col_name_value_pair_obj.VALUE;
288: END IF;
281: l_ego_col_name_value_pair_obj := p_col_name_value_array(l_row_table_index);
282: IF l_ego_col_name_value_pair_obj.NAME = 'STYLE_ITEM_ID' THEN
283: l_style_item_id := l_ego_col_name_value_pair_obj.VALUE;
284: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_TYPE' THEN
285: l_item_type := l_ego_col_name_value_pair_obj.VALUE;
286: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_CATALOG_GROUP_ID' THEN
287: l_icc_id := l_ego_col_name_value_pair_obj.VALUE;
288: END IF;
289: END LOOP;
282: IF l_ego_col_name_value_pair_obj.NAME = 'STYLE_ITEM_ID' THEN
283: l_style_item_id := l_ego_col_name_value_pair_obj.VALUE;
284: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_TYPE' THEN
285: l_item_type := l_ego_col_name_value_pair_obj.VALUE;
286: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_CATALOG_GROUP_ID' THEN
287: l_icc_id := l_ego_col_name_value_pair_obj.VALUE;
288: END IF;
289: END LOOP;
290: END IF;
283: l_style_item_id := l_ego_col_name_value_pair_obj.VALUE;
284: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_TYPE' THEN
285: l_item_type := l_ego_col_name_value_pair_obj.VALUE;
286: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_CATALOG_GROUP_ID' THEN
287: l_icc_id := l_ego_col_name_value_pair_obj.VALUE;
288: END IF;
289: END LOOP;
290: END IF;
291: