49: and oi.org_information5 is not null;
50:
51: CURSOR get_row_id IS
52: select rowid
53: from PER_ASSIGNMENT_EXTRA_INFO
54: where assignment_extra_info_id = p_assignment_extra_info_id;
55:
56: BEGIN
57: hr_utility.set_location('Entering'||l_proc,100);
83: IF l_row_touched then
84: hr_utility.set_location(l_proc, 15);
85: null;
86: else
87: indx := ghr_history_api.add_row_operation_info_rg(p_table_name => 'PER_ASSIGNMENT_EXTRA_INFO',
88: p_table_pk_id => p_assignment_extra_info_id,
89: p_operation => 'insert',
90: p_row_id => l_row_id);
91: end if;
145: and oi.org_information5 is not null;
146:
147: CURSOR get_row_id IS
148: select rowid
149: from PER_ASSIGNMENT_EXTRA_INFO
150: where assignment_extra_info_id = p_assignment_extra_info_id;
151:
152: BEGIN
153: hr_utility.set_location('Entering'||l_proc,100);
180: IF l_row_touched then
181: hr_utility.set_location(l_proc, 15);
182: null;
183: else
184: indx := ghr_history_api.add_row_operation_info_rg(p_table_name => 'PER_ASSIGNMENT_EXTRA_INFO',
185: p_table_pk_id => p_assignment_extra_info_id,
186: p_operation => 'update',
187: p_row_id => l_row_id);
188: end if;
204: aei_information1,
205: aei_information2,
206: aei_information3,
207: aei_information6
208: FROM PER_ASSIGNMENT_EXTRA_INFO
209: WHERE assignment_extra_info_id = p_assignment_extra_info_id;
210:
211: BEGIN
212: