APPS.FND_CP_SERVICES_PKG dependencies on FND_CP_SERVICES_TL

Line 113: insert into FND_CP_SERVICES_TL (

109: X_LAST_UPDATED_BY,
110: X_LAST_UPDATE_LOGIN
111: );
112:
113: insert into FND_CP_SERVICES_TL (
114: SERVICE_PLURAL_NAME,
115: CREATION_DATE,
116: CREATED_BY,
117: DESCRIPTION,

Line 141: from FND_CP_SERVICES_TL T

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

Line 224: from FND_CP_SERVICES_TL

220: SERVICE_NAME,
221: DESCRIPTION,
222: SERVICE_PLURAL_NAME,
223: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
224: from FND_CP_SERVICES_TL
225: where SERVICE_ID = X_SERVICE_ID
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
227: for update of SERVICE_ID nowait;
228: begin

Line 370: update FND_CP_SERVICES_TL set

366: if (sql%notfound) then
367: raise no_data_found;
368: end if;
369:
370: update FND_CP_SERVICES_TL set
371: SERVICE_NAME = X_SERVICE_NAME,
372: DESCRIPTION = X_DESCRIPTION,
373: SERVICE_PLURAL_NAME = X_SERVICE_PLURAL_NAME,
374: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 390: delete from FND_CP_SERVICES_TL

386: procedure DELETE_ROW (
387: X_SERVICE_ID in NUMBER
388: ) is
389: begin
390: delete from FND_CP_SERVICES_TL
391: where SERVICE_ID = X_SERVICE_ID;
392:
393: if (sql%notfound) then
394: raise no_data_found;

Line 415: delete from FND_CP_SERVICES_TL T

411: /* as a quick workaround to fix the time-consuming table handler issue */
412: /* Eventually we'll need to turn them into a separate fix_language procedure */
413: /*
414:
415: delete from FND_CP_SERVICES_TL T
416: where not exists
417: (select NULL
418: from FND_CP_SERVICES B
419: where B.SERVICE_ID = T.SERVICE_ID

Line 422: update FND_CP_SERVICES_TL T set (

418: from FND_CP_SERVICES B
419: where B.SERVICE_ID = T.SERVICE_ID
420: );
421:
422: update FND_CP_SERVICES_TL T set (
423: SERVICE_NAME,
424: DESCRIPTION,
425: SERVICE_PLURAL_NAME
426: ) = (select

Line 430: from FND_CP_SERVICES_TL B

426: ) = (select
427: B.SERVICE_NAME,
428: B.DESCRIPTION,
429: B.SERVICE_PLURAL_NAME
430: from FND_CP_SERVICES_TL B
431: where B.SERVICE_ID = T.SERVICE_ID
432: and B.LANGUAGE = T.SOURCE_LANG)
433: where (
434: T.SERVICE_ID,

Line 439: from FND_CP_SERVICES_TL SUBB, FND_CP_SERVICES_TL SUBT

435: T.LANGUAGE
436: ) in (select
437: SUBT.SERVICE_ID,
438: SUBT.LANGUAGE
439: from FND_CP_SERVICES_TL SUBB, FND_CP_SERVICES_TL SUBT
440: where SUBB.SERVICE_ID = SUBT.SERVICE_ID
441: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
442: and (SUBB.SERVICE_NAME <> SUBT.SERVICE_NAME
443: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 452: insert into FND_CP_SERVICES_TL (

448: or (SUBB.SERVICE_PLURAL_NAME is not null and SUBT.SERVICE_PLURAL_NAME is null)
449: ));
450: */
451:
452: insert into FND_CP_SERVICES_TL (
453: SERVICE_PLURAL_NAME,
454: CREATION_DATE,
455: CREATED_BY,
456: DESCRIPTION,

Line 476: from FND_CP_SERVICES_TL B, FND_LANGUAGES L

472: B.SERVICE_ID,
473: B.SERVICE_NAME,
474: L.LANGUAGE_CODE,
475: B.SOURCE_LANG
476: from FND_CP_SERVICES_TL B, FND_LANGUAGES L
477: where L.INSTALLED_FLAG in ('I', 'B')
478: and B.LANGUAGE = userenv('LANG')
479: and not exists
480: (select NULL

Line 481: from FND_CP_SERVICES_TL T

477: where L.INSTALLED_FLAG in ('I', 'B')
478: and B.LANGUAGE = userenv('LANG')
479: and not exists
480: (select NULL
481: from FND_CP_SERVICES_TL T
482: where T.SERVICE_ID = B.SERVICE_ID
483: and T.LANGUAGE = L.LANGUAGE_CODE);
484: end ADD_LANGUAGE;
485: