APPS.HR_ASSIGNMENT_API dependencies on PER_APP_ASG_PKG

Line 417: per_app_asg_pkg.cleanup_letters

413: null,
414: null,
415: l_cost_warning ) ;
416: -- clean up the letter requests.
417: per_app_asg_pkg.cleanup_letters
418: (p_assignment_id => p_assignment_id);
419: hr_utility.set_location('Entering:'|| l_proc, 60);
420:
421: -- calling the IRC packages to maintain the IRC Assignment Statuses

Line 572: per_app_asg_pkg.cleanup_letters

568: -- clean up the letter requests.
569: hr_utility.set_location('Entering:'|| l_proc, 180);
570: hr_utility.set_location('At reverse_term_apln_fut',180);
571:
572: per_app_asg_pkg.cleanup_letters
573: (p_assignment_id => p_assignment_id);
574:
575: UPDATE PER_APPLICATIONS
576: SET date_end =null

Line 881: per_app_asg_pkg.cleanup_letters

877: null,
878: null,
879: l_cost_warning ) ;
880: -- clean up the letter requests.
881: per_app_asg_pkg.cleanup_letters
882: (p_assignment_id => p_assignment_id);
883: hr_utility.set_location('Entering:'|| l_proc, 60);
884:
885: -- calling the IRC packages to maintain the IRC Assignment Statuses

Line 1025: per_app_asg_pkg.cleanup_letters

1021: l_cost_warning ) ;
1022: -- clean up the letter requests.
1023: hr_utility.set_location('Entering:'|| l_proc, 180);
1024:
1025: per_app_asg_pkg.cleanup_letters
1026: (p_assignment_id => p_assignment_id);
1027:
1028: UPDATE PER_APPLICATIONS
1029: SET date_end =null

Line 18753: per_app_asg_pkg.cleanup_letters

18749: and plr.auto_or_manual = 'AUTO');
18750: --
18751: END IF;
18752: --
18753: per_app_asg_pkg.cleanup_letters
18754: ( p_assignment_id => p_assignment_id);
18755: --
18756: --
18757: delete from per_letter_requests plr

Line 22559: per_app_asg_pkg.cleanup_letters

22555: where plr.letter_request_id = plrl.letter_request_id
22556: and plr.request_status = 'PENDING'
22557: and plr.auto_or_manual = 'AUTO');
22558:
22559: per_app_asg_pkg.cleanup_letters
22560: (p_assignment_id => p_assignment_id);
22561: --
22562: -- Check if a letter request is necessary for the assignment.
22563: --