DBA Data[Home] [Help]

APPS.AMS_MESSAGES_PKG dependencies on AMS_MESSAGES_B_S

Line 181: update AMS_MESSAGES_B set

177: X_LAST_UPDATED_BY in NUMBER,
178: X_LAST_UPDATE_LOGIN in NUMBER
179: ) is
180: begin
181: update AMS_MESSAGES_B set
182: MESSAGE_TYPE_CODE = X_MESSAGE_TYPE_CODE,
183: OWNER_USER_ID = X_OWNER_USER_ID,
184: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
185: DATE_EFFECTIVE_FROM = X_DATE_EFFECTIVE_FROM,

Line 347: select ams_messages_b_s.nextval

343: from ams_messages_b
344: where message_id = X_MESSAGE_ID;
345:
346: cursor c_msg_id is
347: select ams_messages_b_s.nextval
348: from dual;
349:
350: BEGIN
351: