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.PAY_GB_ROLLBACK dependencies on HR_ASSIGNMENT_EXTRA_INFO_API

Line 137: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_PAY_RTI',

133: hr_utility.set_location('Inside csr_archive_details cursor',1);
134: -- Number of Periods Covered
135: l_ovn := get_version(archive_rec.assignment_id,'GB_PAY_RTI',l_aei_id);
136: IF l_ovn IS NOT NULL THEN
137: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_PAY_RTI',
138: p_aei_information1 => archive_rec.action_information20);
139: END IF;
140: --EXPAT Flag
141: IF (archive_rec.action_information9 IS NOT NULL) OR (archive_rec.action_information10 IS NOT NULL) OR (archive_rec.action_information6 ='Y') OR (archive_rec.action_information7 ='Y') OR (archive_rec.action_information8 ='Y') THEN

Line 144: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',

140: --EXPAT Flag
141: IF (archive_rec.action_information9 IS NOT NULL) OR (archive_rec.action_information10 IS NOT NULL) OR (archive_rec.action_information6 ='Y') OR (archive_rec.action_information7 ='Y') OR (archive_rec.action_information8 ='Y') THEN
142: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
143: IF l_ovn IS NOT NULL THEN
144: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',
145: p_aei_information19 => 'N');
146: END IF;
147: END IF;
148: --PENSIONER Flag

Line 152: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information9 => 'N');

148: --PENSIONER Flag
149: IF (archive_rec.action_information12 IS NOT NULL) OR (archive_rec.action_information26 IS NOT NULL) THEN
150: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
151: IF l_ovn IS NOT NULL THEN
152: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information9 => 'N');
153: END IF;
154: END IF;
155: --STARTER Flag
156: IF (archive_rec.action_information4 IS NOT NULL) OR (archive_rec.action_information5 IS NOT NULL) THEN

Line 159: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

155: --STARTER Flag
156: IF (archive_rec.action_information4 IS NOT NULL) OR (archive_rec.action_information5 IS NOT NULL) THEN
157: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
158: IF l_ovn IS NOT NULL THEN
159: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
160: END IF;
161: END IF;
162: -- Delete from pay_gb_fps_details
163: DELETE

Line 183: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_PAY_RTI',

179: FETCH csr_archive_asgact_details into l_asgact_rec;
180: hr_utility.set_location('Inside csr_archive_asgact_details cursor',1);
181: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_PAY_RTI',l_aei_id);
182: IF l_ovn IS NOT NULL THEN
183: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_PAY_RTI',
184: p_aei_information1 => l_asgact_rec.action_information20);
185: END IF;
186: --EXPAT Flag
187: IF (l_asgact_rec.action_information9 IS NOT NULL) OR (l_asgact_rec.action_information10 IS NOT NULL) OR (l_asgact_rec.action_information6 ='Y') OR (l_asgact_rec.action_information7 ='Y') OR (l_asgact_rec.action_information8 ='Y') THEN

Line 190: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',

186: --EXPAT Flag
187: IF (l_asgact_rec.action_information9 IS NOT NULL) OR (l_asgact_rec.action_information10 IS NOT NULL) OR (l_asgact_rec.action_information6 ='Y') OR (l_asgact_rec.action_information7 ='Y') OR (l_asgact_rec.action_information8 ='Y') THEN
188: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
189: IF l_ovn IS NOT NULL THEN
190: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',
191: p_aei_information19 => 'N');
192: END IF;
193: END IF;
194: --PENSIONER Flag

Line 198: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information9 => 'N');

194: --PENSIONER Flag
195: IF (l_asgact_rec.action_information12 IS NOT NULL) OR (l_asgact_rec.action_information26 IS NOT NULL) THEN
196: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
197: IF l_ovn IS NOT NULL THEN
198: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information9 => 'N');
199: END IF;
200: END IF;
201: --STARTER Flag
202: IF (l_asgact_rec.action_information4 IS NOT NULL) OR (l_asgact_rec.action_information5 IS NOT NULL) THEN

Line 205: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

201: --STARTER Flag
202: IF (l_asgact_rec.action_information4 IS NOT NULL) OR (l_asgact_rec.action_information5 IS NOT NULL) THEN
203: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
204: IF l_ovn IS NOT NULL THEN
205: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
206: END IF;
207: END IF;
208: -- Delete from pay_gb_fps_details
209: DELETE

Line 307: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

303: LOOP
304: --STARTER Flag
305: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
306: IF l_ovn IS NOT NULL THEN
307: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
308: END IF;
309:
310: open csr_fetch_agg(archive_rec.assignment_id);
311: fetch csr_fetch_agg into l_paye_agg;

Line 322: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

318: exit when fetch_other_paye_agg_asg%notfound;
319: --STARTER Flag
320: l_ovn := get_version(l_assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
321: IF l_ovn IS NOT NULL THEN
322: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
323: END IF;
324: end loop;
325: close fetch_other_paye_agg_asg;
326: end if;

Line 337: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

333: FETCH csr_asgs_asgact_processed into l_asgact_rec;
334: --STARTER Flag
335: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
336: IF l_ovn IS NOT NULL THEN
337: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
338: END IF;
339:
340: open csr_fetch_agg(l_asgact_rec.assignment_id);
341: fetch csr_fetch_agg into l_paye_agg;

Line 352: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

348: exit when fetch_other_paye_agg_asg%notfound;
349: --STARTER Flag
350: l_ovn := get_version(l_assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
351: IF l_ovn IS NOT NULL THEN
352: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
353: END IF;
354: end loop;
355: close fetch_other_paye_agg_asg;
356: end if;

Line 423: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

419: open is_prev_flag(archive_rec.assignment_id);
420: fetch is_prev_flag into l_prev_eas;
421: close is_prev_flag;
422: IF (l_ovn IS NOT NULL and l_prev_eas is null)THEN
423: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
424: END IF;
425: END LOOP;
426: ELSE -- for IF (p_asgactid is null) THEN condition
427:

Line 437: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');

433: fetch is_prev_flag into l_prev_eas;
434: close is_prev_flag;
435: IF (l_ovn IS NOT NULL and l_prev_eas is null)THEN
436:
437: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
438:
439: END IF;
440: close csr_asgs_asgact_processed;
441: END IF;