eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_TIME_PERIOD_TYPES_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 1: PACKAGE BODY PER_TIME_PERIOD_TYPES_PKG as

1: PACKAGE BODY PER_TIME_PERIOD_TYPES_PKG as
2: /* $Header: pydpt01t.pkb 120.0.12010000.1 2008/07/27 22:27:58 appldev ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 17: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.period_type_not_unique';

13: p_row_id in varchar2 ) is
14: --
15: v_not_unique boolean := FALSE;
16: g_dummy_number number;
17: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.period_type_not_unique';
18:
19: --
20: cursor csr_duplicate is
21: select null

Line 22: from per_time_period_types ptpt

18:
19: --
20: cursor csr_duplicate is
21: select null
22: from per_time_period_types ptpt
23: where upper(p_period_type) = upper(ptpt.period_type)
24: and (p_row_id is null
25: or (p_row_id is not null
26: and chartorowid(p_row_id) <> ptpt.rowid));

Line 59: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.delete_period_type';

55: p_number_per_fiscal_year in number) is
56: --
57: g_dummy_number number;
58: v_no_delete boolean := FALSE;
59: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.delete_period_type';
60:
61: --
62: cursor csr_calendar is
63: select null

Line 76: from per_time_period_types

72: from per_cobra_cov_enrollments
73: where upper(p_period_type) = upper(period_type);
74: cursor csr_year is
75: select null
76: from per_time_period_types
77: where number_per_fiscal_year = p_number_per_fiscal_year
78: and exists
79: (select null
80: from per_time_period_types

Line 80: from per_time_period_types

76: from per_time_period_types
77: where number_per_fiscal_year = p_number_per_fiscal_year
78: and exists
79: (select null
80: from per_time_period_types
81: where number_per_fiscal_year = p_number_per_fiscal_year
82: and number_per_fiscal_year = 1
83: having count(*) = 1);
84: cursor csr_quarter is

Line 86: from per_time_period_types

82: and number_per_fiscal_year = 1
83: having count(*) = 1);
84: cursor csr_quarter is
85: select null
86: from per_time_period_types
87: where number_per_fiscal_year = p_number_per_fiscal_year
88: and exists
89: (select null
90: from per_time_period_types

Line 90: from per_time_period_types

86: from per_time_period_types
87: where number_per_fiscal_year = p_number_per_fiscal_year
88: and exists
89: (select null
90: from per_time_period_types
91: where number_per_fiscal_year = p_number_per_fiscal_year
92: and number_per_fiscal_year = 4
93: having count(*) = 1);
94: --

Line 175: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.display_period_type_not_unique';

171: x_language in varchar2 ) is
172: --
173: v_not_unique boolean := FALSE;
174: g_dummy_number number;
175: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.display_period_type_not_unique';
176:
177: --
178: cursor csr_duplicate is
179: SELECT 1

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 248: cursor C is select ROWID from PER_TIME_PERIOD_TYPES

244: X_LAST_UPDATE_DATE in DATE,
245: X_LAST_UPDATED_BY in NUMBER,
246: X_LAST_UPDATE_LOGIN in NUMBER
247: ) is
248: cursor C is select ROWID from PER_TIME_PERIOD_TYPES
249: where PERIOD_TYPE = X_PERIOD_TYPE;
250:
251: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.insert_row';
252:

Line 251: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.insert_row';

247: ) is
248: cursor C is select ROWID from PER_TIME_PERIOD_TYPES
249: where PERIOD_TYPE = X_PERIOD_TYPE;
250:
251: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.insert_row';
252:
253: begin
254:
255: if g_debug then

Line 264: insert into PER_TIME_PERIOD_TYPES (

260: display_period_type_not_unique( X_PERIOD_TYPE,
261: X_DISPLAY_PERIOD_TYPE,
262: userenv('LANG') );
263:
264: insert into PER_TIME_PERIOD_TYPES (
265: PERIOD_TYPE,
266: NUMBER_PER_FISCAL_YEAR,
267: YEAR_TYPE_IN_NAME,
268: SYSTEM_FLAG,

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 440: from PER_TIME_PERIOD_TYPES

436: ATTRIBUTE16,
437: ATTRIBUTE17,
438: ATTRIBUTE18,
439: ATTRIBUTE19
440: from PER_TIME_PERIOD_TYPES
441: where PERIOD_TYPE = X_PERIOD_TYPE
442: for update of PERIOD_TYPE nowait;
443: recinfo c%rowtype;
444:

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 454: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.lock_row';

450: where PERIOD_TYPE = X_PERIOD_TYPE
451: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
452: for update of PERIOD_TYPE nowait;
453:
454: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.lock_row';
455:
456: begin
457:
458: if g_debug then

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 591: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.update_row';

587: and source_lang <> userenv('LANG');
588:
589: l_exists number;
590:
591: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.update_row';
592:
593: begin
594:
595: if g_debug then

Line 604: update PER_TIME_PERIOD_TYPES set

600: display_period_type_not_unique( X_PERIOD_TYPE,
601: X_DISPLAY_PERIOD_TYPE,
602: userenv('LANG') );
603:
604: update PER_TIME_PERIOD_TYPES set
605: NUMBER_PER_FISCAL_YEAR = X_NUMBER_PER_FISCAL_YEAR,
606: YEAR_TYPE_IN_NAME = X_YEAR_TYPE_IN_NAME,
607: SYSTEM_FLAG = X_SYSTEM_FLAG,
608: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 647: update PER_TIME_PERIOD_TYPES set

643: fetch chk_source_lang into l_exists;
644: close chk_source_lang;
645: --
646: if l_exists is null then
647: update PER_TIME_PERIOD_TYPES set
648: DISPLAY_PERIOD_TYPE = X_DISPLAY_PERIOD_TYPE,
649: DESCRIPTION = X_DESCRIPTION
650: where PERIOD_TYPE = X_PERIOD_TYPE;
651: end if;

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 706: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.delete_row';

702: procedure DELETE_ROW (
703: X_PERIOD_TYPE in VARCHAR2
704: ) is
705:
706: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.delete_row';
707:
708: begin
709:
710: if g_debug then

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 721: delete from PER_TIME_PERIOD_TYPES

717: if (sql%notfound) then
718: raise no_data_found;
719: end if;
720:
721: delete from PER_TIME_PERIOD_TYPES
722: where PERIOD_TYPE = X_PERIOD_TYPE;
723:
724: if (sql%notfound) then
725: raise no_data_found;

Line 736: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.add_language';

732: end DELETE_ROW;
733:
734: procedure ADD_LANGUAGE
735: is
736: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.add_language';
737: begin
738:
739: if g_debug then
740: hr_utility.set_location( 'Entering : ' || l_proc , 1);

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 746: from PER_TIME_PERIOD_TYPES B

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
748: );
749:
750: update PER_TIME_PERIOD_TYPES_TL T set (

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 820: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.owner_to_who';

816: X_LAST_UPDATED_BY out nocopy NUMBER,
817: X_LAST_UPDATE_LOGIN out nocopy NUMBER
818: ) is
819:
820: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.owner_to_who';
821:
822: begin
823:
824: if g_debug then

Line 889: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.load_row';

885: l_LAST_UPDATE_DATE DATE;
886: l_LAST_UPDATED_BY NUMBER;
887: l_LAST_UPDATE_LOGIN NUMBER;
888:
889: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.load_row';
890:
891:
892: begin
893:

Line 1006: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.translate_row';

1002: l_LAST_UPDATE_LOGIN NUMBER;
1003:
1004: l_exists number;
1005:
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

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 1046: update PER_TIME_PERIOD_TYPES set

1042: close chk_source_lang;
1043: --
1044:
1045: if l_exists is null then
1046: update PER_TIME_PERIOD_TYPES set
1047: DISPLAY_PERIOD_TYPE = X_DISPLAY_PERIOD_TYPE,
1048: DESCRIPTION = X_DESCRIPTION,
1049: LAST_UPDATE_DATE = l_LAST_UPDATE_DATE,
1050: 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;

Line 1078: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.validate_translation';

1074: l_LAST_UPDATE_DATE DATE;
1075: l_LAST_UPDATED_BY NUMBER;
1076: l_LAST_UPDATE_LOGIN NUMBER;
1077:
1078: l_proc CONSTANT varchar2(100) := 'per_time_period_types_pkg.validate_translation';
1079:
1080: begin
1081:
1082: if g_debug then

Line 1099: update PER_TIME_PERIOD_TYPES set

1095: l_LAST_UPDATED_BY := fnd_global.user_id;
1096: l_LAST_UPDATE_LOGIN := fnd_global.login_id;
1097:
1098: if l_exists is null and userenv('LANG') = X_LANGUAGE then
1099: update PER_TIME_PERIOD_TYPES set
1100: DISPLAY_PERIOD_TYPE = X_DISPLAY_PERIOD_TYPE,
1101: DESCRIPTION = X_DESCRIPTION,
1102: LAST_UPDATE_DATE = l_LAST_UPDATE_DATE,
1103: LAST_UPDATED_BY = l_LAST_UPDATED_BY

Line 1113: END PER_TIME_PERIOD_TYPES_PKG;

1109: end if;
1110:
1111: end validate_translation;
1112:
1113: END PER_TIME_PERIOD_TYPES_PKG;