APPS.AMS_WEB_PLACEMENTS_PKG dependencies on AMS_WEB_PLACEMENTS_TL

Line 142: insert into AMS_WEB_PLACEMENTS_TL (

138: X_LAST_UPDATED_BY,
139: X_LAST_UPDATE_LOGIN
140: );
141:
142: insert into AMS_WEB_PLACEMENTS_TL (
143: PLACEMENT_ID,
144: PLACEMENT_NAME,
145: DESCRIPTION,
146: CREATED_BY,

Line 172: from AMS_WEB_PLACEMENTS_TL T

168: from FND_LANGUAGES L
169: where L.INSTALLED_FLAG in ('I', 'B')
170: and not exists
171: (select NULL
172: from AMS_WEB_PLACEMENTS_TL T
173: where T.PLACEMENT_ID = X_PLACEMENT_ID
174: and T.LANGUAGE = L.LANGUAGE_CODE);
175:
176: open c;

Line 273: from AMS_WEB_PLACEMENTS_TL

269: cursor c1 is select
270: PLACEMENT_NAME,
271: DESCRIPTION,
272: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
273: from AMS_WEB_PLACEMENTS_TL
274: where PLACEMENT_ID = X_PLACEMENT_ID
275: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
276: for update of PLACEMENT_ID nowait;
277: begin

Line 467: update AMS_WEB_PLACEMENTS_TL set

463: if (sql%notfound) then
464: raise no_data_found;
465: end if;
466:
467: update AMS_WEB_PLACEMENTS_TL set
468: PLACEMENT_NAME = X_PLACEMENT_NAME,
469: DESCRIPTION = X_DESCRIPTION,
470: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
471: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 486: delete from AMS_WEB_PLACEMENTS_TL

482: procedure DELETE_ROW (
483: X_PLACEMENT_ID in NUMBER
484: ) is
485: begin
486: delete from AMS_WEB_PLACEMENTS_TL
487: where PLACEMENT_ID = X_PLACEMENT_ID;
488:
489: if (sql%notfound) then
490: raise no_data_found;

Line 504: delete from AMS_WEB_PLACEMENTS_TL T

500:
501: procedure ADD_LANGUAGE
502: is
503: begin
504: delete from AMS_WEB_PLACEMENTS_TL T
505: where not exists
506: (select NULL
507: from AMS_WEB_PLACEMENTS_B B
508: where B.PLACEMENT_ID = T.PLACEMENT_ID

Line 511: update AMS_WEB_PLACEMENTS_TL T set (

507: from AMS_WEB_PLACEMENTS_B B
508: where B.PLACEMENT_ID = T.PLACEMENT_ID
509: );
510:
511: update AMS_WEB_PLACEMENTS_TL T set (
512: PLACEMENT_NAME,
513: DESCRIPTION
514: ) = (select
515: B.PLACEMENT_NAME,

Line 517: from AMS_WEB_PLACEMENTS_TL B

513: DESCRIPTION
514: ) = (select
515: B.PLACEMENT_NAME,
516: B.DESCRIPTION
517: from AMS_WEB_PLACEMENTS_TL B
518: where B.PLACEMENT_ID = T.PLACEMENT_ID
519: and B.LANGUAGE = T.SOURCE_LANG)
520: where (
521: T.PLACEMENT_ID,

Line 526: from AMS_WEB_PLACEMENTS_TL SUBB, AMS_WEB_PLACEMENTS_TL SUBT

522: T.LANGUAGE
523: ) in (select
524: SUBT.PLACEMENT_ID,
525: SUBT.LANGUAGE
526: from AMS_WEB_PLACEMENTS_TL SUBB, AMS_WEB_PLACEMENTS_TL SUBT
527: where SUBB.PLACEMENT_ID = SUBT.PLACEMENT_ID
528: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
529: and (SUBB.PLACEMENT_NAME <> SUBT.PLACEMENT_NAME
530: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 535: insert into AMS_WEB_PLACEMENTS_TL (

531: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
532: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
533: ));
534:
535: insert into AMS_WEB_PLACEMENTS_TL (
536: PLACEMENT_ID,
537: PLACEMENT_NAME,
538: DESCRIPTION,
539: CREATED_BY,

Line 561: from AMS_WEB_PLACEMENTS_TL B, FND_LANGUAGES L

557: B.SECURITY_GROUP_ID,
558: B.OBJECT_VERSION_NUMBER,
559: L.LANGUAGE_CODE,
560: B.SOURCE_LANG
561: from AMS_WEB_PLACEMENTS_TL B, FND_LANGUAGES L
562: where L.INSTALLED_FLAG in ('I', 'B')
563: and B.LANGUAGE = userenv('LANG')
564: and not exists
565: (select NULL

Line 566: from AMS_WEB_PLACEMENTS_TL T

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