APPS.AMS_VENUE_RATES_B_PKG dependencies on AMS_VENUE_RATES_TL

Line 156: INSERT INTO ams_venue_rates_tl(

152: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
153: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
154:
155:
156: INSERT INTO ams_venue_rates_tl(
157: rate_id,
158: last_update_date,
159: last_updated_by,
160: creation_date,

Line 180: from ams_venue_rates_tl T

176: from FND_LANGUAGES L
177: where L.INSTALLED_FLAG in ('I', 'B')
178: and not exists
179: (select NULL
180: from ams_venue_rates_tl T
181: where T.rate_ID = px_rate_id
182: and T.LANGUAGE = L.LANGUAGE_CODE);
183:
184: open c;

Line 290: update AMS_VENUE_RATES_TL

286: IF (SQL%NOTFOUND) THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289:
290: update AMS_VENUE_RATES_TL
291: set
292: last_update_date=DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
293: last_updated_by=DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
294: creation_date=DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 509: delete from AMS_VENUE_RATES_TL T

505:
506: procedure ADD_LANGUAGE
507: is
508: begin
509: delete from AMS_VENUE_RATES_TL T
510: where not exists
511: (select NULL
512: from AMS_VENUE_RATES_B B
513: where B.RATE_ID = T.RATE_ID

Line 516: update AMS_VENUE_RATES_TL T set (

512: from AMS_VENUE_RATES_B B
513: where B.RATE_ID = T.RATE_ID
514: );
515:
516: update AMS_VENUE_RATES_TL T set (
517: DESCRIPTION
518: ) = (select
519: B.DESCRIPTION
520: from AMS_VENUE_RATES_TL B

Line 520: from AMS_VENUE_RATES_TL B

516: update AMS_VENUE_RATES_TL T set (
517: DESCRIPTION
518: ) = (select
519: B.DESCRIPTION
520: from AMS_VENUE_RATES_TL B
521: where B.RATE_ID = T.RATE_ID
522: and B.LANGUAGE = T.SOURCE_LANG)
523: where (
524: T.RATE_ID,

Line 529: from AMS_VENUE_RATES_TL SUBB, AMS_VENUE_RATES_TL SUBT

525: T.LANGUAGE
526: ) in (select
527: SUBT.RATE_ID,
528: SUBT.LANGUAGE
529: from AMS_VENUE_RATES_TL SUBB, AMS_VENUE_RATES_TL SUBT
530: where SUBB.RATE_ID = SUBT.RATE_ID
531: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
532: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
533: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 537: insert into AMS_VENUE_RATES_TL (

533: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
534: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
535: ));
536:
537: insert into AMS_VENUE_RATES_TL (
538: RATE_ID,
539: LANGUAGE,
540: CREATION_DATE,
541: CREATED_BY,

Line 559: from AMS_VENUE_RATES_TL B, FND_LANGUAGES L

555: B.LAST_UPDATE_LOGIN,
556: B.SOURCE_LANG,
557: B.DESCRIPTION,
558: B.SECURITY_GROUP_ID
559: from AMS_VENUE_RATES_TL B, FND_LANGUAGES L
560: where L.INSTALLED_FLAG in ('I', 'B')
561: and B.LANGUAGE = userenv('LANG')
562: and not exists
563: (select NULL

Line 564: from AMS_VENUE_RATES_TL T

560: where L.INSTALLED_FLAG in ('I', 'B')
561: and B.LANGUAGE = userenv('LANG')
562: and not exists
563: (select NULL
564: from AMS_VENUE_RATES_TL T
565: where T.RATE_ID = B.RATE_ID
566: and T.LANGUAGE = L.LANGUAGE_CODE);
567: end ADD_LANGUAGE;
568: