APPS.EGO_DATA_SECURITY dependencies on FND_OBJECTS

Line 367: from fnd_objects

363: l_object_id number;
364: Begin
365: select object_id
366: into l_object_id
367: from fnd_objects
368: where obj_name=p_object_name;
369: return l_object_id;
370: exception
371: when no_data_found then

Line 437: FROM fnd_objects

433: ,pk3_column_type
434: ,pk4_column_type
435: ,pk5_column_type
436: , database_object_name
437: FROM fnd_objects
438: WHERE obj_name=p_object_name ;
439: begin
440: open c_pk;
441: fetch c_pk into

Line 459: 'FND_OBJECTS does not have column obj_name with value:'||

455: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
456: fnd_message.set_token('ROUTINE',
457: g_pkg_name || '.'|| l_api_name);
458: fnd_message.set_token('REASON',
459: 'FND_OBJECTS does not have column obj_name with value:'||
460: p_object_name);
461: return G_RETURN_UNEXP_ERR;
462: end if;
463:

Line 6087: from fnd_objects o, fnd_object_instance_sets s

6083: l_pk2_col_type,
6084: l_pk3_col_type,
6085: l_pk4_col_type,
6086: l_pk5_col_type
6087: from fnd_objects o, fnd_object_instance_sets s
6088: where s.instance_set_name = p_instance_set_name
6089: and s.object_id = o.object_id;
6090: exception
6091: when no_data_found then

Line 6096: 'fnd_objects and fnd_object_instance_sets for instance set '||

6092: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6093: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6094: fnd_message.set_token('REASON',
6095: 'Data Error- couldn''t get predicate and/or object_name from '||
6096: 'fnd_objects and fnd_object_instance_sets for instance set '||
6097: '"'||p_instance_set_name||'"');
6098: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
6099: ,p_module => l_api_name
6100: ,p_message => 'The given data is not sufficient to find a valid instance set '

Line 6247: l_parent_obj_id fnd_objects.object_id%type;

6243:
6244: l_api_version CONSTANT NUMBER := 1.0;
6245:
6246: -- General variables
6247: l_parent_obj_id fnd_objects.object_id%type;
6248: l_parent_role_id fnd_menus.menu_id%type;
6249: l_child_obj_id fnd_objects.object_id%type;
6250: l_child_role_id fnd_menus.menu_id%type;
6251:

Line 6249: l_child_obj_id fnd_objects.object_id%type;

6245:
6246: -- General variables
6247: l_parent_obj_id fnd_objects.object_id%type;
6248: l_parent_role_id fnd_menus.menu_id%type;
6249: l_child_obj_id fnd_objects.object_id%type;
6250: l_child_role_id fnd_menus.menu_id%type;
6251:
6252: l_Sysdate DATE := Sysdate;
6253: l_owner NUMBER;

Line 6512: l_parent_obj_id fnd_objects.object_id%type;

6508: l_curr_login_id NUMBER;
6509:
6510: -- General variables
6511:
6512: l_parent_obj_id fnd_objects.object_id%type;
6513: l_parent_role_id fnd_menus.menu_id%type;
6514: l_child_obj_id fnd_objects.object_id%type;
6515: l_child_role_id fnd_menus.menu_id%type;
6516: l_Sysdate DATE := Sysdate;

Line 6514: l_child_obj_id fnd_objects.object_id%type;

6510: -- General variables
6511:
6512: l_parent_obj_id fnd_objects.object_id%type;
6513: l_parent_role_id fnd_menus.menu_id%type;
6514: l_child_obj_id fnd_objects.object_id%type;
6515: l_child_role_id fnd_menus.menu_id%type;
6516: l_Sysdate DATE := Sysdate;
6517: l_owner NUMBER;
6518:

Line 6789: l_parent_obj_id fnd_objects.object_id%type;

6785: l_row_count NUMBER;
6786:
6787: -- General variables
6788:
6789: l_parent_obj_id fnd_objects.object_id%type;
6790: l_parent_role_id fnd_menus.menu_id%type;
6791: l_child_obj_id fnd_objects.object_id%type;
6792:
6793: l_Sysdate DATE := Sysdate;

Line 6791: l_child_obj_id fnd_objects.object_id%type;

6787: -- General variables
6788:
6789: l_parent_obj_id fnd_objects.object_id%type;
6790: l_parent_role_id fnd_menus.menu_id%type;
6791: l_child_obj_id fnd_objects.object_id%type;
6792:
6793: l_Sysdate DATE := Sysdate;
6794:
6795: BEGIN