APPS.PER_TIME_PERIOD_TYPES_PKG dependencies on PER_TIME_PERIOD_TYPES_TL

Line 180: FROM per_time_period_types_tl ptptl

176:
177: --
178: cursor csr_duplicate is
179: SELECT 1
180: FROM per_time_period_types_tl ptptl
181: WHERE upper(ptptl.display_period_type) = upper(x_display_period_type)
182: AND ptptl.language = x_language
183: AND ( x_period_type is null or ( x_period_type is not null
184: and ptptl.period_type <> x_period_type ) );

Line 340: insert into PER_TIME_PERIOD_TYPES_TL (

336: X_LAST_UPDATED_BY,
337: X_LAST_UPDATE_LOGIN
338: );
339:
340: insert into PER_TIME_PERIOD_TYPES_TL (
341: PERIOD_TYPE,
342: DISPLAY_PERIOD_TYPE,
343: DESCRIPTION,
344: LAST_UPDATE_DATE,

Line 366: from PER_TIME_PERIOD_TYPES_TL T

362: from FND_LANGUAGES L
363: where L.INSTALLED_FLAG in ('I', 'B')
364: and not exists
365: (select NULL
366: from PER_TIME_PERIOD_TYPES_TL T
367: where T.PERIOD_TYPE = X_PERIOD_TYPE
368: and T.LANGUAGE = L.LANGUAGE_CODE);
369:
370: open c;

Line 449: from PER_TIME_PERIOD_TYPES_TL

445: cursor c1 is select
446: DISPLAY_PERIOD_TYPE,
447: DESCRIPTION,
448: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
449: from PER_TIME_PERIOD_TYPES_TL
450: where PERIOD_TYPE = X_PERIOD_TYPE
451: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
452: for update of PERIOD_TYPE nowait;
453:

Line 585: from per_time_period_types_tl

581: ) is
582:
583: cursor chk_source_lang is
584: select 1
585: from per_time_period_types_tl
586: where period_type = x_period_type
587: and source_lang <> userenv('LANG');
588:
589: l_exists number;

Line 653: update PER_TIME_PERIOD_TYPES_TL set

