APPS.AMS_WEB_PLCE_MP_PKG dependencies on AMS_WEB_PLCE_MP_TL

Line 113: insert into AMS_WEB_PLCE_MP_TL (

109: X_LAST_UPDATE_DATE,
110: X_LAST_UPDATED_BY,
111: X_LAST_UPDATE_LOGIN
112: );
113: insert into AMS_WEB_PLCE_MP_TL (
114: CREATED_BY,
115: CREATION_DATE,
116: LAST_UPDATED_BY,
117: LAST_UPDATE_DATE,

Line 141: from AMS_WEB_PLCE_MP_TL T

137: from FND_LANGUAGES L
138: where L.INSTALLED_FLAG in ('I', 'B')
139: and not exists
140: (select NULL
141: from AMS_WEB_PLCE_MP_TL T
142: where T.PLACEMENT_MP_ID = X_PLACEMENT_MP_ID
143: and T.LANGUAGE = L.LANGUAGE_CODE);
144:
145: open c;

Line 222: from AMS_WEB_PLCE_MP_TL

218:
219: cursor c1 is select
220: PLACEMENT_MP_TITLE,
221: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
222: from AMS_WEB_PLCE_MP_TL
223: where PLACEMENT_MP_ID = X_PLACEMENT_MP_ID
224: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
225: for update of PLACEMENT_MP_ID nowait;
226: begin

Line 378: update AMS_WEB_PLCE_MP_TL set

374: if (sql%notfound) then
375: raise no_data_found;
376: end if;
377:
378: update AMS_WEB_PLCE_MP_TL set
379: PLACEMENT_MP_TITLE = X_PLACEMENT_MP_TITLE,
380: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
381: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
382: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 396: delete from AMS_WEB_PLCE_MP_TL

392: procedure DELETE_ROW (
393: X_PLACEMENT_MP_ID in NUMBER
394: ) is
395: begin
396: delete from AMS_WEB_PLCE_MP_TL
397: where PLACEMENT_MP_ID = X_PLACEMENT_MP_ID;
398:
399: if (sql%notfound) then
400: raise no_data_found;

Line 414: delete from AMS_WEB_PLCE_MP_TL T

410:
411: procedure ADD_LANGUAGE
412: is
413: begin
414: delete from AMS_WEB_PLCE_MP_TL T
415: where not exists
416: (select NULL
417: from AMS_WEB_PLCE_MP_B B
418: where B.PLACEMENT_MP_ID = T.PLACEMENT_MP_ID

Line 421: update AMS_WEB_PLCE_MP_TL T set (

417: from AMS_WEB_PLCE_MP_B B
418: where B.PLACEMENT_MP_ID = T.PLACEMENT_MP_ID
419: );
420:
421: update AMS_WEB_PLCE_MP_TL T set (
422: PLACEMENT_MP_TITLE
423: ) = (select
424: B.PLACEMENT_MP_TITLE
425: from AMS_WEB_PLCE_MP_TL B

Line 425: from AMS_WEB_PLCE_MP_TL B

421: update AMS_WEB_PLCE_MP_TL T set (
422: PLACEMENT_MP_TITLE
423: ) = (select
424: B.PLACEMENT_MP_TITLE
425: from AMS_WEB_PLCE_MP_TL B
426: where B.PLACEMENT_MP_ID = T.PLACEMENT_MP_ID
427: and B.LANGUAGE = T.SOURCE_LANG)
428: where (
429: T.PLACEMENT_MP_ID,

Line 434: from AMS_WEB_PLCE_MP_TL SUBB, AMS_WEB_PLCE_MP_TL SUBT

430: T.LANGUAGE
431: ) in (select
432: SUBT.PLACEMENT_MP_ID,
433: SUBT.LANGUAGE
434: from AMS_WEB_PLCE_MP_TL SUBB, AMS_WEB_PLCE_MP_TL SUBT
435: where SUBB.PLACEMENT_MP_ID = SUBT.PLACEMENT_MP_ID
436: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
437: and (SUBB.PLACEMENT_MP_TITLE <> SUBT.PLACEMENT_MP_TITLE
438: ));

Line 440: insert into AMS_WEB_PLCE_MP_TL (

436: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
437: and (SUBB.PLACEMENT_MP_TITLE <> SUBT.PLACEMENT_MP_TITLE
438: ));
439:
440: insert into AMS_WEB_PLCE_MP_TL (
441: CREATED_BY,
442: CREATION_DATE,
443: LAST_UPDATED_BY,
444: LAST_UPDATE_DATE,

Line 464: from AMS_WEB_PLCE_MP_TL B, FND_LANGUAGES L

460: B.PLACEMENT_MP_ID,
461: B.PLACEMENT_MP_TITLE,
462: L.LANGUAGE_CODE,
463: B.SOURCE_LANG
464: from AMS_WEB_PLCE_MP_TL B, FND_LANGUAGES L
465: where L.INSTALLED_FLAG in ('I', 'B')
466: and B.LANGUAGE = userenv('LANG')
467: and not exists
468: (select NULL

Line 469: from AMS_WEB_PLCE_MP_TL T

465: where L.INSTALLED_FLAG in ('I', 'B')
466: and B.LANGUAGE = userenv('LANG')
467: and not exists
468: (select NULL
469: from AMS_WEB_PLCE_MP_TL T
470: where T.PLACEMENT_MP_ID = B.PLACEMENT_MP_ID
471: and T.LANGUAGE = L.LANGUAGE_CODE);
472: end ADD_LANGUAGE;
473: