DBA Data[Home] [Help]

APPS.AMS_WFCMPAPR_PVT dependencies on AMS_OBJECT_ATTRIBUTES

Line 1398: -- UPDATE ams_object_attributes

1394:
1395: BEGIN
1396: -- This Process Has to be modified once the API for Update Attribute
1397: -- is available
1398: -- UPDATE ams_object_attributes
1399: -- SET attribute_defined_flag = 'Y'
1400: -- WHERE object_type = p_obj_type
1401: -- AND object_id = p_obj_id
1402: -- AND object_attribute = p_obj_attr ;

Line 1548: FROM ams_object_attributes

1544: CURSOR c_attr_det
1545: IS
1546: SELECT attribute_defined_flag,
1547: object_attribute
1548: FROM ams_object_attributes
1549: WHERE object_type = p_obj_type
1550: AND object_id = p_obj_id
1551: AND (object_attribute = 'TAPL' OR
1552: object_attribute = 'BAPL')