DBA Data[Home] [Help]

APPS.AMS_MESSAGES_PVT dependencies on AMS_MESSAGES_B_S

Line 41: SELECT AMS_MESSAGES_B_S.NEXTVAL

37: l_msg_rec msg_rec_type := p_msg_rec;
38: l_msg_count NUMBER;
39:
40: CURSOR c_msg_seq IS
41: SELECT AMS_MESSAGES_B_S.NEXTVAL
42: FROM DUAL;
43:
44: CURSOR c_msg_count(msg_id IN NUMBER) IS
45: SELECT COUNT(*)

Line 418: UPDATE AMS_MESSAGES_B SET

414:
415: AMS_Utility_PVT.debug_message(l_full_name||': update');
416: END IF;
417:
418: UPDATE AMS_MESSAGES_B SET
419: last_update_date = SYSDATE,
420: last_updated_by = FND_GLOBAL.user_id,
421: last_update_login = FND_GLOBAL.conc_login_id,
422: object_version_number = l_msg_rec.object_version_number + 1,