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_API dependencies on BEN_PER_CM_F

Line 68: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;

64: ) is
65: --
66: -- Declare cursors and local variables
67: --
68: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;
69: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
70: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_PER_CM';
72: l_object_version_number ben_per_cm_f.object_version_number%TYPE;

Line 69: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;

65: --
66: -- Declare cursors and local variables
67: --
68: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;
69: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
70: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_PER_CM';
72: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
73: --

Line 70: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;

66: -- Declare cursors and local variables
67: --
68: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;
69: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
70: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_PER_CM';
72: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
73: --
74: begin

Line 72: l_object_version_number ben_per_cm_f.object_version_number%TYPE;

68: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;
69: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
70: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_PER_CM';
72: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
73: --
74: begin
75: --
76: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 380: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;

376: ) is
377: --
378: -- Declare cursors and local variables
379: --
380: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;
381: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
382: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
383: l_proc varchar2(72) := g_package||'create_PER_CM';
384: l_object_version_number ben_per_cm_f.object_version_number%TYPE;

Line 381: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;

377: --
378: -- Declare cursors and local variables
379: --
380: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;
381: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
382: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
383: l_proc varchar2(72) := g_package||'create_PER_CM';
384: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
385: --

Line 382: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;

378: -- Declare cursors and local variables
379: --
380: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;
381: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
382: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
383: l_proc varchar2(72) := g_package||'create_PER_CM';
384: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
385: --
386: cursor c_seq is

Line 384: l_object_version_number ben_per_cm_f.object_version_number%TYPE;

380: l_per_cm_id ben_per_cm_f.per_cm_id%TYPE;
381: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
382: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
383: l_proc varchar2(72) := g_package||'create_PER_CM';
384: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
385: --
386: cursor c_seq is
387: select ben_per_cm_f_s.nextval
388: from sys.dual;

Line 387: select ben_per_cm_f_s.nextval

383: l_proc varchar2(72) := g_package||'create_PER_CM';
384: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
385: --
386: cursor c_seq is
387: select ben_per_cm_f_s.nextval
388: from sys.dual;
389: --
390: l_validation_start_date date;
391: l_validation_end_date date;

Line 479: p_base_table_name => 'ben_per_cm_f',

475: --
476: dt_api.validate_dt_mode
477: (p_effective_date => trunc(p_effective_date),
478: p_datetrack_mode => 'INSERT',
479: p_base_table_name => 'ben_per_cm_f',
480: p_base_key_column => 'per_cm_id',
481: p_base_key_value => p_per_cm_id,
482: p_parent_table_name1 => 'ben_cm_typ_f',
483: p_parent_key_column1 => 'cm_typ_id',

Line 496: insert into ben_per_cm_f

492: l_effective_start_date := l_validation_start_date;
493: l_effective_end_date := l_validation_end_date;
494: l_object_version_number := 1;
495: --
496: insert into ben_per_cm_f
497: (per_cm_id
498: ,effective_start_date
499: ,effective_end_date
500: ,lf_evt_ocrd_dt

Line 660: (p_module_name => 'ben_per_cm_f'

656: --
657: when hr_api.cannot_find_prog_unit then
658: --
659: hr_api.cannot_find_prog_unit_error
660: (p_module_name => 'ben_per_cm_f'
661: ,p_hook_type => 'AI');
662: --
663: end;
664: --

Line 845: l_object_version_number ben_per_cm_f.object_version_number%TYPE;

841: --
842: -- Declare cursors and local variables
843: --
844: l_proc varchar2(72) := g_package||'update_PER_CM';
845: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
846: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
847: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
848: --
849: begin

Line 846: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;

842: -- Declare cursors and local variables
843: --
844: l_proc varchar2(72) := g_package||'update_PER_CM';
845: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
846: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
847: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
848: --
849: begin
850: --

Line 847: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;

843: --
844: l_proc varchar2(72) := g_package||'update_PER_CM';
845: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
846: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
847: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
848: --
849: begin
850: --
851: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1149: l_object_version_number ben_per_cm_f.object_version_number%TYPE;

1145: between effective_start_date
1146: and effective_end_date;
1147: --
1148: l_proc varchar2(72) := g_package||'update_PER_CM';
1149: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
1150: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
1151: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
1152: --
1153: begin

Line 1150: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;

1146: and effective_end_date;
1147: --
1148: l_proc varchar2(72) := g_package||'update_PER_CM';
1149: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
1150: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
1151: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
1152: --
1153: begin
1154: --

Line 1151: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;

1147: --
1148: l_proc varchar2(72) := g_package||'update_PER_CM';
1149: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
1150: l_effective_start_date ben_per_cm_f.effective_start_date%TYPE;
1151: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
1152: --
1153: begin
1154: --
1155: hr_utility.set_location('Entering:'|| l_proc, 10);