DBA Data[Home] [Help]

APPS.EGO_DEMO_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 271: l_ego_col_name_value_pair_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

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

Line 281: l_ego_col_name_value_pair_obj := p_col_name_value_array(l_row_table_index);

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;

Line 282: IF l_ego_col_name_value_pair_obj.NAME = 'STYLE_ITEM_ID' THEN

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

Line 283: l_style_item_id := l_ego_col_name_value_pair_obj.VALUE;

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;

Line 284: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_TYPE' THEN

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;

Line 285: l_item_type := l_ego_col_name_value_pair_obj.VALUE;

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;

Line 286: ELSIF l_ego_col_name_value_pair_obj.NAME = 'ITEM_CATALOG_GROUP_ID' THEN

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;

Line 287: l_icc_id := l_ego_col_name_value_pair_obj.VALUE;

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: