APPS.AMS_EVENT_HEADERS_ALL_PKG dependencies on AMS_EVENT_HEADERS_ALL_TL

Line 233: insert into AMS_EVENT_HEADERS_ALL_TL (

229: X_LAST_UPDATED_BY,
230: X_LAST_UPDATE_LOGIN
231: );
232:
233: insert into AMS_EVENT_HEADERS_ALL_TL (
234: EVENT_HEADER_ID,
235: LAST_UPDATE_DATE,
236: LAST_UPDATED_BY,
237: CREATION_DATE,

Line 261: from AMS_EVENT_HEADERS_ALL_TL T

257: from FND_LANGUAGES L
258: where L.INSTALLED_FLAG in ('I', 'B')
259: and not exists
260: (select NULL
261: from AMS_EVENT_HEADERS_ALL_TL T
262: where T.EVENT_HEADER_ID = X_EVENT_HEADER_ID
263: and T.LANGUAGE = L.LANGUAGE_CODE);
264:
265: open c;

Line 424: from AMS_EVENT_HEADERS_ALL_TL

420: EVENT_HEADER_NAME,
421: EVENT_MKTG_MESSAGE,
422: DESCRIPTION,
423: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
424: from AMS_EVENT_HEADERS_ALL_TL
425: where EVENT_HEADER_ID = X_EVENT_HEADER_ID
426: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
427: for update of EVENT_HEADER_ID nowait;
428: begin

Line 738: update AMS_EVENT_HEADERS_ALL_TL set

734: if (sql%notfound) then
735: raise no_data_found;
736: end if;
737:
738: update AMS_EVENT_HEADERS_ALL_TL set
739: EVENT_HEADER_NAME = X_EVENT_HEADER_NAME,
740: EVENT_MKTG_MESSAGE = X_EVENT_MKTG_MESSAGE,
741: DESCRIPTION = X_DESCRIPTION,
742: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 758: delete from AMS_EVENT_HEADERS_ALL_TL

754: procedure DELETE_ROW (
755: X_EVENT_HEADER_ID in NUMBER
756: ) is
757: begin
758: delete from AMS_EVENT_HEADERS_ALL_TL
759: where EVENT_HEADER_ID = X_EVENT_HEADER_ID;
760:
761: if (sql%notfound) then
762: raise no_data_found;

Line 776: delete from AMS_EVENT_HEADERS_ALL_TL T

772:
773: procedure ADD_LANGUAGE
774: is
775: begin
776: delete from AMS_EVENT_HEADERS_ALL_TL T
777: where not exists
778: (select NULL
779: from AMS_EVENT_HEADERS_ALL_B B
780: where B.EVENT_HEADER_ID = T.EVENT_HEADER_ID

Line 783: update AMS_EVENT_HEADERS_ALL_TL T set (

779: from AMS_EVENT_HEADERS_ALL_B B
780: where B.EVENT_HEADER_ID = T.EVENT_HEADER_ID
781: );
782:
783: update AMS_EVENT_HEADERS_ALL_TL T set (
784: EVENT_HEADER_NAME,
785: EVENT_MKTG_MESSAGE,
786: DESCRIPTION
787: ) = (select

Line 791: from AMS_EVENT_HEADERS_ALL_TL B

787: ) = (select
788: B.EVENT_HEADER_NAME,
789: B.EVENT_MKTG_MESSAGE,
790: B.DESCRIPTION
791: from AMS_EVENT_HEADERS_ALL_TL B
792: where B.EVENT_HEADER_ID = T.EVENT_HEADER_ID
793: and B.LANGUAGE = T.SOURCE_LANG)
794: where (
795: T.EVENT_HEADER_ID,

Line 800: from AMS_EVENT_HEADERS_ALL_TL SUBB, AMS_EVENT_HEADERS_ALL_TL SUBT

796: T.LANGUAGE
797: ) in (select
798: SUBT.EVENT_HEADER_ID,
799: SUBT.LANGUAGE
800: from AMS_EVENT_HEADERS_ALL_TL SUBB, AMS_EVENT_HEADERS_ALL_TL SUBT
801: where SUBB.EVENT_HEADER_ID = SUBT.EVENT_HEADER_ID
802: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
803: and (SUBB.EVENT_HEADER_NAME <> SUBT.EVENT_HEADER_NAME
804: or SUBB.EVENT_MKTG_MESSAGE <> SUBT.EVENT_MKTG_MESSAGE

Line 812: insert into AMS_EVENT_HEADERS_ALL_TL (

808: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
809: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
810: ));
811:
812: insert into AMS_EVENT_HEADERS_ALL_TL (
813: EVENT_HEADER_ID,
814: LAST_UPDATE_DATE,
815: LAST_UPDATED_BY,
816: CREATION_DATE,

Line 836: from AMS_EVENT_HEADERS_ALL_TL B, FND_LANGUAGES L

832: B.EVENT_MKTG_MESSAGE,
833: B.DESCRIPTION,
834: L.LANGUAGE_CODE,
835: B.SOURCE_LANG
836: from AMS_EVENT_HEADERS_ALL_TL B, FND_LANGUAGES L
837: where L.INSTALLED_FLAG in ('I', 'B')
838: and B.LANGUAGE = userenv('LANG')
839: and not exists
840: (select NULL

Line 841: from AMS_EVENT_HEADERS_ALL_TL T

837: where L.INSTALLED_FLAG in ('I', 'B')
838: and B.LANGUAGE = userenv('LANG')
839: and not exists
840: (select NULL
841: from AMS_EVENT_HEADERS_ALL_TL T
842: where T.EVENT_HEADER_ID = B.EVENT_HEADER_ID
843: and T.LANGUAGE = L.LANGUAGE_CODE);
844: end ADD_LANGUAGE;
845:

Line 856: update AMS_EVENT_HEADERS_ALL_TL set

852: X_OWNER in VARCHAR2
853: )
854: IS
855: BEGIN
856: update AMS_EVENT_HEADERS_ALL_TL set
857: EVENT_HEADER_NAME = nvl(X_EVENT_HEADER_NAME,EVENT_HEADER_NAME),
858: EVENT_MKTG_MESSAGE = nvl(X_EVENT_MKTG_MESSAGE,EVENT_MKTG_MESSAGE),
859: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
860: LAST_UPDATE_DATE = SYSDATE,