436: -- Procedure : check_overcommitment_mult
437: -- Purpose : First checks if this assignment alone causes resource
438: -- overcommitment. If Yes, then stores self-conflict and user
439: -- action in PA_ASSIGNMENT_CONFLICT_HIST.
440: PROCEDURE check_overcommitment_mult(p_item_type IN PA_WF_PROCESSES.item_type%TYPE,
441: p_item_key IN PA_WF_PROCESSES.item_key%TYPE,
442: p_conflict_group_id IN NUMBER := NULL,
443: p_resolve_conflict_action_code IN VARCHAR2,
444: x_overcommitment_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
437: -- Purpose : First checks if this assignment alone causes resource
438: -- overcommitment. If Yes, then stores self-conflict and user
439: -- action in PA_ASSIGNMENT_CONFLICT_HIST.
440: PROCEDURE check_overcommitment_mult(p_item_type IN PA_WF_PROCESSES.item_type%TYPE,
441: p_item_key IN PA_WF_PROCESSES.item_key%TYPE,
442: p_conflict_group_id IN NUMBER := NULL,
443: p_resolve_conflict_action_code IN VARCHAR2,
444: x_overcommitment_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
445: x_conflict_group_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895