649: DESCRIPTION = X_DESCRIPTION
650: where PERIOD_TYPE = X_PERIOD_TYPE;
651: end if;
652:
653: update PER_TIME_PERIOD_TYPES_TL set
654: DISPLAY_PERIOD_TYPE = X_DISPLAY_PERIOD_TYPE,
655: DESCRIPTION = X_DESCRIPTION,
656: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
657: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 664: insert into PER_TIME_PERIOD_TYPES_TL (

660: where PERIOD_TYPE = X_PERIOD_TYPE
661: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
662:
663: if (sql%notfound) then
664: insert into PER_TIME_PERIOD_TYPES_TL (
665: PERIOD_TYPE,
666: DISPLAY_PERIOD_TYPE,
667: DESCRIPTION,
668: LAST_UPDATE_DATE,

Line 690: from PER_TIME_PERIOD_TYPES_TL T

686: from FND_LANGUAGES L
687: where L.INSTALLED_FLAG in ('I', 'B')
688: and not exists
689: (select NULL
690: from PER_TIME_PERIOD_TYPES_TL T
691: where T.PERIOD_TYPE = X_PERIOD_TYPE
692: and T.LANGUAGE = L.LANGUAGE_CODE);
693: end if;
694:

Line 714: delete from PER_TIME_PERIOD_TYPES_TL

710: if g_debug then
711: hr_utility.set_location( 'Entering : ' || l_proc , 1);
712: end if;
713:
714: delete from PER_TIME_PERIOD_TYPES_TL
715: where PERIOD_TYPE = X_PERIOD_TYPE;
716:
717: if (sql%notfound) then
718: raise no_data_found;

Line 743: delete from PER_TIME_PERIOD_TYPES_TL T

739: if g_debug then
740: hr_utility.set_location( 'Entering : ' || l_proc , 1);
741: end if;
742:
743: delete from PER_TIME_PERIOD_TYPES_TL T
744: where not exists
745: (select NULL
746: from PER_TIME_PERIOD_TYPES B
747: where B.PERIOD_TYPE = T.PERIOD_TYPE

Line 750: update PER_TIME_PERIOD_TYPES_TL T set (

746: from PER_TIME_PERIOD_TYPES B
747: where B.PERIOD_TYPE = T.PERIOD_TYPE
748: );
749:
750: update PER_TIME_PERIOD_TYPES_TL T set (
751: DISPLAY_PERIOD_TYPE,
752: DESCRIPTION
753: ) = (select
754: B.DISPLAY_PERIOD_TYPE,

Line 756: from PER_TIME_PERIOD_TYPES_TL B

752: DESCRIPTION
753: ) = (select
754: B.DISPLAY_PERIOD_TYPE,
755: B.DESCRIPTION
756: from PER_TIME_PERIOD_TYPES_TL B
757: where B.PERIOD_TYPE = T.PERIOD_TYPE
758: and B.LANGUAGE = T.SOURCE_LANG)
759: where (
760: T.PERIOD_TYPE,

Line 765: from PER_TIME_PERIOD_TYPES_TL SUBB, PER_TIME_PERIOD_TYPES_TL SUBT

761: T.LANGUAGE
762: ) in (select
763: SUBT.PERIOD_TYPE,
764: SUBT.LANGUAGE
765: from PER_TIME_PERIOD_TYPES_TL SUBB, PER_TIME_PERIOD_TYPES_TL SUBT
766: where SUBB.PERIOD_TYPE = SUBT.PERIOD_TYPE
767: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
768: and (SUBB.DISPLAY_PERIOD_TYPE <> SUBT.DISPLAY_PERIOD_TYPE
769: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 774: insert into PER_TIME_PERIOD_TYPES_TL (

770: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
771: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
772: ));
773:
774: insert into PER_TIME_PERIOD_TYPES_TL (
775: PERIOD_TYPE,
776: DISPLAY_PERIOD_TYPE,
777: DESCRIPTION,
778: LAST_UPDATE_DATE,

Line 796: from PER_TIME_PERIOD_TYPES_TL B, FND_LANGUAGES L

792: B.CREATED_BY,
793: B.CREATION_DATE,
794: L.LANGUAGE_CODE,
795: B.SOURCE_LANG
796: from PER_TIME_PERIOD_TYPES_TL B, FND_LANGUAGES L
797: where L.INSTALLED_FLAG in ('I', 'B')
798: and B.LANGUAGE = userenv('LANG')
799: and not exists
800: (select NULL

Line 801: from PER_TIME_PERIOD_TYPES_TL T

797: where L.INSTALLED_FLAG in ('I', 'B')
798: and B.LANGUAGE = userenv('LANG')
799: and not exists
800: (select NULL
801: from PER_TIME_PERIOD_TYPES_TL T
802: where T.PERIOD_TYPE = B.PERIOD_TYPE
803: and T.LANGUAGE = L.LANGUAGE_CODE);
804:
805: if g_debug then

Line 1010: from per_time_period_types_tl

1006: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.translate_row';
1007:
1008: cursor chk_source_lang is
1009: select 1
1010: from per_time_period_types_tl
1011: where period_type = x_period_type
1012: and source_lang <> userenv('LANG');
1013: begin
1014:

Line 1030: update PER_TIME_PERIOD_TYPES_TL

1026: X_LAST_UPDATE_DATE => l_LAST_UPDATE_DATE,
1027: X_LAST_UPDATED_BY => l_LAST_UPDATED_BY,
1028: X_LAST_UPDATE_LOGIN => l_LAST_UPDATE_LOGIN );
1029:
1030: update PER_TIME_PERIOD_TYPES_TL
1031: set DESCRIPTION = X_DESCRIPTION,
1032: DISPLAY_PERIOD_TYPE = X_DISPLAY_PERIOD_TYPE,
1033: LAST_UPDATE_DATE = l_LAST_UPDATE_DATE,
1034: LAST_UPDATED_BY = l_LAST_UPDATED_BY,

Line 1070: from per_time_period_types_tl

1066: l_exists number;
1067:
1068: cursor chk_source_lang is
1069: select 1
1070: from per_time_period_types_tl
1071: where period_type = x_period_type
1072: and source_lang <> userenv('LANG');
1073:
1074: l_LAST_UPDATE_DATE DATE;