APPS.PA_CI_TYPES_PKG dependencies on PA_CI_TYPES_TL

Line 123: insert into PA_CI_TYPES_TL (

119: X_LAST_UPDATED_BY,
120: X_LAST_UPDATE_LOGIN
121: );
122:
123: insert into PA_CI_TYPES_TL (
124: CI_TYPE_ID,
125: NAME,
126: SHORT_NAME,
127: LAST_UPDATED_BY,

Line 151: from PA_CI_TYPES_TL T

147: from FND_LANGUAGES L
148: where L.INSTALLED_FLAG in ('I', 'B')
149: and not exists
150: (select NULL
151: from PA_CI_TYPES_TL T
152: where T.CI_TYPE_ID = X_CI_TYPE_ID
153: and T.LANGUAGE = L.LANGUAGE_CODE);
154:
155: open c;

Line 243: from PA_CI_TYPES_TL

239: NAME,
240: SHORT_NAME,
241: DESCRIPTION,
242: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
243: from PA_CI_TYPES_TL
244: where CI_TYPE_ID = X_CI_TYPE_ID
245: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
246: for update of CI_TYPE_ID nowait;
247: begin

Line 404: update PA_CI_TYPES_TL set

400: if (sql%notfound) then
401: raise no_data_found;
402: end if;
403:
404: update PA_CI_TYPES_TL set
405: NAME = X_NAME,
406: SHORT_NAME = X_SHORT_NAME,
407: DESCRIPTION = X_DESCRIPTION,
408: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 424: delete from PA_CI_TYPES_TL

420: procedure DELETE_ROW (
421: X_CI_TYPE_ID in NUMBER
422: ) is
423: begin
424: delete from PA_CI_TYPES_TL
425: where CI_TYPE_ID = X_CI_TYPE_ID;
426:
427: if (sql%notfound) then
428: raise no_data_found;

Line 442: delete from PA_CI_TYPES_TL T

438:
439: procedure ADD_LANGUAGE
440: is
441: begin
442: delete from PA_CI_TYPES_TL T
443: where not exists
444: (select NULL
445: from PA_CI_TYPES_B B
446: where B.CI_TYPE_ID = T.CI_TYPE_ID

Line 449: update PA_CI_TYPES_TL T set (

445: from PA_CI_TYPES_B B
446: where B.CI_TYPE_ID = T.CI_TYPE_ID
447: );
448:
449: update PA_CI_TYPES_TL T set (
450: NAME,
451: SHORT_NAME,
452: DESCRIPTION
453: ) = (select

Line 457: from PA_CI_TYPES_TL B

453: ) = (select
454: B.NAME,
455: B.SHORT_NAME,
456: B.DESCRIPTION
457: from PA_CI_TYPES_TL B
458: where B.CI_TYPE_ID = T.CI_TYPE_ID
459: and B.LANGUAGE = T.SOURCE_LANG)
460: where (
461: T.CI_TYPE_ID,

Line 466: from PA_CI_TYPES_TL SUBB, PA_CI_TYPES_TL SUBT

462: T.LANGUAGE
463: ) in (select
464: SUBT.CI_TYPE_ID,
465: SUBT.LANGUAGE
466: from PA_CI_TYPES_TL SUBB, PA_CI_TYPES_TL SUBT
467: where SUBB.CI_TYPE_ID = SUBT.CI_TYPE_ID
468: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
469: and (SUBB.NAME <> SUBT.NAME
470: or SUBB.SHORT_NAME <> SUBT.SHORT_NAME

Line 476: insert into PA_CI_TYPES_TL (

472: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
473: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
474: ));
475:
476: insert into PA_CI_TYPES_TL (
477: CI_TYPE_ID,
478: NAME,
479: SHORT_NAME,
480: LAST_UPDATED_BY,

Line 500: from PA_CI_TYPES_TL B, FND_LANGUAGES L

496: B.LAST_UPDATE_LOGIN,
497: B.DESCRIPTION,
498: L.LANGUAGE_CODE,
499: B.SOURCE_LANG
500: from PA_CI_TYPES_TL B, FND_LANGUAGES L
501: where L.INSTALLED_FLAG in ('I', 'B')
502: and B.LANGUAGE = userenv('LANG')
503: and not exists
504: (select NULL

Line 505: from PA_CI_TYPES_TL T

501: where L.INSTALLED_FLAG in ('I', 'B')
502: and B.LANGUAGE = userenv('LANG')
503: and not exists
504: (select NULL
505: from PA_CI_TYPES_TL T
506: where T.CI_TYPE_ID = B.CI_TYPE_ID
507: and T.LANGUAGE = L.LANGUAGE_CODE);
508: end ADD_LANGUAGE;
509: