APPS.CSM_NEW_MESSAGES_PKG dependencies on CSM_NEW_MESSAGES_PERZ

Line 266: INSERT INTO CSM_NEW_MESSAGES_PERZ

262: errmsg varchar2(4000);
263:
264: BEGIN
265: --Insert into Perz table
266: INSERT INTO CSM_NEW_MESSAGES_PERZ
267: (MESSAGE_ID,
268: MESSAGE_NAME,
269: LEVEL_ID,
270: LEVEL_VALUE,

Line 309: UPDATE CSM_NEW_MESSAGES_PERZ

305: IS
306:
307: BEGIN
308: --Update base Table
309: UPDATE CSM_NEW_MESSAGES_PERZ
310: SET MESSAGE_TEXT = X_MESSAGE_TEXT,
311: DESCRIPTION = X_DESCRIPTION,
312: LAST_UPDATED_BY = DECODE(X_OWNER,'SEED',1,0),
313: LAST_UPDATE_DATE = SYSDATE

Line 335: FROM CSM_NEW_MESSAGES_PERZ PERZ

331: IS
332:
333: CURSOR c_message_exists(b_message_name VARCHAR2, b_level_id NUMBER, b_level_value NUMBER, b_language VARCHAR2) IS
334: SELECT 1
335: FROM CSM_NEW_MESSAGES_PERZ PERZ
336: WHERE PERZ.MESSAGE_NAME = b_message_name
337: AND PERZ.LEVEL_ID = b_level_id
338: AND PERZ.LEVEL_VALUE = b_level_value
339: AND PERZ.LANGUAGE = b_language;