APPS.EGO_ITEM_PVT dependencies on FND_OBJECTS

Line 427: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);

423: SELECT instance_set_id
424: INTO x_instance_set_id
425: FROM fnd_object_instance_sets
426: WHERE instance_set_id = x_instance_set_id
427: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
428: RETURN TRUE;
429: EXCEPTION
430: WHEN OTHERS THEN
431: -- x_instance_set_id := NULL;

Line 440: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);

436: SELECT instance_set_id
437: INTO x_instance_set_id
438: FROM fnd_object_instance_sets_vl
439: WHERE display_name = p_set_disp_name
440: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
441: RETURN TRUE;
442: EXCEPTION
443: WHEN OTHERS THEN
444: -- x_instance_set_id := NULL;

Line 683: SELECT OBJECT_ID into l_object_id FROM fnd_objects WHERE obj_name ='EGO_ITEM';

679: i NUMBER :=0;
680: BEGIN
681: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
682: l_attr_data_table_index := p_attributes_row_table.FIRST;
683: SELECT OBJECT_ID into l_object_id FROM fnd_objects WHERE obj_name ='EGO_ITEM';
684:
685: LOOP
686: l_current_data_element := p_attributes_row_table(l_attr_data_table_index);
687: l_rev_id := l_current_data_element.DATA_LEVEL_1;

Line 868: FND_OBJECTS FO

864: WHERE inventory_item_id = p_inventory_item_id
865: AND attr_group_id NOT IN
866: (SELECT ATTR_GROUP_ID
867: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V AGV,
868: FND_OBJECTS FO
869: WHERE AGV.OBJECT_ID = FO.OBJECT_ID
870: AND AGV.OBJECT_NAME ='EGO_ITEM'
871: AND AGV.CLASSIFICATION_CODE IS NOT NULL
872: AND AGV.CLASSIFICATION_CODE IN

Line 894: FND_OBJECTS FO

890: WHERE inventory_item_id = p_inventory_item_id
891: AND attr_group_id NOT IN
892: (SELECT ATTR_GROUP_ID
893: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V AGV,
894: FND_OBJECTS FO
895: WHERE AGV.OBJECT_ID = FO.OBJECT_ID
896: AND AGV.OBJECT_NAME ='EGO_ITEM'
897: AND AGV.CLASSIFICATION_CODE IS NOT NULL
898: AND AGV.CLASSIFICATION_CODE IN

Line 3598: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);

3594: INTO l_instance_type, l_instance_set_id, l_pk1_value,
3595: l_pk2_value, l_start_date, l_end_date
3596: FROM fnd_grants
3597: WHERE grant_guid = x_grant_guid
3598: AND object_id = (SELECT object_id FROM fnd_objects WHERE obj_name = G_EGO_ITEM);
3599: code_debug(l_api_name||' grant validation check done ' );
3600: EXCEPTION
3601: WHEN NO_DATA_FOUND THEN
3602: code_debug (l_api_version ||' no grant found for modification ');

Line 4599: FROM ego_obj_type_lifecycles olc, fnd_objects o

4595: FROM (SELECT item_catalog_group_id
4596: FROM mtl_item_catalog_groups_b ic
4597: WHERE EXISTS
4598: ( SELECT olc.object_classification_code CatalogId
4599: FROM ego_obj_type_lifecycles olc, fnd_objects o
4600: WHERE o.obj_name = G_EGO_ITEM
4601: AND olc.object_id = o.object_id
4602: AND olc.lifecycle_id = l_curr_lifecycle_id
4603: AND olc.object_classification_code = l_curr_cc_id