DBA Data[Home] [Help]

APPS.AMS_ACT_LIST_PVT dependencies on AMS_USER_STATUSES_VL

Line 5161: USER_STATUS_ID = (select user_status_id from ams_user_statuses_vl where system_status_type ='AMS_LIST_STATUS' and system_status_code ='LOCKED' and default_flag ='Y' ),

5157: END IF;
5158:
5159: UPDATE AMS_LIST_HEADERS_ALL
5160: SET STATUS_CODE = 'LOCKED',
5161: USER_STATUS_ID = (select user_status_id from ams_user_statuses_vl where system_status_type ='AMS_LIST_STATUS' and system_status_code ='LOCKED' and default_flag ='Y' ),
5162: STATUS_DATE = SYSDATE,
5163: LAST_UPDATE_DATE = SYSDATE
5164: WHERE LIST_USED_BY_ID = P_OBJ_ID
5165: AND ARC_LIST_USED_BY = P_OBJECT_TYPE