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_PKG dependencies on HR_ASSIGNMENT_EXTRA_INFO_API

Line 162: 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',

158: LOOP
159: -- Number of Periods Covered
160: l_ovn := get_version(archive_rec.assignment_id,'GB_PAY_RTI',l_aei_id);
161: IF l_ovn IS NOT NULL THEN
162: 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',
163: p_aei_information1 => archive_rec.action_information20);
164: END IF;
165: --EXPAT Flag
166: 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 169: 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',

165: --EXPAT Flag
166: 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
167: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
168: IF l_ovn IS NOT NULL THEN
169: 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',
170: p_aei_information19 => 'N');
171: END IF;
172: END IF;
173: --PENSIONER Flag

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

173: --PENSIONER Flag
174: IF (archive_rec.action_information12 IS NOT NULL) OR (archive_rec.action_information26 IS NOT NULL) THEN
175: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
176: IF l_ovn IS NOT NULL THEN
177: 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');
178: END IF;
179: END IF;
180: --STARTER Flag
181: IF (archive_rec.action_information4 IS NOT NULL) OR (archive_rec.action_information5 IS NOT NULL) THEN

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

180: --STARTER Flag
181: IF (archive_rec.action_information4 IS NOT NULL) OR (archive_rec.action_information5 IS NOT NULL) THEN
182: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
183: IF l_ovn IS NOT NULL THEN
184: 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');
185: END IF;
186: END IF;
187: -- Delete from pay_gb_fps_details
188: DELETE

Line 207: 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',

203: OPEN csr_archive_asgact_details;
204: FETCH csr_archive_asgact_details into l_asgact_rec;
205: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_PAY_RTI',l_aei_id);
206: IF l_ovn IS NOT NULL THEN
207: 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',
208: p_aei_information1 => l_asgact_rec.action_information20);
209: END IF;
210: --EXPAT Flag
211: 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 214: 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',

210: --EXPAT Flag
211: 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
212: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
213: IF l_ovn IS NOT NULL THEN
214: 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',
215: p_aei_information19 => 'N');
216: END IF;
217: END IF;
218: --PENSIONER Flag

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

218: --PENSIONER Flag
219: IF (l_asgact_rec.action_information12 IS NOT NULL) OR (l_asgact_rec.action_information26 IS NOT NULL) THEN
220: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
221: IF l_ovn IS NOT NULL THEN
222: 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');
223: END IF;
224: END IF;
225: --STARTER Flag
226: IF (l_asgact_rec.action_information4 IS NOT NULL) OR (l_asgact_rec.action_information5 IS NOT NULL) THEN

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

225: --STARTER Flag
226: IF (l_asgact_rec.action_information4 IS NOT NULL) OR (l_asgact_rec.action_information5 IS NOT NULL) THEN
227: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
228: IF l_ovn IS NOT NULL THEN
229: 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');
230: END IF;
231: END IF;
232: -- Delete from pay_gb_fps_details
233: DELETE

Line 327: 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',

323: --EXPAT Flag
324: IF (archive_rec.action_information8 IS NOT NULL) OR (archive_rec.action_information9 IS NOT NULL) OR (archive_rec.action_information5 ='Y') OR (archive_rec.action_information6 ='Y') OR (archive_rec.action_information7 ='Y') THEN
325: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
326: IF l_ovn IS NOT NULL THEN
327: 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',
328: p_aei_information19 => 'N');
329: END IF;
330: END IF;
331: --PENSIONER Flag

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

331: --PENSIONER Flag
332: IF (archive_rec.action_information11 IS NOT NULL) OR (archive_rec.action_information12 IS NOT NULL) THEN
333: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
334: IF l_ovn IS NOT NULL THEN
335: 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');
336: END IF;
337: END IF;
338: --STARTER Flag
339: IF (archive_rec.action_information3 IS NOT NULL) OR (archive_rec.action_information4 IS NOT NULL) THEN

Line 342: 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: --STARTER Flag
339: IF (archive_rec.action_information3 IS NOT NULL) OR (archive_rec.action_information4 IS NOT NULL) THEN
340: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
341: IF l_ovn IS NOT NULL THEN
342: 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');
343: END IF;
344: END IF;
345:
346: END LOOP;

Line 358: 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',

354: --EXPAT Flag
355: IF (l_asgact_rec.action_information8 IS NOT NULL) OR (l_asgact_rec.action_information9 IS NOT NULL) OR (l_asgact_rec.action_information5 ='Y') OR (l_asgact_rec.action_information6 ='Y') OR (l_asgact_rec.action_information7 ='Y') THEN
356: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
357: IF l_ovn IS NOT NULL THEN
358: 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',
359: p_aei_information19 => 'N');
360: END IF;
361: END IF;
362: --PENSIONER Flag

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

362: --PENSIONER Flag
363: IF (l_asgact_rec.action_information11 IS NOT NULL) OR (l_asgact_rec.action_information12 IS NOT NULL) THEN
364: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
365: IF l_ovn IS NOT NULL THEN
366: 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');
367: END IF;
368: END IF;
369: --STARTER Flag
370: IF (l_asgact_rec.action_information3 IS NOT NULL) OR (l_asgact_rec.action_information4 IS NOT NULL) THEN

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

369: --STARTER Flag
370: IF (l_asgact_rec.action_information3 IS NOT NULL) OR (l_asgact_rec.action_information4 IS NOT NULL) THEN
371: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
372: IF l_ovn IS NOT NULL THEN
373: 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');
374: END IF;
375: END IF;
376:
377: CLOSE csr_archive_asgact_details;

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

