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;
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: --
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
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);
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;
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: --
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
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;
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;
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',
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
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: --
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
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: --
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);
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
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: --
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);