APPS.AMS_USER_STATUSES_PKG dependencies on AMS_USER_STATUSES_B_S

Line 241: update AMS_USER_STATUSES_B set

237: END IF;
238: END IF;
239: /*08-May-2006 mayjain fix for bug 5166318*/
240:
241: update AMS_USER_STATUSES_B set
242: DEFAULT_FLAG = l_default_flag, /*08-May-2006 mayjain fix for bug 5166318*/
243: SEEDED_FLAG = X_SEEDED_FLAG,
244: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
245: SYSTEM_STATUS_TYPE = X_SYSTEM_STATUS_TYPE,

Line 434: select AMS_USER_STATUSES_B_S.nextval

430: from AMS_USER_STATUSES_B
431: where user_status_id = X_USER_STATUS_ID;
432:
433: cursor c_get_ust_id is
434: select AMS_USER_STATUSES_B_S.nextval
435: from dual;
436:
437: cursor c_db_data_details is
438: select last_updated_by, nvl(object_version_number,1)