APPS.PER_TIME_PERIOD_TYPES_PKG dependencies on PER_TIME_PERIOD_TYPES_PKG

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 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 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 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 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 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 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 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 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 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 1113: END PER_TIME_PERIOD_TYPES_PKG;

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