APPS.AMS_PROGRAMS_ALL_PKG dependencies on AMS_PROGRAMS_ALL_TL

Line 92: insert into AMS_PROGRAMS_ALL_TL (

88: X_LAST_UPDATED_BY,
89: X_LAST_UPDATE_LOGIN
90: );
91:
92: insert into AMS_PROGRAMS_ALL_TL (
93: PROGRAM_ID,
94: LAST_UPDATE_DATE,
95: LAST_UPDATED_BY,
96: CREATION_DATE,

Line 118: from AMS_PROGRAMS_ALL_TL T

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

Line 183: from AMS_PROGRAMS_ALL_TL

179: cursor c1 is select
180: PROGRAM_NAME,
181: DESCRIPTION,
182: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
183: from AMS_PROGRAMS_ALL_TL
184: where PROGRAM_ID = X_PROGRAM_ID
185: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
186: for update of PROGRAM_ID nowait;
187: begin

Line 310: update AMS_PROGRAMS_ALL_TL set

306: if (sql%notfound) then
307: raise no_data_found;
308: end if;
309:
310: update AMS_PROGRAMS_ALL_TL set
311: PROGRAM_NAME = X_PROGRAM_NAME,
312: DESCRIPTION = X_DESCRIPTION,
313: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
314: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 329: delete from AMS_PROGRAMS_ALL_TL

325: procedure DELETE_ROW (
326: X_PROGRAM_ID in NUMBER
327: ) is
328: begin
329: delete from AMS_PROGRAMS_ALL_TL
330: where PROGRAM_ID = X_PROGRAM_ID;
331:
332: if (sql%notfound) then
333: raise no_data_found;

Line 347: delete from AMS_PROGRAMS_ALL_TL T

343:
344: procedure ADD_LANGUAGE
345: is
346: begin
347: delete from AMS_PROGRAMS_ALL_TL T
348: where not exists
349: (select NULL
350: from AMS_PROGRAMS_ALL_B B
351: where B.PROGRAM_ID = T.PROGRAM_ID

Line 354: update AMS_PROGRAMS_ALL_TL T set (

350: from AMS_PROGRAMS_ALL_B B
351: where B.PROGRAM_ID = T.PROGRAM_ID
352: );
353:
354: update AMS_PROGRAMS_ALL_TL T set (
355: PROGRAM_NAME,
356: DESCRIPTION
357: ) = (select
358: B.PROGRAM_NAME,

Line 360: from AMS_PROGRAMS_ALL_TL B

356: DESCRIPTION
357: ) = (select
358: B.PROGRAM_NAME,
359: B.DESCRIPTION
360: from AMS_PROGRAMS_ALL_TL B
361: where B.PROGRAM_ID = T.PROGRAM_ID
362: and B.LANGUAGE = T.SOURCE_LANG)
363: where (
364: T.PROGRAM_ID,

Line 369: from AMS_PROGRAMS_ALL_TL SUBB, AMS_PROGRAMS_ALL_TL SUBT

365: T.LANGUAGE
366: ) in (select
367: SUBT.PROGRAM_ID,
368: SUBT.LANGUAGE
369: from AMS_PROGRAMS_ALL_TL SUBB, AMS_PROGRAMS_ALL_TL SUBT
370: where SUBB.PROGRAM_ID = SUBT.PROGRAM_ID
371: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
372: and (SUBB.PROGRAM_NAME <> SUBT.PROGRAM_NAME
373: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 378: insert into AMS_PROGRAMS_ALL_TL (

374: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
375: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
376: ));
377:
378: insert into AMS_PROGRAMS_ALL_TL (
379: PROGRAM_ID,
380: LAST_UPDATE_DATE,
381: LAST_UPDATED_BY,
382: CREATION_DATE,

Line 400: from AMS_PROGRAMS_ALL_TL B, FND_LANGUAGES L

396: B.PROGRAM_NAME,
397: B.DESCRIPTION,
398: L.LANGUAGE_CODE,
399: B.SOURCE_LANG
400: from AMS_PROGRAMS_ALL_TL B, FND_LANGUAGES L
401: where L.INSTALLED_FLAG in ('I', 'B')
402: and B.LANGUAGE = userenv('LANG')
403: and not exists
404: (select NULL

Line 405: from AMS_PROGRAMS_ALL_TL T

401: where L.INSTALLED_FLAG in ('I', 'B')
402: and B.LANGUAGE = userenv('LANG')
403: and not exists
404: (select NULL
405: from AMS_PROGRAMS_ALL_TL T
406: where T.PROGRAM_ID = B.PROGRAM_ID
407: and T.LANGUAGE = L.LANGUAGE_CODE);
408: end ADD_LANGUAGE;
409:

Line 419: update AMS_PROGRAMS_ALL_TL set

415: X_OWNER in VARCHAR2
416: ) IS
417:
418: begin
419: update AMS_PROGRAMS_ALL_TL set
420: program_name = nvl(x_program_name, program_name),
421: description = nvl(x_description, description),
422: source_lang = userenv('LANG'),
423: last_update_date = sysdate,