APPS.AMS_OBJECTATTRIBUTE_PVT dependencies on AMS_OBJECT_ATTRIBUTES

Line 25: SELECT AMS_OBJECT_ATTRIBUTES_S.NEXTVAL

21: )
22: IS
23:
24: CURSOR c_get_attr_seq IS
25: SELECT AMS_OBJECT_ATTRIBUTES_S.NEXTVAL
26: FROM DUAL;
27:
28: l_attribute_id NUMBER;
29: l_api_name CONSTANT VARCHAR2(30) := 'create_attribute';

Line 39: insert into ams_object_attributes(

35: open c_get_attr_seq;
36: fetch c_get_attr_seq into l_attribute_id;
37: close c_get_attr_seq;
38:
39: insert into ams_object_attributes(
40: object_attribute_id,
41: last_update_date,
42: last_updated_by,
43: creation_date,

Line 296: FROM ams_object_attributes

292: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
293:
294: CURSOR c_get_object_attribute IS
295: SELECT attribute_defined_flag
296: FROM ams_object_attributes
297: WHERE object_type = p_object_type
298: AND object_id = p_object_id
299: AND object_attribute = p_attr;
300:

Line 349: UPDATE ams_object_attributes

345: RAISE FND_API.g_exc_error;
346: else
347: AMS_Utility_PVT.debug_message(l_full_name ||': updating object attribute');
348: close c_get_object_attribute;
349: UPDATE ams_object_attributes
350: SET attribute_defined_flag = p_attr_defined_flag,
351: object_version_number = object_version_number + 1
352: WHERE object_type = p_object_type
353: AND object_id = p_object_id

Line 430: FROM ams_object_attributes

426: SELECT 1
427: FROM DUAL
428: WHERE EXISTS (
429: SELECT 1
430: FROM ams_object_attributes
431: WHERE object_type = p_obj_type
432: AND object_id = p_obj_id
433: AND object_attribute = p_attribute);
434: