APPS.AMS_EVENT_OFFERS_ALL_PKG dependencies on AMS_EVENT_OFFERS_ALL_TL

Line 296: insert into AMS_EVENT_OFFERS_ALL_TL (

292: X_LAST_UPDATED_BY,
293: X_LAST_UPDATE_LOGIN
294: );
295:
296: insert into AMS_EVENT_OFFERS_ALL_TL (
297: EVENT_OFFER_ID,
298: LAST_UPDATE_DATE,
299: LAST_UPDATED_BY,
300: CREATION_DATE,

Line 324: from AMS_EVENT_OFFERS_ALL_TL T

320: from FND_LANGUAGES L
321: where L.INSTALLED_FLAG in ('I', 'B')
322: and not exists
323: (select NULL
324: from AMS_EVENT_OFFERS_ALL_TL T
325: where T.EVENT_OFFER_ID = X_EVENT_OFFER_ID
326: and T.LANGUAGE = L.LANGUAGE_CODE);
327:
328: open c;

Line 529: from AMS_EVENT_OFFERS_ALL_TL

525: EVENT_OFFER_NAME,
526: EVENT_MKTG_MESSAGE,
527: DESCRIPTION,
528: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
529: from AMS_EVENT_OFFERS_ALL_TL
530: where EVENT_OFFER_ID = X_EVENT_OFFER_ID
531: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
532: for update of EVENT_OFFER_ID nowait;
533: begin

Line 919: update AMS_EVENT_OFFERS_ALL_TL set

915: if (sql%notfound) then
916: raise no_data_found;
917: end if;
918:
919: update AMS_EVENT_OFFERS_ALL_TL set
920: EVENT_OFFER_NAME = X_EVENT_OFFER_NAME,
921: EVENT_MKTG_MESSAGE = X_EVENT_MKTG_MESSAGE,
922: DESCRIPTION = X_DESCRIPTION,
923: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 939: delete from AMS_EVENT_OFFERS_ALL_TL

935: procedure DELETE_ROW (
936: X_EVENT_OFFER_ID in NUMBER
937: ) is
938: begin
939: delete from AMS_EVENT_OFFERS_ALL_TL
940: where EVENT_OFFER_ID = X_EVENT_OFFER_ID;
941:
942: if (sql%notfound) then
943: raise no_data_found;

Line 957: delete from AMS_EVENT_OFFERS_ALL_TL T

953:
954: procedure ADD_LANGUAGE
955: is
956: begin
957: delete from AMS_EVENT_OFFERS_ALL_TL T
958: where not exists
959: (select NULL
960: from AMS_EVENT_OFFERS_ALL_B B
961: where B.EVENT_OFFER_ID = T.EVENT_OFFER_ID

Line 964: update AMS_EVENT_OFFERS_ALL_TL T set (

960: from AMS_EVENT_OFFERS_ALL_B B
961: where B.EVENT_OFFER_ID = T.EVENT_OFFER_ID
962: );
963:
964: update AMS_EVENT_OFFERS_ALL_TL T set (
965: EVENT_OFFER_NAME,
966: EVENT_MKTG_MESSAGE,
967: DESCRIPTION
968: ) = (select

Line 972: from AMS_EVENT_OFFERS_ALL_TL B

968: ) = (select
969: B.EVENT_OFFER_NAME,
970: B.EVENT_MKTG_MESSAGE,
971: B.DESCRIPTION
972: from AMS_EVENT_OFFERS_ALL_TL B
973: where B.EVENT_OFFER_ID = T.EVENT_OFFER_ID
974: and B.LANGUAGE = T.SOURCE_LANG)
975: where (
976: T.EVENT_OFFER_ID,

Line 981: from AMS_EVENT_OFFERS_ALL_TL SUBB, AMS_EVENT_OFFERS_ALL_TL SUBT

977: T.LANGUAGE
978: ) in (select
979: SUBT.EVENT_OFFER_ID,
980: SUBT.LANGUAGE
981: from AMS_EVENT_OFFERS_ALL_TL SUBB, AMS_EVENT_OFFERS_ALL_TL SUBT
982: where SUBB.EVENT_OFFER_ID = SUBT.EVENT_OFFER_ID
983: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
984: and (SUBB.EVENT_OFFER_NAME <> SUBT.EVENT_OFFER_NAME
985: or SUBB.EVENT_MKTG_MESSAGE <> SUBT.EVENT_MKTG_MESSAGE

Line 993: insert into AMS_EVENT_OFFERS_ALL_TL (

989: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
990: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
991: ));
992:
993: insert into AMS_EVENT_OFFERS_ALL_TL (
994: EVENT_OFFER_ID,
995: LAST_UPDATE_DATE,
996: LAST_UPDATED_BY,
997: CREATION_DATE,

Line 1017: from AMS_EVENT_OFFERS_ALL_TL B, FND_LANGUAGES L

1013: B.DESCRIPTION,
1014: B.EVENT_MKTG_MESSAGE,
1015: L.LANGUAGE_CODE,
1016: B.SOURCE_LANG
1017: from AMS_EVENT_OFFERS_ALL_TL B, FND_LANGUAGES L
1018: where L.INSTALLED_FLAG in ('I', 'B')
1019: and B.LANGUAGE = userenv('LANG')
1020: and not exists
1021: (select NULL

Line 1022: from AMS_EVENT_OFFERS_ALL_TL T

1018: where L.INSTALLED_FLAG in ('I', 'B')
1019: and B.LANGUAGE = userenv('LANG')
1020: and not exists
1021: (select NULL
1022: from AMS_EVENT_OFFERS_ALL_TL T
1023: where T.EVENT_OFFER_ID = B.EVENT_OFFER_ID
1024: and T.LANGUAGE = L.LANGUAGE_CODE);
1025: end ADD_LANGUAGE;
1026:

Line 1035: update AMS_EVENT_OFFERS_ALL_TL set

1031: X_EVENT_MKTG_MESSAGE in VARCHAR2,
1032: X_OWNER in VARCHAR2
1033: ) IS
1034: BEGIN
1035: update AMS_EVENT_OFFERS_ALL_TL set
1036: EVENT_OFFER_NAME = nvl(X_EVENT_OFFER_NAME,EVENT_OFFER_NAME),
1037: EVENT_MKTG_MESSAGE = nvl(X_EVENT_MKTG_MESSAGE,EVENT_MKTG_MESSAGE),
1038: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
1039: LAST_UPDATE_DATE = SYSDATE,