APPS.AMS_APPROVAL_DETAILS_PKG dependencies on AMS_APPROVAL_DETAILS_TL

Line 88: insert into AMS_APPROVAL_DETAILS_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into AMS_APPROVAL_DETAILS_TL (
89: APPROVAL_DETAIL_ID,
90: CREATION_DATE,
91: CREATED_BY,
92: LAST_UPDATE_DATE,

Line 116: from AMS_APPROVAL_DETAILS_TL T

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

Line 178: from AMS_APPROVAL_DETAILS_TL

174: cursor c1 is select
175: NAME,
176: DESCRIPTION,
177: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
178: from AMS_APPROVAL_DETAILS_TL
179: where APPROVAL_DETAIL_ID = X_APPROVAL_DETAIL_ID
180: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
181: for update of APPROVAL_DETAIL_ID nowait;
182: begin

Line 299: update AMS_APPROVAL_DETAILS_TL set

295: if (sql%notfound) then
296: raise no_data_found;
297: end if;
298:
299: update AMS_APPROVAL_DETAILS_TL set
300: NAME = X_NAME,
301: DESCRIPTION = X_DESCRIPTION,
302: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
303: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 318: delete from AMS_APPROVAL_DETAILS_TL

314: procedure DELETE_ROW (
315: X_APPROVAL_DETAIL_ID in NUMBER
316: ) is
317: begin
318: delete from AMS_APPROVAL_DETAILS_TL
319: where APPROVAL_DETAIL_ID = X_APPROVAL_DETAIL_ID;
320:
321: if (sql%notfound) then
322: raise no_data_found;

Line 336: delete from AMS_APPROVAL_DETAILS_TL T

332:
333: procedure ADD_LANGUAGE
334: is
335: begin
336: delete from AMS_APPROVAL_DETAILS_TL T
337: where not exists
338: (select NULL
339: from AMS_APPROVAL_DETAILS B
340: where B.APPROVAL_DETAIL_ID = T.APPROVAL_DETAIL_ID

Line 343: update AMS_APPROVAL_DETAILS_TL T set (

339: from AMS_APPROVAL_DETAILS B
340: where B.APPROVAL_DETAIL_ID = T.APPROVAL_DETAIL_ID
341: );
342:
343: update AMS_APPROVAL_DETAILS_TL T set (
344: NAME,
345: DESCRIPTION
346: ) = (select
347: B.NAME,

Line 349: from AMS_APPROVAL_DETAILS_TL B

345: DESCRIPTION
346: ) = (select
347: B.NAME,
348: B.DESCRIPTION
349: from AMS_APPROVAL_DETAILS_TL B
350: where B.APPROVAL_DETAIL_ID = T.APPROVAL_DETAIL_ID
351: and B.LANGUAGE = T.SOURCE_LANG)
352: where (
353: T.APPROVAL_DETAIL_ID,

Line 358: from AMS_APPROVAL_DETAILS_TL SUBB, AMS_APPROVAL_DETAILS_TL SUBT

354: T.LANGUAGE
355: ) in (select
356: SUBT.APPROVAL_DETAIL_ID,
357: SUBT.LANGUAGE
358: from AMS_APPROVAL_DETAILS_TL SUBB, AMS_APPROVAL_DETAILS_TL SUBT
359: where SUBB.APPROVAL_DETAIL_ID = SUBT.APPROVAL_DETAIL_ID
360: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
361: and (SUBB.NAME <> SUBT.NAME
362: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 367: insert into AMS_APPROVAL_DETAILS_TL (

363: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
364: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
365: ));
366:
367: insert into AMS_APPROVAL_DETAILS_TL (
368: APPROVAL_DETAIL_ID,
369: CREATION_DATE,
370: CREATED_BY,
371: LAST_UPDATE_DATE,

Line 391: from AMS_APPROVAL_DETAILS_TL B, FND_LANGUAGES L

387: B.DESCRIPTION,
388: --B.SECURITY_GROUP_ID,
389: L.LANGUAGE_CODE,
390: B.SOURCE_LANG
391: from AMS_APPROVAL_DETAILS_TL B, FND_LANGUAGES L
392: where L.INSTALLED_FLAG in ('I', 'B')
393: and B.LANGUAGE = userenv('LANG')
394: and not exists
395: (select NULL

Line 396: from AMS_APPROVAL_DETAILS_TL T

392: where L.INSTALLED_FLAG in ('I', 'B')
393: and B.LANGUAGE = userenv('LANG')
394: and not exists
395: (select NULL
396: from AMS_APPROVAL_DETAILS_TL T
397: where T.APPROVAL_DETAIL_ID = B.APPROVAL_DETAIL_ID
398: and T.LANGUAGE = L.LANGUAGE_CODE);
399: end ADD_LANGUAGE;
400:

Line 408: update AMS_APPROVAL_DETAILS_TL set

404: X_DESCRIPTION in VARCHAR2,
405: X_OWNER in VARCHAR2
406: ) IS
407: begin
408: update AMS_APPROVAL_DETAILS_TL set
409: name = nvl(x_name, name),
410: description = nvl(x_description, description),
411: source_lang = userenv('LANG'),
412: last_update_date = sysdate,