APPS.AMS_VENUES_PKG dependencies on AMS_VENUES_TL

Line 139: insert into AMS_VENUES_TL (

135: X_LAST_UPDATED_BY,
136: X_LAST_UPDATE_LOGIN
137: );
138:
139: insert into AMS_VENUES_TL (
140: --SECURITY_GROUP_ID,
141: VENUE_ID,
142: LAST_UPDATE_DATE,
143: LAST_UPDATED_BY,

Line 167: from AMS_VENUES_TL T

163: from FND_LANGUAGES L
164: where L.INSTALLED_FLAG in ('I', 'B')
165: and not exists
166: (select NULL
167: from AMS_VENUES_TL T
168: where T.VENUE_ID = X_VENUE_ID
169: and T.LANGUAGE = L.LANGUAGE_CODE);
170:
171: open c;

Line 266: from AMS_VENUES_TL

262: cursor c1 is select
263: VENUE_NAME,
264: DESCRIPTION,
265: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
266: from AMS_VENUES_TL
267: where VENUE_ID = X_VENUE_ID
268: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
269: for update of VENUE_ID nowait;
270: begin

Line 455: update AMS_VENUES_TL set

451: if (sql%notfound) then
452: raise no_data_found;
453: end if;
454:
455: update AMS_VENUES_TL set
456: VENUE_NAME = X_VENUE_NAME,
457: DESCRIPTION = X_DESCRIPTION,
458: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
459: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 474: delete from AMS_VENUES_TL

470: procedure DELETE_ROW (
471: X_VENUE_ID in NUMBER
472: ) is
473: begin
474: delete from AMS_VENUES_TL
475: where VENUE_ID = X_VENUE_ID;
476:
477: if (sql%notfound) then
478: raise no_data_found;

Line 492: delete from AMS_VENUES_TL T

488:
489: procedure ADD_LANGUAGE
490: is
491: begin
492: delete from AMS_VENUES_TL T
493: where not exists
494: (select NULL
495: from AMS_VENUES_B B
496: where B.VENUE_ID = T.VENUE_ID

Line 499: update AMS_VENUES_TL T set (

495: from AMS_VENUES_B B
496: where B.VENUE_ID = T.VENUE_ID
497: );
498:
499: update AMS_VENUES_TL T set (
500: VENUE_NAME,
501: DESCRIPTION
502: ) = (select
503: B.VENUE_NAME,

Line 505: from AMS_VENUES_TL B

501: DESCRIPTION
502: ) = (select
503: B.VENUE_NAME,
504: B.DESCRIPTION
505: from AMS_VENUES_TL B
506: where B.VENUE_ID = T.VENUE_ID
507: and B.LANGUAGE = T.SOURCE_LANG)
508: where (
509: T.VENUE_ID,

Line 514: from AMS_VENUES_TL SUBB, AMS_VENUES_TL SUBT

510: T.LANGUAGE
511: ) in (select
512: SUBT.VENUE_ID,
513: SUBT.LANGUAGE
514: from AMS_VENUES_TL SUBB, AMS_VENUES_TL SUBT
515: where SUBB.VENUE_ID = SUBT.VENUE_ID
516: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
517: and (SUBB.VENUE_NAME <> SUBT.VENUE_NAME
518: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 523: insert into AMS_VENUES_TL (

519: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
520: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
521: ));
522:
523: insert into AMS_VENUES_TL (
524: --SECURITY_GROUP_ID,
525: VENUE_ID,
526: LAST_UPDATE_DATE,
527: LAST_UPDATED_BY,

Line 547: from AMS_VENUES_TL B, FND_LANGUAGES L

543: B.VENUE_NAME,
544: B.DESCRIPTION,
545: L.LANGUAGE_CODE,
546: B.SOURCE_LANG
547: from AMS_VENUES_TL B, FND_LANGUAGES L
548: where L.INSTALLED_FLAG in ('I', 'B')
549: and B.LANGUAGE = userenv('LANG')
550: and not exists
551: (select NULL

Line 552: from AMS_VENUES_TL T

548: where L.INSTALLED_FLAG in ('I', 'B')
549: and B.LANGUAGE = userenv('LANG')
550: and not exists
551: (select NULL
552: from AMS_VENUES_TL T
553: where T.VENUE_ID = B.VENUE_ID
554: and T.LANGUAGE = L.LANGUAGE_CODE);
555: end ADD_LANGUAGE;
556:

Line 564: update AMS_VENUES_TL set

560: X_DESCRIPTION in VARCHAR2,
561: X_OWNER in VARCHAR2
562: ) IS
563: begin
564: update AMS_VENUES_TL set
565: venue_name = nvl(x_name, venue_name),
566: description = nvl(x_description, description),
567: source_lang = userenv('LANG'),
568: last_update_date = sysdate,