APPS.CSM_NEW_MESSAGES_PKG dependencies on CSM_NEW_MESSAGES_TL

Line 41: INSERT INTO CSM_NEW_MESSAGES_TL

37: );
38:
39:
40: --Insert into TL table
41: INSERT INTO CSM_NEW_MESSAGES_TL
42: (MESSAGE_ID,
43: MESSAGE_NAME,
44: MESSAGE_TEXT,
45: DESCRIPTION,

Line 66: FROM CSM_NEW_MESSAGES_TL T

62: FROM FND_LANGUAGES L
63: WHERE L.INSTALLED_FLAG in ('I', 'B')
64: AND NOT EXISTS
65: (SELECT NULL
66: FROM CSM_NEW_MESSAGES_TL T
67: WHERE T.MESSAGE_NAME = X_MESSAGE_NAME);
68:
69:
70: END INSERT_ROW;

Line 76: DELETE FROM CSM_NEW_MESSAGES_TL TL

72: PROCEDURE ADD_LANGUAGE
73: IS
74: BEGIN
75: --deleting obsolete TL records
76: DELETE FROM CSM_NEW_MESSAGES_TL TL
77: WHERE NOT EXISTS (SELECT 1 FROM CSM_NEW_MESSAGES B
78: WHERE B.MESSAGE_ID=TL.MESSAGE_ID);
79:
80: --no need for TL table update since we are taking care of it in UPDATE_ROW api itself.

Line 84: INSERT INTO CSM_NEW_MESSAGES_TL

80: --no need for TL table update since we are taking care of it in UPDATE_ROW api itself.
81:
82:
83: --insert TL records for new language
84: INSERT INTO CSM_NEW_MESSAGES_TL
85: (MESSAGE_ID,
86: MESSAGE_NAME,
87: MESSAGE_TEXT,
88: DESCRIPTION,

Line 105: FROM CSM_NEW_MESSAGES_TL B,

101: B.CREATION_DATE,
102: B.CREATED_BY,
103: B.LAST_UPDATE_DATE,
104: B.LAST_UPDATED_BY
105: FROM CSM_NEW_MESSAGES_TL B,
106: FND_LANGUAGES L
107: WHERE B.LANGUAGE = userenv('LANG')
108: AND L.INSTALLED_FLAG in ('I', 'B')
109: AND NOT EXISTS

Line 111: FROM CSM_NEW_MESSAGES_TL T

107: WHERE B.LANGUAGE = userenv('LANG')
108: AND L.INSTALLED_FLAG in ('I', 'B')
109: AND NOT EXISTS
110: (SELECT NULL
111: FROM CSM_NEW_MESSAGES_TL T
112: WHERE T.MESSAGE_NAME = B.MESSAGE_NAME
113: AND T.LANGUAGE = L.LANGUAGE_CODE);
114:
115: END ADD_LANGUAGE;

Line 140: UPDATE CSM_NEW_MESSAGES_TL

136: LAST_UPDATE_DATE = SYSDATE
137: WHERE MESSAGE_NAME = X_MESSAGE_NAME;
138:
139: --Update TL Table
140: UPDATE CSM_NEW_MESSAGES_TL
141: SET MESSAGE_TEXT = X_MESSAGE_TEXT,
142: DESCRIPTION = X_DESCRIPTION,
143: SOURCE_LANGUAGE = userenv('LANG'),
144: LAST_UPDATED_BY = DECODE(X_OWNER,'SEED',1,0),

Line 235: UPDATE CSM_NEW_MESSAGES_TL SET

231: CLOSE c_message_exists;
232:
233: IF l_exists IS NOT NULL THEN
234:
235: UPDATE CSM_NEW_MESSAGES_TL SET
236: MESSAGE_TEXT = nvl(X_MESSAGE_TEXT, MESSAGE_TEXT),
237: DESCRIPTION = nvl(X_DESCRIPTION, DESCRIPTION),
238: LAST_UPDATE_DATE = SYSDATE,
239: LAST_UPDATED_BY = DECODE(X_OWNER,'SEED',1,0),