APPS.HR_ASSIGNMENT_API dependencies on PER_APP_ASG_PKG

Line 332: per_app_asg_pkg.cleanup_letters

328: null,
329: null,
330: l_cost_warning ) ;
331: -- clean up the letter requests.
332: per_app_asg_pkg.cleanup_letters
333: (p_assignment_id => p_assignment_id);
334: hr_utility.set_location('Entering:'|| l_proc, 60);
335:
336: -- calling the IRC packages to maintain the IRC Assignment Statuses

Line 464: per_app_asg_pkg.cleanup_letters

460: l_cost_warning ) ;
461: -- clean up the letter requests.
462: hr_utility.set_location('Entering:'|| l_proc, 180);
463:
464: per_app_asg_pkg.cleanup_letters
465: (p_assignment_id => p_assignment_id);
466:
467: UPDATE PER_APPLICATIONS
468: SET date_end =null

Line 17890: per_app_asg_pkg.cleanup_letters

17886: and plr.auto_or_manual = 'AUTO');
17887: --
17888: END IF;
17889: --
17890: per_app_asg_pkg.cleanup_letters
17891: ( p_assignment_id => p_assignment_id);
17892: --
17893: --
17894: delete from per_letter_requests plr

Line 21631: per_app_asg_pkg.cleanup_letters

21627: where plr.letter_request_id = plrl.letter_request_id
21628: and plr.request_status = 'PENDING'
21629: and plr.auto_or_manual = 'AUTO');
21630:
21631: per_app_asg_pkg.cleanup_letters
21632: (p_assignment_id => p_assignment_id);
21633: --
21634: -- Check if a letter request is necessary for the assignment.
21635: --