APPS.AMS_ACT_MESSAGES_PVT dependencies on AMS_ACT_MESSAGES

Line 1: PACKAGE BODY AMS_Act_Messages_PVT AS

1: PACKAGE BODY AMS_Act_Messages_PVT AS
2: /* $Header: amsvacmb.pls 115.10 2002/11/15 21:01:42 abhola ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_Act_Messages_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_Act_Messages_PVT';

1: PACKAGE BODY AMS_Act_Messages_PVT AS
2: /* $Header: amsvacmb.pls 115.10 2002/11/15 21:01:42 abhola ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_Act_Messages_PVT';
5:
6: -- forward declaration of validate messages
7: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 56: SELECT ams_act_messages_s.NEXTVAL

52: l_return_status VARCHAR2(1);
53: l_actm_count NUMBER;
54:
55: CURSOR c_actm_seq IS
56: SELECT ams_act_messages_s.NEXTVAL
57: FROM DUAL;
58:
59: BEGIN
60:

Line 123: insert into ams_act_messages

119: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
120: RAISE FND_API.g_exc_error;
121: END IF;
122:
123: insert into ams_act_messages
124: (act_message_id,
125: last_update_date,
126: last_updated_by,
127: creation_date,

Line 324: UPDATE ams_act_messages SET

320: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
321: RAISE FND_API.g_exc_unexpected_error;
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,

Line 424: FROM ams_act_messages

420: l_dummy NUMBER;
421:
422: CURSOR c_used_by IS
423: SELECT message_used_by_id, message_used_by
424: FROM ams_act_messages
425: WHERE act_message_id = p_act_msg_id;
426:
427: CURSOR c_msg IS
428: SELECT 1

Line 429: FROM ams_act_messages

425: WHERE act_message_id = p_act_msg_id;
426:
427: CURSOR c_msg IS
428: SELECT 1
429: FROM ams_act_messages
430: WHERE message_used_by_id = l_used_by_id
431: AND message_used_by = l_used_by;
432:
433: BEGIN

Line 474: DELETE FROM ams_act_messages

470:
471: -- validate act messages
472: -- check for available object attributes
473:
474: DELETE FROM ams_act_messages
475: WHERE ACT_MESSAGE_ID = p_act_msg_id
476: AND OBJECT_VERSION_NUMBER = p_object_version;
477: /* commented by musman on 03/29/01
478: -- added by julou on 03/07/2000

Line 597: FROM ams_act_messages

593: l_act_msg_id NUMBER;
594:
595: CURSOR c_actm_lck IS
596: SELECT act_message_id
597: FROM ams_act_messages
598: WHERE act_message_id = p_act_msg_id
599: AND object_version_number = p_object_version
600: FOR UPDATE NOWAIT;
601:

Line 745: from ams_act_messages

741: and lookup_code = p_msg_used_by;
742:
743: cursor c_chk_actmsg is
744: select 'x'
745: from ams_act_messages
746: where message_used_by = p_msg_used_by
747: and message_used_by_id = p_msg_used_by_id
748: and message_id = p_message_id;
749:

Line 870: END AMS_ACT_MESSAGES_PVT;

866: END IF;
867:
868: END validate_act_messages;
869:
870: END AMS_ACT_MESSAGES_PVT;