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_PRVDD_API dependencies on BEN_PER_CM_PRVDD_F

Line 71: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;

67: ,p_effective_date in date) is
68: --
69: -- Declare cursors and local variables
70: --
71: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;
72: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
73: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PER_CM_PRVDD';
75: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;

Line 72: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;

68: --
69: -- Declare cursors and local variables
70: --
71: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;
72: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
73: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PER_CM_PRVDD';
75: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
76: --

Line 73: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;

69: -- Declare cursors and local variables
70: --
71: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;
72: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
73: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PER_CM_PRVDD';
75: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
76: --
77: begin

Line 75: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;

71: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;
72: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
73: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PER_CM_PRVDD';
75: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
76: --
77: begin
78: --
79: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 397: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;

393: ,p_effective_date in date) is
394: --
395: -- Declare cursors and local variables
396: --
397: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;
398: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
399: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
400: l_proc varchar2(72) := g_package||'create_PER_CM_PRVDD';
401: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;

Line 398: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;

394: --
395: -- Declare cursors and local variables
396: --
397: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;
398: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
399: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
400: l_proc varchar2(72) := g_package||'create_PER_CM_PRVDD';
401: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
402: --

Line 399: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;

395: -- Declare cursors and local variables
396: --
397: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;
398: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
399: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
400: l_proc varchar2(72) := g_package||'create_PER_CM_PRVDD';
401: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
402: --
403: cursor c_seq is

Line 401: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;

397: l_per_cm_prvdd_id ben_per_cm_prvdd_f.per_cm_prvdd_id%TYPE;
398: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
399: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
400: l_proc varchar2(72) := g_package||'create_PER_CM_PRVDD';
401: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
402: --
403: cursor c_seq is
404: select ben_per_cm_prvdd_f_s.nextval
405: from sys.dual;

Line 404: select ben_per_cm_prvdd_f_s.nextval

400: l_proc varchar2(72) := g_package||'create_PER_CM_PRVDD';
401: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
402: --
403: cursor c_seq is
404: select ben_per_cm_prvdd_f_s.nextval
405: from sys.dual;
406: --
407: l_validation_start_date date;
408: l_validation_end_date date;

Line 499: p_base_table_name => 'ben_per_cm_prvdd_f',

495: --
496: dt_api.validate_dt_mode
497: (p_effective_date => p_effective_date,
498: p_datetrack_mode => 'INSERT',
499: p_base_table_name => 'ben_per_cm_prvdd_f',
500: p_base_key_column => 'per_cm_prvdd_id',
501: p_base_key_value => p_per_cm_prvdd_id,
502: p_parent_table_name1 => 'ben_per_cm_f',
503: p_parent_key_column1 => 'per_cm_id',

Line 513: insert into ben_per_cm_prvdd_f

509: l_effective_start_date := l_validation_start_date;
510: l_effective_end_date := l_validation_end_date;
511: l_object_version_number := 1;
512: --
513: insert into ben_per_cm_prvdd_f
514: (per_cm_prvdd_id
515: ,effective_start_date
516: ,effective_end_date
517: ,rqstd_flag

Line 689: (p_module_name => 'ben_per_cm_prvdd_f'

685: --
686: when hr_api.cannot_find_prog_unit then
687: --
688: hr_api.cannot_find_prog_unit_error
689: (p_module_name => 'ben_per_cm_prvdd_f'
690: ,p_hook_type => 'AI');
691: --
692: end;
693: --

Line 874: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;

870: --
871: -- Declare cursors and local variables
872: --
873: l_proc varchar2(72) := g_package||'update_PER_CM_PRVDD';
874: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
875: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
876: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
877: --
878: begin

Line 875: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;

871: -- Declare cursors and local variables
872: --
873: l_proc varchar2(72) := g_package||'update_PER_CM_PRVDD';
874: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
875: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
876: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
877: --
878: begin
879: --

Line 876: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;

872: --
873: l_proc varchar2(72) := g_package||'update_PER_CM_PRVDD';
874: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
875: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
876: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
877: --
878: begin
879: --
880: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1151: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;

1147: --
1148: -- Declare cursors and local variables
1149: --
1150: l_proc varchar2(72) := g_package||'update_PER_CM_PRVDD';
1151: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
1152: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
1153: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
1154: --
1155: begin

Line 1152: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;

1148: -- Declare cursors and local variables
1149: --
1150: l_proc varchar2(72) := g_package||'update_PER_CM_PRVDD';
1151: l_object_version_number ben_per_cm_prvdd_f.object_version_number%TYPE;
1152: l_effective_start_date ben_per_cm_prvdd_f.effective_start_date%TYPE;
1153: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;
1154: --
1155: begin
1156: --

Line 1153: l_effective_end_date ben_per_cm_prvdd_f.effective_end_date%TYPE;

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