APPS.PA_CI_TYPES_PKG dependencies on PA_CI_TYPES_TL

Line 160: insert into PA_CI_TYPES_TL (

156: X_SUPP_COST_REG_FLAG,
157: X_DIR_REG_REV_COL_FLAG
158: );
159:
160: insert into PA_CI_TYPES_TL (
161: CI_TYPE_ID,
162: NAME,
163: SHORT_NAME,
164: LAST_UPDATED_BY,

Line 188: from PA_CI_TYPES_TL T

184: from FND_LANGUAGES L
185: where L.INSTALLED_FLAG in ('I', 'B')
186: and not exists
187: (select NULL
188: from PA_CI_TYPES_TL T
189: where T.CI_TYPE_ID = X_CI_TYPE_ID
190: and T.LANGUAGE = L.LANGUAGE_CODE);
191:
192: open c;

Line 305: from PA_CI_TYPES_TL

301: NAME,
302: SHORT_NAME,
303: DESCRIPTION,
304: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
305: from PA_CI_TYPES_TL
306: where CI_TYPE_ID = X_CI_TYPE_ID
307: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
308: for update of CI_TYPE_ID nowait;
309: begin

Line 513: update PA_CI_TYPES_TL set

509: if (sql%notfound) then
510: raise no_data_found;
511: end if;
512:
513: update PA_CI_TYPES_TL set
514: NAME = X_NAME,
515: SHORT_NAME = X_SHORT_NAME,
516: DESCRIPTION = X_DESCRIPTION,
517: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 533: delete from PA_CI_TYPES_TL

529: procedure DELETE_ROW (
530: X_CI_TYPE_ID in NUMBER
531: ) is
532: begin
533: delete from PA_CI_TYPES_TL
534: where CI_TYPE_ID = X_CI_TYPE_ID;
535:
536: if (sql%notfound) then
537: raise no_data_found;

Line 551: delete from PA_CI_TYPES_TL T

547:
548: procedure ADD_LANGUAGE
549: is
550: begin
551: delete from PA_CI_TYPES_TL T
552: where not exists
553: (select NULL
554: from PA_CI_TYPES_B B
555: where B.CI_TYPE_ID = T.CI_TYPE_ID

Line 558: update PA_CI_TYPES_TL T set (

554: from PA_CI_TYPES_B B
555: where B.CI_TYPE_ID = T.CI_TYPE_ID
556: );
557:
558: update PA_CI_TYPES_TL T set (
559: NAME,
560: SHORT_NAME,
561: DESCRIPTION
562: ) = (select

Line 566: from PA_CI_TYPES_TL B

562: ) = (select
563: B.NAME,
564: B.SHORT_NAME,
565: B.DESCRIPTION
566: from PA_CI_TYPES_TL B
567: where B.CI_TYPE_ID = T.CI_TYPE_ID
568: and B.LANGUAGE = T.SOURCE_LANG)
569: where (
570: T.CI_TYPE_ID,

Line 575: from PA_CI_TYPES_TL SUBB, PA_CI_TYPES_TL SUBT

571: T.LANGUAGE
572: ) in (select
573: SUBT.CI_TYPE_ID,
574: SUBT.LANGUAGE
575: from PA_CI_TYPES_TL SUBB, PA_CI_TYPES_TL SUBT
576: where SUBB.CI_TYPE_ID = SUBT.CI_TYPE_ID
577: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
578: and (SUBB.NAME <> SUBT.NAME
579: or SUBB.SHORT_NAME <> SUBT.SHORT_NAME

Line 585: insert into PA_CI_TYPES_TL (

581: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
582: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
583: ));
584:
585: insert into PA_CI_TYPES_TL (
586: CI_TYPE_ID,
587: NAME,
588: SHORT_NAME,
589: LAST_UPDATED_BY,

Line 609: from PA_CI_TYPES_TL B, FND_LANGUAGES L

605: B.LAST_UPDATE_LOGIN,
606: B.DESCRIPTION,
607: L.LANGUAGE_CODE,
608: B.SOURCE_LANG
609: from PA_CI_TYPES_TL B, FND_LANGUAGES L
610: where L.INSTALLED_FLAG in ('I', 'B')
611: and B.LANGUAGE = userenv('LANG')
612: and not exists
613: (select NULL

Line 614: from PA_CI_TYPES_TL T

610: where L.INSTALLED_FLAG in ('I', 'B')
611: and B.LANGUAGE = userenv('LANG')
612: and not exists
613: (select NULL
614: from PA_CI_TYPES_TL T
615: where T.CI_TYPE_ID = B.CI_TYPE_ID
616: and T.LANGUAGE = L.LANGUAGE_CODE);
617: end ADD_LANGUAGE;
618: