APPS.CSD_SERVICE_CODES_PKG dependencies on CSD_SERVICE_CODES_TL

Line 101: insert into CSD_SERVICE_CODES_TL (

97: P_ATTRIBUTE13,
98: P_ATTRIBUTE14,
99: P_ATTRIBUTE15 );
100:
101: insert into CSD_SERVICE_CODES_TL (
102: SERVICE_CODE_ID,
103: CREATED_BY,
104: CREATION_DATE,
105: LAST_UPDATED_BY,

Line 127: from CSD_SERVICE_CODES_TL T

123: from FND_LANGUAGES L
124: where L.INSTALLED_FLAG in ('I', 'B')
125: and not exists
126: (select NULL
127: from CSD_SERVICE_CODES_TL T
128: where T.SERVICE_CODE_ID = PX_SERVICE_CODE_ID
129: and T.LANGUAGE = L.LANGUAGE_CODE);
130:
131: open c;

Line 210: from CSD_SERVICE_CODES_TL

206: cursor c1 is select
207: NAME,
208: DESCRIPTION,
209: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
210: from CSD_SERVICE_CODES_TL
211: where SERVICE_CODE_ID = P_SERVICE_CODE_ID
212: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
213: for update of SERVICE_CODE_ID nowait;
214: */

Line 367: update CSD_SERVICE_CODES_TL set

363: if (sql%notfound) then
364: raise no_data_found;
365: end if;
366:
367: update CSD_SERVICE_CODES_TL set
368: CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
369: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
370: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
371: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)

Line 388: delete from CSD_SERVICE_CODES_TL

384: procedure DELETE_ROW (
385: P_SERVICE_CODE_ID in NUMBER
386: ) is
387: begin
388: delete from CSD_SERVICE_CODES_TL
389: where SERVICE_CODE_ID = P_SERVICE_CODE_ID;
390:
391: if (sql%notfound) then
392: raise no_data_found;

Line 406: delete from CSD_SERVICE_CODES_TL T

402:
403: procedure ADD_LANGUAGE
404: is
405: begin
406: delete from CSD_SERVICE_CODES_TL T
407: where not exists
408: (select NULL
409: from CSD_SERVICE_CODES_B B
410: where B.SERVICE_CODE_ID = T.SERVICE_CODE_ID

Line 413: update CSD_SERVICE_CODES_TL T set (

409: from CSD_SERVICE_CODES_B B
410: where B.SERVICE_CODE_ID = T.SERVICE_CODE_ID
411: );
412:
413: update CSD_SERVICE_CODES_TL T set (
414: NAME,
415: DESCRIPTION
416: ) = (select
417: B.NAME,

Line 419: from CSD_SERVICE_CODES_TL B

415: DESCRIPTION
416: ) = (select
417: B.NAME,
418: B.DESCRIPTION
419: from CSD_SERVICE_CODES_TL B
420: where B.SERVICE_CODE_ID = T.SERVICE_CODE_ID
421: and B.LANGUAGE = T.SOURCE_LANG)
422: where (
423: T.SERVICE_CODE_ID,

Line 428: from CSD_SERVICE_CODES_TL SUBB, CSD_SERVICE_CODES_TL SUBT

424: T.LANGUAGE
425: ) in (select
426: SUBT.SERVICE_CODE_ID,
427: SUBT.LANGUAGE
428: from CSD_SERVICE_CODES_TL SUBB, CSD_SERVICE_CODES_TL SUBT
429: where SUBB.SERVICE_CODE_ID = SUBT.SERVICE_CODE_ID
430: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
431: and (SUBB.NAME <> SUBT.NAME
432: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 437: insert into CSD_SERVICE_CODES_TL (

433: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
434: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
435: ));
436:
437: insert into CSD_SERVICE_CODES_TL (
438: SERVICE_CODE_ID,
439: CREATED_BY,
440: CREATION_DATE,
441: LAST_UPDATED_BY,

Line 459: from CSD_SERVICE_CODES_TL B, FND_LANGUAGES L

455: B.NAME,
456: B.DESCRIPTION,
457: L.LANGUAGE_CODE,
458: B.SOURCE_LANG
459: from CSD_SERVICE_CODES_TL B, FND_LANGUAGES L
460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL

Line 464: from CSD_SERVICE_CODES_TL T

460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL
464: from CSD_SERVICE_CODES_TL T
465: where T.SERVICE_CODE_ID = B.SERVICE_CODE_ID
466: and T.LANGUAGE = L.LANGUAGE_CODE);
467: end ADD_LANGUAGE;
468: