[Home] [Help]
406: --For each project create 1 task
407: IF p_struc_type = 'WORKPLAN' AND l_split_flag IS NOT NULL
408: THEN
409: --l_proj_element_id := null;
410: SELECT pa_tasks_s.nextval INTO l_proj_element_id
411: FROM sys.dual;
412: l_postfix := '-'||SUBSTR( p_struc_type, 1, 1 );
413: --hsiu added for parent_structure_id column
414: OPEN get_structure(p_project_id, 'WORKPLAN');
8137: ,source_object_id
8138: ,source_object_type
8139: )
8140: SELECT
8141: pa_tasks_s.nextval
8142: ,p_dest_project_id
8143: ,ppe.object_type
8144: ,pa_tasks_s.nextval --Set element_number same as proj_element_id
8145: ,l_name
8140: SELECT
8141: pa_tasks_s.nextval
8142: ,p_dest_project_id
8143: ,ppe.object_type
8144: ,pa_tasks_s.nextval --Set element_number same as proj_element_id
8145: ,l_name
8146: ,ppe.DESCRIPTION
8147: ,ppe.STATUS_CODE
8148: ,ppe.WF_STATUS_CODE
9074: ,source_object_id
9075: ,source_object_type
9076: )
9077: SELECT
9078: nvl(pt.task_id,pa_tasks_s.nextval)
9079: ,p_dest_project_id
9080: ,ppe.object_type
9081: ,ppe.element_number
9082: ,ppe.name
9226: ,source_object_id
9227: ,source_object_type
9228: )
9229: SELECT
9230: pa_tasks_s.nextval
9231: ,p_dest_project_id
9232: ,ppe.object_type
9233: ,ppe.element_number
9234: ,ppe.name
9697: FETCH cur_get_shared_ver_id INTO l_shared_dest_ver_id;
9698: CLOSE cur_get_shared_ver_id;
9699:
9700: IF l_debug_mode = 'Y' THEN
9701: Pa_Debug.WRITE(G_PKG_NAME, 'Calling pa_tasks sync up API for struc version :'||l_shared_dest_ver_id,
9702: l_debug_level3);
9703: END IF;
9704:
9705: --Call API to sync up tasks in pa_tasks table, with the new (shared) version [WP version copied from src]
10950: ,WF_PROCESS
10951: ,WF_START_LEAD_DAYS
10952: )
10953: SELECT
10954: pa_tasks_s.nextval
10955: ,p_dest_project_id
10956: ,ppe.object_type
10957: ,ppe.element_number
10958: ,DECODE( ppe.object_type, 'PA_STRUCTURES',l_name, ppe.name )