APPS.PA_WORK_TYPES_PKG dependencies on PA_WORK_TYPES_TL

Line 159: insert into PA_WORK_TYPES_TL (

155: );
156: End If;
157: /** End of PJI changes **/
158:
159: insert into PA_WORK_TYPES_TL (
160: WORK_TYPE_ID,
161: NAME,
162: DESCRIPTION,
163: CREATION_DATE,

Line 185: from PA_WORK_TYPES_TL T

181: from FND_LANGUAGES L
182: where L.INSTALLED_FLAG in ('I', 'B')
183: and not exists
184: (select NULL
185: from PA_WORK_TYPES_TL T
186: where T.WORK_TYPE_ID = X_WORK_TYPE_ID
187: and T.LANGUAGE = L.LANGUAGE_CODE);
188:
189: open c;

Line 274: from PA_WORK_TYPES_TL

270: cursor c1 is select
271: NAME,
272: DESCRIPTION,
273: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
274: from PA_WORK_TYPES_TL
275: where WORK_TYPE_ID = X_WORK_TYPE_ID
276: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
277: for update of WORK_TYPE_ID nowait;
278:

Line 514: update PA_WORK_TYPES_TL set

510: end if;
511:
512:
513:
514: update PA_WORK_TYPES_TL set
515: NAME = X_NAME,
516: DESCRIPTION = X_DESCRIPTION,
517: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
518: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 570: delete from PA_WORK_TYPES_TL

566: OPEN old_worktype_values;
567: FETCH old_worktype_values INTO l_wt_old;
568: IF old_worktype_values%FOUND then
569:
570: delete from PA_WORK_TYPES_TL
571: where WORK_TYPE_ID = X_WORK_TYPE_ID;
572:
573: l_sql_rowcount := sql%rowcount ;
574:

Line 640: delete from PA_WORK_TYPES_TL T

636: is
637:
638: begin
639:
640: delete from PA_WORK_TYPES_TL T
641: where not exists
642: (select NULL
643: from PA_WORK_TYPES_B B
644: where B.WORK_TYPE_ID = T.WORK_TYPE_ID

Line 647: update PA_WORK_TYPES_TL T set (

643: from PA_WORK_TYPES_B B
644: where B.WORK_TYPE_ID = T.WORK_TYPE_ID
645: );
646:
647: update PA_WORK_TYPES_TL T set (
648: NAME,
649: DESCRIPTION
650: ) = (select
651: B.NAME,

Line 653: from PA_WORK_TYPES_TL B

649: DESCRIPTION
650: ) = (select
651: B.NAME,
652: B.DESCRIPTION
653: from PA_WORK_TYPES_TL B
654: where B.WORK_TYPE_ID = T.WORK_TYPE_ID
655: and B.LANGUAGE = T.SOURCE_LANG)
656: where (
657: T.WORK_TYPE_ID,

Line 662: from PA_WORK_TYPES_TL SUBB, PA_WORK_TYPES_TL SUBT

658: T.LANGUAGE
659: ) in (select
660: SUBT.WORK_TYPE_ID,
661: SUBT.LANGUAGE
662: from PA_WORK_TYPES_TL SUBB, PA_WORK_TYPES_TL SUBT
663: where SUBB.WORK_TYPE_ID = SUBT.WORK_TYPE_ID
664: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
665: and (SUBB.NAME <> SUBT.NAME
666: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 671: insert into PA_WORK_TYPES_TL (

667: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
668: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
669: ));
670:
671: insert into PA_WORK_TYPES_TL (
672: WORK_TYPE_ID,
673: NAME,
674: DESCRIPTION,
675: CREATION_DATE,

Line 693: from PA_WORK_TYPES_TL B, FND_LANGUAGES L

689: B.LAST_UPDATED_BY,
690: B.LAST_UPDATE_LOGIN,
691: L.LANGUAGE_CODE,
692: B.SOURCE_LANG
693: from PA_WORK_TYPES_TL B, FND_LANGUAGES L
694: where L.INSTALLED_FLAG in ('I', 'B')
695: and B.LANGUAGE = userenv('LANG')
696: and not exists
697: (select NULL

Line 698: from PA_WORK_TYPES_TL T

694: where L.INSTALLED_FLAG in ('I', 'B')
695: and B.LANGUAGE = userenv('LANG')
696: and not exists
697: (select NULL
698: from PA_WORK_TYPES_TL T
699: where T.WORK_TYPE_ID = B.WORK_TYPE_ID
700: and T.LANGUAGE = L.LANGUAGE_CODE);
701: end ADD_LANGUAGE;
702: