APPS.PA_WORKPLAN_WORKFLOW dependencies on PA_PROJ_ELEMENTS

Line 953: pa_proj_elements ppe

949: ,ppe.wf_start_lead_days
950: ,element_number
951: FROM pa_proj_elem_ver_schedule pevs ,
952: pa_proj_element_versions pev,
953: pa_proj_elements ppe
954: WHERE pev.parent_structure_version_id = c_parent_struct_ver_id
955: AND pev.object_type = 'PA_TASKS'
956: AND ppe.object_type = 'PA_TASKS'
957: AND pev.proj_element_id = ppe.proj_element_id

Line 1009: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id,'WORKPLAN');

1005: -- id for versioning enabled case and only version
1006: -- for versioning disbled case .
1007:
1008: IF nvl(l_versioned,'N') = 'Y' then
1009: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id,'WORKPLAN');
1010: ELSE
1011: OPEN get_struct_version_id ;
1012: FETCH get_struct_version_id INTO l_structure_version_id ;
1013: CLOSE get_struct_version_id ;

Line 1028: IF (nvl(PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_STATUS(get_all_tasks_rec.proj_element_id,l_project_id,'TASK_EXECUTION'),'X') <> 'ACTIVE') THEN

1024: -- Check is Task Execution Process is already
1025: -- running for the task. Proceed if its not.
1026:
1027: --Bug#3619754 : Added nvl as the API returns null in case WF is not running.
1028: IF (nvl(PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_STATUS(get_all_tasks_rec.proj_element_id,l_project_id,'TASK_EXECUTION'),'X') <> 'ACTIVE') THEN
1029:
1030: -- The task execution workflow will be started on the date
1031: -- when the schedule start date minus the Task execution Lead Time
1032:

Line 1113: FROM pa_proj_elements

1109: ,wf_item_type
1110: ,wf_process
1111: ,wf_start_lead_days
1112: ,project_id
1113: FROM pa_proj_elements
1114: WHERE proj_element_id = p_task_id ;
1115:
1116: l_err_code NUMBER;
1117: l_err_stage VARCHAR2(30);

Line 1157: IF (nvl(PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_STATUS(p_task_id,task_info_rec.project_id,'TASK_EXECUTION'),'X') <> 'ACTIVE') THEN

1153: -- Check is Task Execution Process is already
1154: -- running for the task. Proceed if its not.
1155:
1156: --Bug#3619754 : Added nvl as the API returns null in case WF is not running.
1157: IF (nvl(PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_STATUS(p_task_id,task_info_rec.project_id,'TASK_EXECUTION'),'X') <> 'ACTIVE') THEN
1158:
1159: -- Not performing the lead days validation as
1160: -- this API is explicitly called to restart the
1161: -- task execution WF after cancelling it.

Line 1242: from pa_proj_elements

1238: Cursor get_item_type IS
1239: Select enable_wf_flag
1240: ,wf_item_type
1241: ,project_id
1242: from pa_proj_elements
1243: where proj_element_id = p_task_id ;
1244:
1245: get_item_type_rec get_item_type%ROWTYPE ;
1246:

Line 1263: IF nvl(PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_STATUS(p_task_id,get_item_type_rec.project_id,'TASK_EXECUTION'),'X') = 'ACTIVE' THEN

1259: CLOSE get_item_type ;
1260:
1261: -- Cancel only if its running.
1262: IF nvl(get_item_type_rec.enable_wf_flag,'N') = 'Y' THEN
1263: IF nvl(PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_STATUS(p_task_id,get_item_type_rec.project_id,'TASK_EXECUTION'),'X') = 'ACTIVE' THEN
1264: l_item_key := PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_ITEMKEY
1265: (p_proj_element_id => p_task_id
1266: ,p_project_id => get_item_type_rec.project_id
1267: ,p_wf_type_code =>'TASK_EXECUTION'

Line 1264: l_item_key := PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_ITEMKEY

1260:
1261: -- Cancel only if its running.
1262: IF nvl(get_item_type_rec.enable_wf_flag,'N') = 'Y' THEN
1263: IF nvl(PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_STATUS(p_task_id,get_item_type_rec.project_id,'TASK_EXECUTION'),'X') = 'ACTIVE' THEN
1264: l_item_key := PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_WF_ITEMKEY
1265: (p_proj_element_id => p_task_id
1266: ,p_project_id => get_item_type_rec.project_id
1267: ,p_wf_type_code =>'TASK_EXECUTION'
1268: );