APPS.AMS_MESSAGES_PVT dependencies on AMS_MESSAGES_B

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 139: INSERT INTO AMS_MESSAGES_B

135: p_setup_id => 1000
136: );
137: */
138:
139: INSERT INTO AMS_MESSAGES_B
140: (
141: message_id,
142: last_update_date,
143: last_updated_by,

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,

Line 602: DELETE FROM AMS_MESSAGES_B

598: END IF;
599: RAISE FND_API.g_exc_error;
600: END IF;
601:
602: DELETE FROM AMS_MESSAGES_B
603: WHERE message_id = p_msg_id
604: AND object_version_number = p_object_version;
605:
606: IF (SQL%NOTFOUND) THEN

Line 699: FROM AMS_MESSAGES_B

695: l_msg_id NUMBER;
696:
697: CURSOR c_msg_b IS
698: SELECT message_id
699: FROM AMS_MESSAGES_B
700: WHERE message_id = p_msg_id
701: AND object_version_number = p_object_version
702: FOR UPDATE OF message_id NOWAIT;
703: