APPS.AMS_AGENDAS_PVT dependencies on AMS_AGENDAS_TL

Line 382: INSERT INTO ams_agendas_tl(

378: l_agenda_rec.attribute14,
379: l_agenda_rec.attribute15
380: );
381:
382: INSERT INTO ams_agendas_tl(
383: agenda_id,
384: language,
385: last_update_date,
386: last_updated_by,

Line 409: FROM ams_agendas_tl t

405: FROM fnd_languages l
406: WHERE l.installed_flag in ('I', 'B')
407: AND NOT EXISTS(
408: SELECT NULL
409: FROM ams_agendas_tl t
410: WHERE t.agenda_id = l_agenda_rec.agenda_id
411: AND t.language = l.language_code );
412:
413: -- set OUT value

Line 863: UPDATE ams_agendas_tl SET

859: END IF;
860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
861: END IF;
862:
863: UPDATE ams_agendas_tl SET
864: agenda_name = l_agenda_rec.agenda_name,
865: description = l_agenda_rec.description,
866: last_update_date = SYSDATE,
867: last_updated_by = FND_GLOBAL.user_id,

Line 2621: delete from ams_agendas_tl T

2617:
2618: procedure ADD_LANGUAGE
2619: is
2620: begin
2621: delete from ams_agendas_tl T
2622: where not exists
2623: (select NULL
2624: from ams_agendas_b B
2625: where B.AGENDA_ID = T.AGENDA_ID

Line 2628: update ams_agendas_tl T set (

2624: from ams_agendas_b B
2625: where B.AGENDA_ID = T.AGENDA_ID
2626: );
2627:
2628: update ams_agendas_tl T set (
2629: DESCRIPTION
2630: ) = (select
2631: B.DESCRIPTION
2632: from ams_agendas_tl B

Line 2632: from ams_agendas_tl B

2628: update ams_agendas_tl T set (
2629: DESCRIPTION
2630: ) = (select
2631: B.DESCRIPTION
2632: from ams_agendas_tl B
2633: where B.AGENDA_ID = T.AGENDA_ID
2634: and B.LANGUAGE = T.SOURCE_LANG)
2635: where (
2636: T.AGENDA_ID,

Line 2641: from ams_agendas_tl SUBB, ams_agendas_tl SUBT

2637: T.LANGUAGE
2638: ) in (select
2639: SUBT.AGENDA_ID,
2640: SUBT.LANGUAGE
2641: from ams_agendas_tl SUBB, ams_agendas_tl SUBT
2642: where SUBB.AGENDA_ID = SUBT.AGENDA_ID
2643: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2644: and (SUBB.AGENDA_NAME <> SUBT.AGENDA_NAME
2645: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 2650: insert into ams_agendas_tl (

2646: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
2647: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
2648: ));
2649:
2650: insert into ams_agendas_tl (
2651: AGENDA_ID,
2652: LANGUAGE,
2653: CREATION_DATE,
2654: CREATED_BY,

Line 2674: from ams_agendas_tl B, FND_LANGUAGES L

2670: B.SOURCE_LANG,
2671: B.AGENDA_NAME,
2672: B.DESCRIPTION,
2673: B.SECURITY_GROUP_ID
2674: from ams_agendas_tl B, FND_LANGUAGES L
2675: where L.INSTALLED_FLAG in ('I', 'B')
2676: and B.LANGUAGE = userenv('LANG')
2677: and not exists
2678: (select NULL

Line 2679: from ams_agendas_tl T

2675: where L.INSTALLED_FLAG in ('I', 'B')
2676: and B.LANGUAGE = userenv('LANG')
2677: and not exists
2678: (select NULL
2679: from ams_agendas_tl T
2680: where T.AGENDA_ID = B.AGENDA_ID
2681: and T.LANGUAGE = L.LANGUAGE_CODE);
2682: end ADD_LANGUAGE;
2683: