APPS.CS_FORUM_MESSAGES_PKG dependencies on CS_FORUM_MESSAGES_B

Line 59: cursor C is select MESSAGE_ID from CS_FORUM_MESSAGES_B

55: X_ATTRIBUTE13 in VARCHAR2 ,
56: X_ATTRIBUTE14 in VARCHAR2 ,
57: X_ATTRIBUTE15 in VARCHAR2
58: ) is
59: cursor C is select MESSAGE_ID from CS_FORUM_MESSAGES_B
60: where MESSAGE_ID = X_MESSAGE_ID
61: ;
62: begin
63: insert into CS_FORUM_MESSAGES_B (

Line 63: insert into CS_FORUM_MESSAGES_B (

59: cursor C is select MESSAGE_ID from CS_FORUM_MESSAGES_B
60: where MESSAGE_ID = X_MESSAGE_ID
61: ;
62: begin
63: insert into CS_FORUM_MESSAGES_B (
64: MESSAGE_ID,
65: MESSAGE_NUMBER,
66: MESSAGE_TYPE,
67: MESSAGE_NAME,

Line 214: from CS_FORUM_MESSAGES_B

210: ATTRIBUTE12,
211: ATTRIBUTE13,
212: ATTRIBUTE14,
213: ATTRIBUTE15
214: from CS_FORUM_MESSAGES_B
215: where MESSAGE_ID = X_MESSAGE_ID
216: for update of MESSAGE_ID nowait;
217: recinfo c%rowtype;
218:

Line 336: update CS_FORUM_MESSAGES_B set

332: X_ATTRIBUTE14 in VARCHAR2 ,
333: X_ATTRIBUTE15 in VARCHAR2
334: ) is
335: begin
336: update CS_FORUM_MESSAGES_B set
337: MESSAGE_TYPE = X_MESSAGE_TYPE,
338: MESSAGE_NAME = X_MESSAGE_NAME,
339: POSTED_DATE = X_POSTED_DATE,
340: POSTED_USER = X_POSTED_USER,

Line 397: delete from CS_FORUM_MESSAGES_B

393: raise no_data_found;
394: end if;
395: */
396:
397: delete from CS_FORUM_MESSAGES_B
398: where MESSAGE_ID = X_MESSAGE_ID;
399:
400: /*
401: if (sql%notfound) then

Line 413: from CS_FORUM_MESSAGES_B B

409: begin
410: delete from CS_FORUM_MESSAGES_TL T
411: where not exists
412: (select NULL
413: from CS_FORUM_MESSAGES_B B
414: where B.MESSAGE_ID = T.MESSAGE_ID
415: );
416:
417: update CS_FORUM_MESSAGES_TL T set (