APPS.AMS_DELIVERABLES_ALL_PKG dependencies on AMS_DELIVERABLES_ALL_TL

Line 211: insert into AMS_DELIVERABLES_ALL_TL (

207: X_LAST_UPDATED_BY,
208: X_LAST_UPDATE_LOGIN
209: );
210:
211: insert into AMS_DELIVERABLES_ALL_TL (
212: DELIVERABLE_ID,
213: LAST_UPDATE_DATE,
214: LAST_UPDATED_BY,
215: CREATION_DATE,

Line 237: from AMS_DELIVERABLES_ALL_TL T

233: from FND_LANGUAGES L
234: where L.INSTALLED_FLAG in ('I', 'B')
235: and not exists
236: (select NULL
237: from AMS_DELIVERABLES_ALL_TL T
238: where T.DELIVERABLE_ID = X_DELIVERABLE_ID
239: and T.LANGUAGE = L.LANGUAGE_CODE);
240:
241: open c;

Line 384: from AMS_DELIVERABLES_ALL_TL

380: cursor c1 is select
381: DELIVERABLE_NAME,
382: DESCRIPTION,
383: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
384: from AMS_DELIVERABLES_ALL_TL
385: where DELIVERABLE_ID = X_DELIVERABLE_ID
386: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
387: for update of DELIVERABLE_ID nowait;
388: begin

Line 673: update AMS_DELIVERABLES_ALL_TL set

669: if (sql%notfound) then
670: raise no_data_found;
671: end if;
672:
673: update AMS_DELIVERABLES_ALL_TL set
674: DELIVERABLE_NAME = X_DELIVERABLE_NAME,
675: DESCRIPTION = X_DESCRIPTION,
676: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
677: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 692: delete from AMS_DELIVERABLES_ALL_TL

688: procedure DELETE_ROW (
689: X_DELIVERABLE_ID in NUMBER
690: ) is
691: begin
692: delete from AMS_DELIVERABLES_ALL_TL
693: where DELIVERABLE_ID = X_DELIVERABLE_ID;
694:
695: if (sql%notfound) then
696: raise no_data_found;

Line 710: delete from AMS_DELIVERABLES_ALL_TL T

706:
707: procedure ADD_LANGUAGE
708: is
709: begin
710: delete from AMS_DELIVERABLES_ALL_TL T
711: where not exists
712: (select NULL
713: from AMS_DELIVERABLES_ALL_B B
714: where B.DELIVERABLE_ID = T.DELIVERABLE_ID

Line 717: update AMS_DELIVERABLES_ALL_TL T set (

713: from AMS_DELIVERABLES_ALL_B B
714: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
715: );
716:
717: update AMS_DELIVERABLES_ALL_TL T set (
718: DELIVERABLE_NAME,
719: DESCRIPTION
720: ) = (select
721: B.DELIVERABLE_NAME,

Line 723: from AMS_DELIVERABLES_ALL_TL B

719: DESCRIPTION
720: ) = (select
721: B.DELIVERABLE_NAME,
722: B.DESCRIPTION
723: from AMS_DELIVERABLES_ALL_TL B
724: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
725: and B.LANGUAGE = T.SOURCE_LANG)
726: where (
727: T.DELIVERABLE_ID,

Line 732: from AMS_DELIVERABLES_ALL_TL SUBB, AMS_DELIVERABLES_ALL_TL SUBT

728: T.LANGUAGE
729: ) in (select
730: SUBT.DELIVERABLE_ID,
731: SUBT.LANGUAGE
732: from AMS_DELIVERABLES_ALL_TL SUBB, AMS_DELIVERABLES_ALL_TL SUBT
733: where SUBB.DELIVERABLE_ID = SUBT.DELIVERABLE_ID
734: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
735: and (SUBB.DELIVERABLE_NAME <> SUBT.DELIVERABLE_NAME
736: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 741: insert into AMS_DELIVERABLES_ALL_TL (

737: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
738: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
739: ));
740:
741: insert into AMS_DELIVERABLES_ALL_TL (
742: DELIVERABLE_ID,
743: LAST_UPDATE_DATE,
744: LAST_UPDATED_BY,
745: CREATION_DATE,

Line 763: from AMS_DELIVERABLES_ALL_TL B, FND_LANGUAGES L

759: B.DELIVERABLE_NAME,
760: B.DESCRIPTION,
761: L.LANGUAGE_CODE,
762: B.SOURCE_LANG
763: from AMS_DELIVERABLES_ALL_TL B, FND_LANGUAGES L
764: where L.INSTALLED_FLAG in ('I', 'B')
765: and B.LANGUAGE = userenv('LANG')
766: and not exists
767: (select NULL

Line 768: from AMS_DELIVERABLES_ALL_TL T

764: where L.INSTALLED_FLAG in ('I', 'B')
765: and B.LANGUAGE = userenv('LANG')
766: and not exists
767: (select NULL
768: from AMS_DELIVERABLES_ALL_TL T
769: where T.DELIVERABLE_ID = B.DELIVERABLE_ID
770: and T.LANGUAGE = L.LANGUAGE_CODE);
771: end ADD_LANGUAGE;
772:

Line 780: update AMS_DELIVERABLES_ALL_TL set

776: , x_description in VARCHAR2
777: , x_owner in VARCHAR2
778: ) is
779: begin
780: update AMS_DELIVERABLES_ALL_TL set
781: deliverable_name = nvl(x_deliverable_name, deliverable_name),
782: description = nvl(x_description, description),
783: source_lang = userenv('LANG'),
784: last_update_date = sysdate,