9029: OPEN get_wf_info('STRUCTURE_SUBMITTED');
9030: FETCH get_wf_info into l_wf_enable, l_wf_item_type, l_wf_process,
9031: l_wf_success_code, l_wf_failure_code;
9032: IF (l_wf_enable = 'Y') THEN
9033: PA_WORKPLAN_WORKFLOW.Start_workflow
9034: (
9035: l_wf_item_type
9036: ,l_wf_process
9037: ,p_structure_version_id
9214: FETCH get_wf_info INTO l_wf_enable, l_wf_item_type, l_wf_process,
9215: l_success_code,l_failure_code;
9216: IF (get_wf_info%found) then
9217: IF (l_wf_enable = 'Y') THEN
9218: PA_WORKPLAN_WORKFLOW.Start_workflow
9219: (
9220: l_wf_item_type
9221: ,l_wf_process
9222: ,p_structure_version_id
9380: -- END IF;
9381: NULL;
9382: ELSE
9383: --cancel process
9384: PA_WORKPLAN_WORKFLOW.cancel_workflow(
9385: l_item_type
9386: ,l_item_key
9387: ,x_msg_count
9388: ,x_msg_data
12607: l_text
12608: ,l_clob);
12609:
12610: --send notification
12611: PA_WORKPLAN_WORKFLOW.START_WORKFLOW(
12612: 'PAWFPPWP'
12613: ,'PA_WORKPLAN_ERRORS'
12614: ,p_structure_version_id
12615: ,NULL