APPS.AMS_MESSAGES_PKG dependencies on AMS_MESSAGES_B

Line 20: cursor C is select ROWID from AMS_MESSAGES_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from AMS_MESSAGES_B
21: where MESSAGE_ID = X_MESSAGE_ID
22: ;
23: begin
24: insert into AMS_MESSAGES_B (

Line 24: insert into AMS_MESSAGES_B (

20: cursor C is select ROWID from AMS_MESSAGES_B
21: where MESSAGE_ID = X_MESSAGE_ID
22: ;
23: begin
24: insert into AMS_MESSAGES_B (
25: MESSAGE_TYPE_CODE,
26: OWNER_USER_ID,
27: MESSAGE_ID,
28: OBJECT_VERSION_NUMBER,

Line 110: from AMS_MESSAGES_B

106: OBJECT_VERSION_NUMBER,
107: DATE_EFFECTIVE_FROM,
108: DATE_EFFECTIVE_TO,
109: ACTIVE_FLAG
110: from AMS_MESSAGES_B
111: where MESSAGE_ID = X_MESSAGE_ID
112: for update of MESSAGE_ID nowait;
113: recinfo c%rowtype;
114:

Line 181: update AMS_MESSAGES_B set

177: X_LAST_UPDATED_BY in NUMBER,
178: X_LAST_UPDATE_LOGIN in NUMBER
179: ) is
180: begin
181: update AMS_MESSAGES_B set
182: MESSAGE_TYPE_CODE = X_MESSAGE_TYPE_CODE,
183: OWNER_USER_ID = X_OWNER_USER_ID,
184: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
185: DATE_EFFECTIVE_FROM = X_DATE_EFFECTIVE_FROM,

Line 223: delete from AMS_MESSAGES_B

219: if (sql%notfound) then
220: raise no_data_found;
221: end if;
222:
223: delete from AMS_MESSAGES_B
224: where MESSAGE_ID = X_MESSAGE_ID;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 237: from AMS_MESSAGES_B B

233: begin
234: delete from AMS_MESSAGES_TL T
235: where not exists
236: (select NULL
237: from AMS_MESSAGES_B B
238: where B.MESSAGE_ID = T.MESSAGE_ID
239: );
240:
241: update AMS_MESSAGES_TL T set (

Line 338: from ams_messages_b

334: l_row_id varchar2(100);
335:
336: cursor c_version is
337: select object_version_number
338: from ams_messages_b
339: where message_id = X_MESSAGE_ID;
340:
341: cursor c_msg_exists is
342: select 'x'

Line 343: from ams_messages_b

339: where message_id = X_MESSAGE_ID;
340:
341: cursor c_msg_exists is
342: select 'x'
343: from ams_messages_b
344: where message_id = X_MESSAGE_ID;
345:
346: cursor c_msg_id is
347: select ams_messages_b_s.nextval

Line 347: select ams_messages_b_s.nextval

343: from ams_messages_b
344: where message_id = X_MESSAGE_ID;
345:
346: cursor c_msg_id is
347: select ams_messages_b_s.nextval
348: from dual;
349:
350: BEGIN
351: