DBA Data[Home] [Help]

APPS.AMS_MESSAGES_PVT dependencies on AMS_MESSAGES_VL

Line 46: FROM AMS_MESSAGES_VL

42: FROM DUAL;
43:
44: CURSOR c_msg_count(msg_id IN NUMBER) IS
45: SELECT COUNT(*)
46: FROM AMS_MESSAGES_VL
47: WHERE message_id = msg_id;
48:
49: BEGIN
50: -- initialize

Line 1151: 'AMS_MESSAGES_VL',

1147: AND p_msg_rec.message_id IS NOT NULL
1148: THEN
1149: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1150: (
1151: 'AMS_MESSAGES_VL',
1152: 'message_id = ' || p_msg_rec.message_id
1153: );
1154: END IF;
1155:

Line 1282: SELECT * FROM AMS_MESSAGES_VL

1278: )
1279: IS
1280:
1281: CURSOR c_msg IS
1282: SELECT * FROM AMS_MESSAGES_VL
1283: WHERE message_id = p_msg_rec.message_id;
1284:
1285: l_msg_rec c_msg%ROWTYPE;
1286: