eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_WORKPLAN_WORKFLOW dependencies on PA_PROJ_ELEMENTS_UTILS

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 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 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: );