APPS.PA_SCHEDULE_PVT dependencies on PA_WF_PROCESSES

Line 6180: PROCEDURE check_overcommitment_mult(p_item_type IN PA_WF_PROCESSES.item_type%TYPE,

6176: -- Procedure : check_overcommitment_mult
6177: -- Purpose : First checks if this assignment alone causes resource
6178: -- overcommitment. If Yes, then stores self-conflict and user
6179: -- action in PA_ASSIGNMENT_CONFLICT_HIST.
6180: PROCEDURE check_overcommitment_mult(p_item_type IN PA_WF_PROCESSES.item_type%TYPE,
6181: p_item_key IN PA_WF_PROCESSES.item_key%TYPE,
6182: p_conflict_group_id IN NUMBER := NULL,
6183: p_resolve_conflict_action_code IN VARCHAR2,
6184: x_overcommitment_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 6181: p_item_key IN PA_WF_PROCESSES.item_key%TYPE,

6177: -- Purpose : First checks if this assignment alone causes resource
6178: -- overcommitment. If Yes, then stores self-conflict and user
6179: -- action in PA_ASSIGNMENT_CONFLICT_HIST.
6180: PROCEDURE check_overcommitment_mult(p_item_type IN PA_WF_PROCESSES.item_type%TYPE,
6181: p_item_key IN PA_WF_PROCESSES.item_key%TYPE,
6182: p_conflict_group_id IN NUMBER := NULL,
6183: p_resolve_conflict_action_code IN VARCHAR2,
6184: x_overcommitment_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6185: x_conflict_group_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 7386: l_item_type pa_wf_processes.item_type%TYPE;

7382: organ.LANGUAGE = USERENV('LANG');
7383:
7384: /* End of code added for bug 3115273 */
7385:
7386: l_item_type pa_wf_processes.item_type%TYPE;
7387: l_item_key pa_wf_processes.item_key%TYPE;
7388: l_source_proj_id NUMBER;
7389: l_source_proj_name pa_projects_all.name%TYPE;
7390: l_source_proj_number pa_projects_all.segment1%TYPE;

Line 7387: l_item_key pa_wf_processes.item_key%TYPE;

7383:
7384: /* End of code added for bug 3115273 */
7385:
7386: l_item_type pa_wf_processes.item_type%TYPE;
7387: l_item_key pa_wf_processes.item_key%TYPE;
7388: l_source_proj_id NUMBER;
7389: l_source_proj_name pa_projects_all.name%TYPE;
7390: l_source_proj_number pa_projects_all.segment1%TYPE;
7391: l_source_proj_mgr_name per_all_people_f.full_name%type; /* Bug 3115273 pa_project_lists_v.person_name%TYPE; */