APPS.AHL_MR_ACTIONS_PKG dependencies on AHL_MR_ACTIONS_TL

Line 93: insert into AHL_MR_ACTIONS_TL (

89: X_LAST_UPDATED_BY,
90: X_LAST_UPDATE_LOGIN
91: );
92:
93: insert into AHL_MR_ACTIONS_TL (
94: MR_ACTION_ID,
95: LAST_UPDATE_DATE,
96: LAST_UPDATED_BY,
97: CREATION_DATE,

Line 117: from AHL_MR_ACTIONS_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from AHL_MR_ACTIONS_TL T
118: where T.MR_ACTION_ID = X_MR_ACTION_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 190: update AHL_MR_ACTIONS_TL set

186: if (sql%ROWCOUNT=0) then
187: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
188: FND_MSG_PUB.ADD;
189: else
190: update AHL_MR_ACTIONS_TL set
191: DESCRIPTION = X_DESCRIPTION,
192: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
193: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
194: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 206: delete from AHL_MR_ACTIONS_TL

202: procedure DELETE_ROW (
203: X_MR_ACTION_ID in NUMBER
204: ) is
205: begin
206: delete from AHL_MR_ACTIONS_TL
207: where MR_ACTION_ID = X_MR_ACTION_ID;
208:
209: if (sql%ROWCOUNT=0) then
210: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

Line 230: delete from AHL_MR_ACTIONS_TL T

226:
227: procedure ADD_LANGUAGE
228: is
229: begin
230: delete from AHL_MR_ACTIONS_TL T
231: where not exists
232: (select NULL
233: from AHL_MR_ACTIONS_B B
234: where B.MR_ACTION_ID = T.MR_ACTION_ID

Line 237: update AHL_MR_ACTIONS_TL T set (

233: from AHL_MR_ACTIONS_B B
234: where B.MR_ACTION_ID = T.MR_ACTION_ID
235: );
236:
237: update AHL_MR_ACTIONS_TL T set (
238: DESCRIPTION
239: ) = (select
240: B.DESCRIPTION
241: from AHL_MR_ACTIONS_TL B

Line 241: from AHL_MR_ACTIONS_TL B

237: update AHL_MR_ACTIONS_TL T set (
238: DESCRIPTION
239: ) = (select
240: B.DESCRIPTION
241: from AHL_MR_ACTIONS_TL B
242: where B.MR_ACTION_ID = T.MR_ACTION_ID
243: and B.LANGUAGE = T.SOURCE_LANG)
244: where (
245: T.MR_ACTION_ID,

Line 250: from AHL_MR_ACTIONS_TL SUBB, AHL_MR_ACTIONS_TL SUBT

246: T.LANGUAGE
247: ) in (select
248: SUBT.MR_ACTION_ID,
249: SUBT.LANGUAGE
250: from AHL_MR_ACTIONS_TL SUBB, AHL_MR_ACTIONS_TL SUBT
251: where SUBB.MR_ACTION_ID = SUBT.MR_ACTION_ID
252: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
253: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
254: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 258: insert into AHL_MR_ACTIONS_TL (

254: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
255: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
256: ));
257:
258: insert into AHL_MR_ACTIONS_TL (
259: MR_ACTION_ID,
260: LAST_UPDATE_DATE,
261: LAST_UPDATED_BY,
262: CREATION_DATE,

Line 278: from AHL_MR_ACTIONS_TL B, FND_LANGUAGES L

274: B.LAST_UPDATE_LOGIN,
275: B.DESCRIPTION,
276: L.LANGUAGE_CODE,
277: B.SOURCE_LANG
278: from AHL_MR_ACTIONS_TL B, FND_LANGUAGES L
279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL

Line 283: from AHL_MR_ACTIONS_TL T

279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL
283: from AHL_MR_ACTIONS_TL T
284: where T.MR_ACTION_ID = B.MR_ACTION_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286: end ADD_LANGUAGE;
287: