APPS.EGO_DEMO_PUB dependencies on EGO_DEMO_ITEM_NUMBER_S

Line 85: SELECT EGO_DEMO_ITEM_NUMBER_S.NEXTVAL

81: l_item_squence VARCHAR2(30) := '';
82:
83: BEGIN
84:
85: SELECT EGO_DEMO_ITEM_NUMBER_S.NEXTVAL
86: INTO l_item_squence
87: FROM DUAL;
88:
89: l_item_number := p_Section_Code || l_item_squence || ' ' || p_Model_Code || p_Prototype_Code || ' ' || '0000';

Line 274: SELECT EGO_DEMO_ITEM_NUMBER_S.NEXTVAL

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
276: FROM DUAL;
277:
278: IF p_col_name_value_array IS NOT NULL THEN