[Home] [Help]
419: SELECT instance_set_id
420: INTO x_instance_set_id
421: FROM fnd_object_instance_sets
422: WHERE instance_set_id = x_instance_set_id
423: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
424: RETURN TRUE;
425: EXCEPTION
426: WHEN OTHERS THEN
427: -- x_instance_set_id := NULL;
432: SELECT instance_set_id
433: INTO x_instance_set_id
434: FROM fnd_object_instance_sets_vl
435: WHERE display_name = p_set_disp_name
436: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
437: RETURN TRUE;
438: EXCEPTION
439: WHEN OTHERS THEN
440: -- x_instance_set_id := NULL;
675: i NUMBER :=0;
676: BEGIN
677: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
678: l_attr_data_table_index := p_attributes_row_table.FIRST;
679: SELECT OBJECT_ID into l_object_id FROM fnd_objects WHERE obj_name ='EGO_ITEM';
680:
681: LOOP
682: l_current_data_element := p_attributes_row_table(l_attr_data_table_index);
683: l_rev_id := l_current_data_element.DATA_LEVEL_1;
1527: WHERE inventory_item_id = l_Item_rec_in.INVENTORY_ITEM_ID
1528: AND attr_group_id NOT IN
1529: (SELECT ATTR_GROUP_ID
1530: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V AGV,
1531: FND_OBJECTS FO
1532: WHERE AGV.OBJECT_ID = FO.OBJECT_ID
1533: AND AGV.OBJECT_NAME ='EGO_ITEM'
1534: AND AGV.CLASSIFICATION_CODE IS NOT NULL
1535: AND AGV.CLASSIFICATION_CODE IN
1551: WHERE inventory_item_id = l_Item_rec_in.INVENTORY_ITEM_ID
1552: AND attr_group_id NOT IN
1553: (SELECT ATTR_GROUP_ID
1554: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V AGV,
1555: FND_OBJECTS FO
1556: WHERE AGV.OBJECT_ID = FO.OBJECT_ID
1557: AND AGV.OBJECT_NAME ='EGO_ITEM'
1558: AND AGV.CLASSIFICATION_CODE IS NOT NULL
1559: AND AGV.CLASSIFICATION_CODE IN
3334: INTO l_instance_type, l_instance_set_id, l_pk1_value,
3335: l_pk2_value, l_start_date, l_end_date
3336: FROM fnd_grants
3337: WHERE grant_guid = x_grant_guid
3338: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
3339: code_debug(l_api_name||' grant validation check done ' );
3340: EXCEPTION
3341: WHEN NO_DATA_FOUND THEN
3342: code_debug (l_api_version ||' no grant found for modification ');
4134: FROM (SELECT item_catalog_group_id
4135: FROM mtl_item_catalog_groups_b ic
4136: WHERE EXISTS
4137: ( SELECT olc.object_classification_code CatalogId
4138: FROM ego_obj_type_lifecycles olc, fnd_objects o
4139: WHERE o.obj_name = G_EGO_ITEM
4140: AND olc.object_id = o.object_id
4141: AND olc.lifecycle_id = l_curr_lifecycle_id
4142: AND olc.object_classification_code = l_curr_cc_id