134: )
135: values
136: (x_act_msg_id,
137: SYSDATE,
138: FND_GLOBAL.user_id,
139: SYSDATE,
140: FND_GLOBAL.user_id,
141: FND_GLOBAL.conc_login_id,
142: 1, -- object_version_number
136: (x_act_msg_id,
137: SYSDATE,
138: FND_GLOBAL.user_id,
139: SYSDATE,
140: FND_GLOBAL.user_id,
141: FND_GLOBAL.conc_login_id,
142: 1, -- object_version_number
143: p_message_id,
144: p_message_used_by ,
137: SYSDATE,
138: FND_GLOBAL.user_id,
139: SYSDATE,
140: FND_GLOBAL.user_id,
141: FND_GLOBAL.conc_login_id,
142: 1, -- object_version_number
143: p_message_id,
144: p_message_used_by ,
145: p_msg_used_by_id
322: END IF;
323:
324: UPDATE ams_act_messages SET
325: last_update_date = SYSDATE,
326: last_updated_by = FND_GLOBAL.user_id,
327: last_update_login = FND_GLOBAL.conc_login_id,
328: object_version_number = p_object_version + 1,
329: message_id = p_message_id,
330: message_used_by = p_msg_used_by,
323:
324: UPDATE ams_act_messages SET
325: last_update_date = SYSDATE,
326: last_updated_by = FND_GLOBAL.user_id,
327: last_update_login = FND_GLOBAL.conc_login_id,
328: object_version_number = p_object_version + 1,
329: message_id = p_message_id,
330: message_used_by = p_msg_used_by,
331: message_used_by_id = p_msg_used_by_id