APPS.EGO_DATA_SECURITY dependencies on FND_OBJECTS

Line 378: from fnd_objects

374: l_object_id number;
375: Begin
376: select object_id
377: into l_object_id
378: from fnd_objects
379: where obj_name=p_object_name;
380: return l_object_id;
381: exception
382: when no_data_found then

Line 448: FROM fnd_objects

444: ,pk3_column_type
445: ,pk4_column_type
446: ,pk5_column_type
447: , database_object_name
448: FROM fnd_objects
449: WHERE obj_name=p_object_name ;
450: begin
451: open c_pk;
452: fetch c_pk into

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

466: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
467: fnd_message.set_token('ROUTINE',
468: g_pkg_name || '.'|| l_api_name);
469: fnd_message.set_token('REASON',
470: 'FND_OBJECTS does not have column obj_name with value:'||
471: p_object_name);
472: return G_RETURN_UNEXP_ERR;
473: end if;
474:

Line 6189: from fnd_objects o, fnd_object_instance_sets s

6185: l_pk2_col_type,
6186: l_pk3_col_type,
6187: l_pk4_col_type,
6188: l_pk5_col_type
6189: from fnd_objects o, fnd_object_instance_sets s
6190: where s.instance_set_name = p_instance_set_name
6191: and s.object_id = o.object_id;
6192: exception
6193: when no_data_found then

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

6194: fnd_message.set_name('FND', 'GENERIC-INTERNAL ERROR');
6195: fnd_message.set_token('ROUTINE', g_pkg_name || '.'|| l_api_name);
6196: fnd_message.set_token('REASON',
6197: 'Data Error- couldn''t get predicate and/or object_name from '||
6198: 'fnd_objects and fnd_object_instance_sets for instance set '||
6199: '"'||p_instance_set_name||'"');
6200: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
6201: ,p_module => l_api_name
6202: ,p_message => 'The given data is not sufficient to find a valid instance set '

Line 6349: l_parent_obj_id fnd_objects.object_id%type;

6345:
6346: l_api_version CONSTANT NUMBER := 1.0;
6347:
6348: -- General variables
6349: l_parent_obj_id fnd_objects.object_id%type;
6350: l_parent_role_id fnd_menus.menu_id%type;
6351: l_child_obj_id fnd_objects.object_id%type;
6352: l_child_role_id fnd_menus.menu_id%type;
6353:

Line 6351: l_child_obj_id fnd_objects.object_id%type;

6347:
6348: -- General variables
6349: l_parent_obj_id fnd_objects.object_id%type;
6350: l_parent_role_id fnd_menus.menu_id%type;
6351: l_child_obj_id fnd_objects.object_id%type;
6352: l_child_role_id fnd_menus.menu_id%type;
6353:
6354: l_Sysdate DATE := Sysdate;
6355: l_owner NUMBER;

Line 6614: l_parent_obj_id fnd_objects.object_id%type;

6610: l_curr_login_id NUMBER;
6611:
6612: -- General variables
6613:
6614: l_parent_obj_id fnd_objects.object_id%type;
6615: l_parent_role_id fnd_menus.menu_id%type;
6616: l_child_obj_id fnd_objects.object_id%type;
6617: l_child_role_id fnd_menus.menu_id%type;
6618: l_Sysdate DATE := Sysdate;

Line 6616: l_child_obj_id fnd_objects.object_id%type;

6612: -- General variables
6613:
6614: l_parent_obj_id fnd_objects.object_id%type;
6615: l_parent_role_id fnd_menus.menu_id%type;
6616: l_child_obj_id fnd_objects.object_id%type;
6617: l_child_role_id fnd_menus.menu_id%type;
6618: l_Sysdate DATE := Sysdate;
6619: l_owner NUMBER;
6620:

Line 6891: l_parent_obj_id fnd_objects.object_id%type;

6887: l_row_count NUMBER;
6888:
6889: -- General variables
6890:
6891: l_parent_obj_id fnd_objects.object_id%type;
6892: l_parent_role_id fnd_menus.menu_id%type;
6893: l_child_obj_id fnd_objects.object_id%type;
6894:
6895: l_Sysdate DATE := Sysdate;

Line 6893: l_child_obj_id fnd_objects.object_id%type;

6889: -- General variables
6890:
6891: l_parent_obj_id fnd_objects.object_id%type;
6892: l_parent_role_id fnd_menus.menu_id%type;
6893: l_child_obj_id fnd_objects.object_id%type;
6894:
6895: l_Sysdate DATE := Sysdate;
6896:
6897: BEGIN