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.BEN_PER_CM_USG_API dependencies on BEN_PER_CM_USG_F

Line 60: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;

56: ,p_effective_date in date) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;
61: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
62: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_PER_CM_USG';
64: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;

Line 61: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;

57: --
58: -- Declare cursors and local variables
59: --
60: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;
61: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
62: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_PER_CM_USG';
64: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
65: --

Line 62: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;

58: -- Declare cursors and local variables
59: --
60: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;
61: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
62: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_PER_CM_USG';
64: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
65: --
66: begin

Line 64: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;

60: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;
61: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
62: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_PER_CM_USG';
64: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 344: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;

340: ,p_effective_date in date) is
341: --
342: -- Declare cursors and local variables
343: --
344: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;
345: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
346: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
347: l_proc varchar2(72) := g_package||'create_PER_CM_USG';
348: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;

Line 345: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;

341: --
342: -- Declare cursors and local variables
343: --
344: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;
345: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
346: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
347: l_proc varchar2(72) := g_package||'create_PER_CM_USG';
348: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
349: --

Line 346: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;

342: -- Declare cursors and local variables
343: --
344: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;
345: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
346: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
347: l_proc varchar2(72) := g_package||'create_PER_CM_USG';
348: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
349: --
350: cursor c_seq is

Line 348: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;

344: l_per_cm_usg_id ben_per_cm_usg_f.per_cm_usg_id%TYPE;
345: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
346: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
347: l_proc varchar2(72) := g_package||'create_PER_CM_USG';
348: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
349: --
350: cursor c_seq is
351: select ben_per_cm_usg_f_s.nextval
352: from sys.dual;

Line 351: select ben_per_cm_usg_f_s.nextval

347: l_proc varchar2(72) := g_package||'create_PER_CM_USG';
348: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
349: --
350: cursor c_seq is
351: select ben_per_cm_usg_f_s.nextval
352: from sys.dual;
353: --
354: l_validation_start_date date;
355: l_validation_end_date date;

Line 433: p_base_table_name => 'ben_per_cm_usg_f',

429: --
430: dt_api.validate_dt_mode
431: (p_effective_date => p_effective_date,
432: p_datetrack_mode => 'INSERT',
433: p_base_table_name => 'ben_per_cm_usg_f',
434: p_base_key_column => 'per_cm_usg_id',
435: p_base_key_value => p_per_cm_usg_id,
436: p_parent_table_name1 => 'ben_cm_typ_usg_f',
437: p_parent_key_column1 => 'cm_typ_usg_id',

Line 450: insert into ben_per_cm_usg_f

446: l_effective_start_date := l_validation_start_date;
447: l_effective_end_date := l_validation_end_date;
448: l_object_version_number := 1;
449: --
450: insert into ben_per_cm_usg_f
451: (per_cm_usg_id
452: ,effective_start_date
453: ,effective_end_date
454: ,per_cm_id

Line 593: (p_module_name => 'ben_per_cm_usg_f'

589: --
590: when hr_api.cannot_find_prog_unit then
591: --
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'ben_per_cm_usg_f'
594: ,p_hook_type => 'AI');
595: --
596: end;
597: --

Line 760: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;

756: --
757: -- Declare cursors and local variables
758: --
759: l_proc varchar2(72) := g_package||'update_PER_CM_USG';
760: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
761: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
762: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
763: --
764: begin

Line 761: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;

757: -- Declare cursors and local variables
758: --
759: l_proc varchar2(72) := g_package||'update_PER_CM_USG';
760: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
761: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
762: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
763: --
764: begin
765: --

Line 762: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;

758: --
759: l_proc varchar2(72) := g_package||'update_PER_CM_USG';
760: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
761: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
762: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
763: --
764: begin
765: --
766: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1006: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;

1002: --
1003: -- Declare cursors and local variables
1004: --
1005: l_proc varchar2(72) := g_package||'update_PER_CM_USG';
1006: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
1007: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
1008: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
1009: --
1010: begin

Line 1007: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;

1003: -- Declare cursors and local variables
1004: --
1005: l_proc varchar2(72) := g_package||'update_PER_CM_USG';
1006: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
1007: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
1008: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
1009: --
1010: begin
1011: --

Line 1008: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;

1004: --
1005: l_proc varchar2(72) := g_package||'update_PER_CM_USG';
1006: l_object_version_number ben_per_cm_usg_f.object_version_number%TYPE;
1007: l_effective_start_date ben_per_cm_usg_f.effective_start_date%TYPE;
1008: l_effective_end_date ben_per_cm_usg_f.effective_end_date%TYPE;
1009: --
1010: begin
1011: --
1012: hr_utility.set_location('Entering:'|| l_proc, 10);