DBA Data[Home] [Help]

APPS.FND_GRANTS_PKG dependencies on FND_OBJECTS

Line 735: from fnd_objects

731: else
732: begin
733: select object_id
734: into obj_id
735: from fnd_objects
736: where obj_name = X_OBJ_NAME;
737: exception
738: when no_data_found then
739: obj_id := NULL;

Line 746: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_OBJECTS');

742: if (obj_id is NULL) then
743: FND_MESSAGE.SET_NAME('FND', 'SQL_NO_DATA_FOUND');
744: FND_MESSAGE.SET_TOKEN('VALUE', X_OBJ_NAME);
745: FND_MESSAGE.SET_TOKEN('COLUMN', 'OBJ_NAME');
746: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_OBJECTS');
747: app_exception.raise_exception;
748: end if;
749: else
750: obj_id := NULL;

Line 1092: from fnd_objects

1088:
1089:
1090: CURSOR get_object_id (p_object_name varchar2) is
1091: select object_id
1092: from fnd_objects
1093: where obj_name=p_object_name;
1094: BEGIN
1095: x_grant_guid := NULL;
1096: x_success := FND_API.G_FALSE ;

Line 1147: --- Get object_id from the fnd_objects

1143: END IF;
1144: CLOSE get_menu_id;
1145:
1146: ---Step 3.
1147: --- Get object_id from the fnd_objects
1148: if (p_object_name = 'GLOBAL') then
1149: l_object_id := -1;
1150: else
1151: open get_object_id(p_object_name);

Line 1539: FROM fnd_objects

1535: WHERE menu_name = p_menu_name;
1536:
1537: CURSOR get_object_id(p_object_name VARCHAR2) IS
1538: SELECT object_id
1539: FROM fnd_objects
1540: WHERE obj_name = p_object_name;
1541:
1542: BEGIN
1543: