APPS.PA_SCHEDULE_PVT dependencies on PA_WF_PROCESSES

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

5883: -- Procedure : check_overcommitment_mult
5884: -- Purpose : First checks if this assignment alone causes resource
5885: -- overcommitment. If Yes, then stores self-conflict and user
5886: -- action in PA_ASSIGNMENT_CONFLICT_HIST.
5887: PROCEDURE check_overcommitment_mult(p_item_type IN PA_WF_PROCESSES.item_type%TYPE,
5888: p_item_key IN PA_WF_PROCESSES.item_key%TYPE,
5889: p_conflict_group_id IN NUMBER := NULL,
5890: p_resolve_conflict_action_code IN VARCHAR2,
5891: x_overcommitment_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 5888: p_item_key IN PA_WF_PROCESSES.item_key%TYPE,

5884: -- Purpose : First checks if this assignment alone causes resource
5885: -- overcommitment. If Yes, then stores self-conflict and user
5886: -- action in PA_ASSIGNMENT_CONFLICT_HIST.
5887: PROCEDURE check_overcommitment_mult(p_item_type IN PA_WF_PROCESSES.item_type%TYPE,
5888: p_item_key IN PA_WF_PROCESSES.item_key%TYPE,
5889: p_conflict_group_id IN NUMBER := NULL,
5890: p_resolve_conflict_action_code IN VARCHAR2,
5891: x_overcommitment_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5892: x_conflict_group_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 7093: l_item_type pa_wf_processes.item_type%TYPE;

7089: organ.LANGUAGE = USERENV('LANG');
7090:
7091: /* End of code added for bug 3115273 */
7092:
7093: l_item_type pa_wf_processes.item_type%TYPE;
7094: l_item_key pa_wf_processes.item_key%TYPE;
7095: l_source_proj_id NUMBER;
7096: l_source_proj_name pa_projects_all.name%TYPE;
7097: l_source_proj_number pa_projects_all.segment1%TYPE;

Line 7094: l_item_key pa_wf_processes.item_key%TYPE;

7090:
7091: /* End of code added for bug 3115273 */
7092:
7093: l_item_type pa_wf_processes.item_type%TYPE;
7094: l_item_key pa_wf_processes.item_key%TYPE;
7095: l_source_proj_id NUMBER;
7096: l_source_proj_name pa_projects_all.name%TYPE;
7097: l_source_proj_number pa_projects_all.segment1%TYPE;
7098: l_source_proj_mgr_name per_all_people_f.full_name%type; /* Bug 3115273 pa_project_lists_v.person_name%TYPE; */