eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_CP_SERVICES_PKG dependencies on FND_CP_SERVICES

Line 1: package body FND_CP_SERVICES_PKG as

1: package body FND_CP_SERVICES_PKG as
2: /* $Header: AFCPSERB.pls 120.2 2005/08/19 14:34:23 susghosh ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_SERVICE_ID in NUMBER,

Line 41: cursor C is select ROWID from FND_CP_SERVICES

37: X_LAST_UPDATE_DATE in DATE,
38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER
40: ) is
41: cursor C is select ROWID from FND_CP_SERVICES
42: where SERVICE_ID = X_SERVICE_ID
43: ;
44: begin
45: insert into FND_CP_SERVICES (

Line 45: insert into FND_CP_SERVICES (

41: cursor C is select ROWID from FND_CP_SERVICES
42: where SERVICE_ID = X_SERVICE_ID
43: ;
44: begin
45: insert into FND_CP_SERVICES (
46: DEBUG_TYPE,
47: DEBUG_CHANGE_ACTION,
48: ALLOW_MULTIPLE_PROC_SI,
49: DEFAULT_DEBUG_LEVEL,

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 214: from FND_CP_SERVICES

210: ALLOW_RESTART,
211: PARAMETER_CHANGE_ACTION,
212: DEVELOPER_PARAMETERS,
213: ENV_FILE_NAME
214: from FND_CP_SERVICES
215: where SERVICE_ID = X_SERVICE_ID
216: for update of SERVICE_ID nowait;
217: recinfo c%rowtype;
218:

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 334: update FND_CP_SERVICES set

330: X_LAST_UPDATED_BY in NUMBER,
331: X_LAST_UPDATE_LOGIN in NUMBER
332: ) is
333: begin
334: update FND_CP_SERVICES set
335: DEBUG_TYPE = X_DEBUG_TYPE,
336: DEBUG_CHANGE_ACTION = X_DEBUG_CHANGE_ACTION,
337: ALLOW_MULTIPLE_PROC_SI = X_ALLOW_MULTIPLE_PROC_SI,
338: DEFAULT_DEBUG_LEVEL = X_DEFAULT_DEBUG_LEVEL,

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 397: delete from FND_CP_SERVICES

393: if (sql%notfound) then
394: raise no_data_found;
395: end if;
396:
397: delete from FND_CP_SERVICES
398: where SERVICE_ID = X_SERVICE_ID;
399:
400: if (sql%notfound) then
401: 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 418: from FND_CP_SERVICES B

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
420: );
421:
422: update FND_CP_SERVICES_TL T set (

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:

Line 486: end FND_CP_SERVICES_PKG;

482: where T.SERVICE_ID = B.SERVICE_ID
483: and T.LANGUAGE = L.LANGUAGE_CODE);
484: end ADD_LANGUAGE;
485:
486: end FND_CP_SERVICES_PKG;