452: LOOP
453: --STARTER Flag
454: l_ovn := get_version(archive_rec.assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
455: IF l_ovn IS NOT NULL THEN
456: 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');
457: END IF;
458:
459: open csr_fetch_agg(archive_rec.assignment_id);
460: fetch csr_fetch_agg into l_paye_agg;

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

467: exit when fetch_other_paye_agg_asg%notfound;
468: --STARTER Flag
469: l_ovn := get_version(l_assignment_id,'GB_RTI_ASG_DETAILS',l_aei_id);
470: IF l_ovn IS NOT NULL THEN
471: 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');
472: END IF;
473: end loop;
474: close fetch_other_paye_agg_asg;
475: end if;

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

528: open is_prev_flag(archive_rec.assignment_id);
529: fetch is_prev_flag into l_prev_eas;
530: close is_prev_flag;
531: IF (l_ovn IS NOT NULL and l_prev_eas is null)THEN
532: 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');
533: END IF;
534: END LOOP;
535: hr_utility.set_location('Leaving eas_restored: '||p_pactid,1);
536: END eas13_restored;

Line 592: hr_assignment_extra_info_api.update_assignment_extra_info

588: hr_utility.set_location(p_type,20);
589: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
590: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
591: hr_utility.set_location(p_type,30);
592: hr_assignment_extra_info_api.update_assignment_extra_info
593: (p_validate => false,
594: p_object_version_number => l_ovn,
595: p_assignment_extra_info_id => l_aei_id,
596: p_aei_information_category => 'GB_WNU',

Line 611: hr_assignment_extra_info_api.update_assignment_extra_info

607: hr_utility.set_location(p_type,20);
608: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
609: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
610: hr_utility.set_location(p_type,30);
611: hr_assignment_extra_info_api.update_assignment_extra_info
612: (p_validate => false,
613: p_object_version_number => l_ovn,
614: p_assignment_extra_info_id => l_aei_id,
615: p_aei_information_category => 'GB_P45_3',

Line 628: hr_assignment_extra_info_api.update_assignment_extra_info

624: hr_utility.set_location(p_type,20);
625: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
626: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
627: hr_utility.set_location(p_type,30);
628: hr_assignment_extra_info_api.update_assignment_extra_info
629: (p_validate => false,
630: p_object_version_number => l_ovn,
631: p_assignment_extra_info_id => l_aei_id,
632: p_aei_information_category => 'GB_P45_3',

Line 646: hr_assignment_extra_info_api.update_assignment_extra_info

642: hr_utility.set_location(p_type,20);
643: l_ovn := get_version(archive_rec.assignment_id,'GB_P46',l_aei_id);
644: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
645: hr_utility.set_location(p_type,30);
646: hr_assignment_extra_info_api.update_assignment_extra_info
647: (p_validate => false,
648: p_object_version_number => l_ovn,
649: p_assignment_extra_info_id => l_aei_id,
650: p_aei_information_category => 'GB_P46',

Line 665: hr_assignment_extra_info_api.update_assignment_extra_info

661: hr_utility.set_location(p_type,20);
662: l_ovn := get_version(archive_rec.assignment_id,'GB_P46EXP',l_aei_id);
663: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
664: hr_utility.set_location(p_type,30);
665: hr_assignment_extra_info_api.update_assignment_extra_info
666: (p_validate => false,
667: p_object_version_number => l_ovn,
668: p_assignment_extra_info_id => l_aei_id,
669: p_aei_information_category => 'GB_P46EXP',

Line 696: hr_assignment_extra_info_api.update_assignment_extra_info

692: OR (asg_extra.aei_information1 = 'N'
693: AND asg_extra.aei_information3 <> 'Y'))
694: THEN
695: --This is just a default rollback
696: hr_assignment_extra_info_api.update_assignment_extra_info
697: (p_validate => false,
698: p_object_version_number => l_ovn,
699: p_assignment_extra_info_id => l_aei_id,
700: p_aei_information_category => 'GB_P46',

Line 706: hr_assignment_extra_info_api.update_assignment_extra_info

702:
703: ELSIF asg_extra.aei_information1 = 'Y'
704: THEN
705: --Remove the Send EDI flag also along with default rollback
706: hr_assignment_extra_info_api.update_assignment_extra_info
707: (p_validate => false,
708: p_object_version_number => l_ovn,
709: p_assignment_extra_info_id => l_aei_id,
710: p_aei_information_category => 'GB_P46',

Line 724: hr_assignment_extra_info_api.update_assignment_extra_info

720: ELSE --This is a send EDI Rollback
721: IF (asg_extra.aei_information1 = 'N'
722: AND asg_extra.aei_information3 = 'Y')
723: THEN
724: hr_assignment_extra_info_api.update_assignment_extra_info
725: (p_validate => false,
726: p_object_version_number => l_ovn,
727: p_assignment_extra_info_id => l_aei_id,
728: p_aei_information_category => 'GB_P46',

Line 743: hr_assignment_extra_info_api.update_assignment_extra_info

739: hr_utility.set_location(p_type,20);
740: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
741: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
742: hr_utility.set_location(p_type,30);
743: hr_assignment_extra_info_api.update_assignment_extra_info
744: (p_validate => false,
745: p_object_version_number => l_ovn,
746: p_assignment_extra_info_id => l_aei_id,
747: p_aei_information_category => 'GB_P46PENNOT',