87: --
88: Cursor C_Sel1 Is
89: select t.created_by,
90: t.creation_date
91: from pay_pl_sii_details_f t
92: where t.sii_details_id = p_rec.sii_details_id
93: and t.effective_start_date =
94: pay_psd_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
94: pay_psd_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pay_pl_sii_details_f.created_by%TYPE;
99: l_creation_date pay_pl_sii_details_f.creation_date%TYPE;
100: l_last_update_date pay_pl_sii_details_f.last_update_date%TYPE;
101: l_last_updated_by pay_pl_sii_details_f.last_updated_by%TYPE;
102: l_last_update_login pay_pl_sii_details_f.last_update_login%TYPE;
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pay_pl_sii_details_f.created_by%TYPE;
99: l_creation_date pay_pl_sii_details_f.creation_date%TYPE;
100: l_last_update_date pay_pl_sii_details_f.last_update_date%TYPE;
101: l_last_updated_by pay_pl_sii_details_f.last_updated_by%TYPE;
102: l_last_update_login pay_pl_sii_details_f.last_update_login%TYPE;
103: --
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pay_pl_sii_details_f.created_by%TYPE;
99: l_creation_date pay_pl_sii_details_f.creation_date%TYPE;
100: l_last_update_date pay_pl_sii_details_f.last_update_date%TYPE;
101: l_last_updated_by pay_pl_sii_details_f.last_updated_by%TYPE;
102: l_last_update_login pay_pl_sii_details_f.last_update_login%TYPE;
103: --
104: Begin
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pay_pl_sii_details_f.created_by%TYPE;
99: l_creation_date pay_pl_sii_details_f.creation_date%TYPE;
100: l_last_update_date pay_pl_sii_details_f.last_update_date%TYPE;
101: l_last_updated_by pay_pl_sii_details_f.last_updated_by%TYPE;
102: l_last_update_login pay_pl_sii_details_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
98: l_created_by pay_pl_sii_details_f.created_by%TYPE;
99: l_creation_date pay_pl_sii_details_f.creation_date%TYPE;
100: l_last_update_date pay_pl_sii_details_f.last_update_date%TYPE;
101: l_last_updated_by pay_pl_sii_details_f.last_updated_by%TYPE;
102: l_last_update_login pay_pl_sii_details_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
119: -- Get the object version number for the insert
120: --
121: p_rec.object_version_number :=
122: dt_api.get_object_version_number
123: (p_base_table_name => 'pay_pl_sii_details_f'
124: ,p_base_key_column => 'sii_details_id'
125: ,p_base_key_value => p_rec.sii_details_id
126: );
127: --
152: End If;
153: --
154: --
155: --
156: -- Insert the row into: pay_pl_sii_details_f
157: --
158: insert into pay_pl_sii_details_f
159: (sii_details_id
160: ,effective_start_date
154: --
155: --
156: -- Insert the row into: pay_pl_sii_details_f
157: --
158: insert into pay_pl_sii_details_f
159: (sii_details_id
160: ,effective_start_date
161: ,effective_end_date
162: ,per_or_asg_id
318: Cursor C_Sel1 is select pay_pl_sii_details_s.nextval from sys.dual;
319: --
320: Cursor C_Sel2 is
321: Select null
322: from pay_pl_sii_details_f
323: where sii_details_id =
324: pay_psd_ins.g_sii_details_id_i;
325: --
326: l_proc varchar2(72) := g_package||'pre_insert';
340: --
341: -- The primary key values are already in use.
342: --
343: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
344: fnd_message.set_token('TABLE_NAME','pay_pl_sii_details_f');
345: fnd_message.raise_error;
346: End If;
347: Close C_Sel2;
348: --
478: --
479: when hr_api.cannot_find_prog_unit then
480: --
481: hr_api.cannot_find_prog_unit_error
482: (p_module_name => 'PAY_PL_SII_DETAILS_F'
483: ,p_hook_type => 'AI');
484: --
485: end;
486: --
551:
552: dt_api.validate_dt_mode
553: (p_effective_date => p_effective_date
554: ,p_datetrack_mode => p_datetrack_mode
555: ,p_base_table_name => 'pay_pl_sii_details_f'
556: ,p_base_key_column => 'sii_details_id'
557: ,p_base_key_value => p_rec.sii_details_id
558: ,p_parent_table_name1 => 'per_all_assignments_f'
559: ,p_parent_key_column1 => 'assignment_id'
570:
571: dt_api.validate_dt_mode
572: (p_effective_date => p_effective_date
573: ,p_datetrack_mode => p_datetrack_mode
574: ,p_base_table_name => 'pay_pl_sii_details_f'
575: ,p_base_key_column => 'sii_details_id'
576: ,p_base_key_value => p_rec.sii_details_id
577: ,p_parent_table_name1 => 'per_people_f'
578: ,p_parent_key_column1 => 'person_id'