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_TRGR_API dependencies on BEN_PER_CM_TRGR_F

Line 60: l_per_cm_trgr_id ben_per_cm_trgr_f.per_cm_trgr_id%TYPE;

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

Line 61: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;

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

Line 62: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;

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

Line 64: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;

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

Line 342: l_per_cm_trgr_id ben_per_cm_trgr_f.per_cm_trgr_id%TYPE;

338: ,p_effective_date in date) is
339: --
340: -- Declare cursors and local variables
341: --
342: l_per_cm_trgr_id ben_per_cm_trgr_f.per_cm_trgr_id%TYPE;
343: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;
344: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
345: l_proc varchar2(72) := g_package||'create_PER_CM_TRGR';
346: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;

Line 343: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;

339: --
340: -- Declare cursors and local variables
341: --
342: l_per_cm_trgr_id ben_per_cm_trgr_f.per_cm_trgr_id%TYPE;
343: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;
344: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
345: l_proc varchar2(72) := g_package||'create_PER_CM_TRGR';
346: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;
347: l_validation_start_date date;

Line 344: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;

340: -- Declare cursors and local variables
341: --
342: l_per_cm_trgr_id ben_per_cm_trgr_f.per_cm_trgr_id%TYPE;
343: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;
344: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
345: l_proc varchar2(72) := g_package||'create_PER_CM_TRGR';
346: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;
347: l_validation_start_date date;
348: l_validation_end_date date;

Line 346: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;

342: l_per_cm_trgr_id ben_per_cm_trgr_f.per_cm_trgr_id%TYPE;
343: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;
344: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
345: l_proc varchar2(72) := g_package||'create_PER_CM_TRGR';
346: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;
347: l_validation_start_date date;
348: l_validation_end_date date;
349: --
350: cursor c_seq is

Line 351: select ben_per_cm_trgr_f_s.nextval

347: l_validation_start_date date;
348: l_validation_end_date date;
349: --
350: cursor c_seq is
351: select ben_per_cm_trgr_f_s.nextval
352: from sys.dual;
353: --
354: begin
355: --

Line 432: p_base_table_name => 'ben_per_cm_trgr_f',

428: --
429: dt_api.validate_dt_mode
430: (p_effective_date => p_effective_date,
431: p_datetrack_mode => 'INSERT',
432: p_base_table_name => 'ben_per_cm_trgr_f',
433: p_base_key_column => 'per_cm_trgr_id',
434: p_base_key_value => l_per_cm_trgr_id,
435: p_parent_table_name1 => 'ben_per_cm_f',
436: p_parent_key_column1 => 'per_cm_id',

Line 446: insert into ben_per_cm_trgr_f

442: l_effective_start_date := l_validation_start_date;
443: l_effective_end_date := l_validation_end_date;
444: l_object_version_number := 1;
445: --
446: insert into ben_per_cm_trgr_f
447: (per_cm_trgr_id
448: ,effective_start_date
449: ,effective_end_date
450: ,cm_trgr_id

Line 589: (p_module_name => 'ben_per_cm_trgr_f'

585: --
586: when hr_api.cannot_find_prog_unit then
587: --
588: hr_api.cannot_find_prog_unit_error
589: (p_module_name => 'ben_per_cm_trgr_f'
590: ,p_hook_type => 'AI');
591: --
592: end;
593: --

Line 757: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;

753: --
754: -- Declare cursors and local variables
755: --
756: l_proc varchar2(72) := g_package||'update_PER_CM_TRGR';
757: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;
758: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;
759: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
760: --
761: begin

Line 758: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;

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

Line 759: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;

755: --
756: l_proc varchar2(72) := g_package||'update_PER_CM_TRGR';
757: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;
758: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;
759: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
760: --
761: begin
762: --
763: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1000: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;

996: --
997: -- Declare cursors and local variables
998: --
999: l_proc varchar2(72) := g_package||'update_PER_CM_TRGR';
1000: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;
1001: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;
1002: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
1003: --
1004: begin

Line 1001: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;

997: -- Declare cursors and local variables
998: --
999: l_proc varchar2(72) := g_package||'update_PER_CM_TRGR';
1000: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;
1001: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;
1002: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
1003: --
1004: begin
1005: --

Line 1002: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;

998: --
999: l_proc varchar2(72) := g_package||'update_PER_CM_TRGR';
1000: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;
1001: l_effective_start_date ben_per_cm_trgr_f.effective_start_date%TYPE;
1002: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
1003: --
1004: begin
1005: --
1006: hr_utility.set_location('Entering:'|| l_proc, 10);