[Home] [Help]
622: --For each project create 1 task
623: IF p_struc_type = 'WORKPLAN' AND l_split_flag IS NOT NULL
624: THEN
625: --l_proj_element_id := null;
626: SELECT pa_tasks_s.nextval INTO l_proj_element_id
627: FROM sys.dual;
628: l_postfix := '-'||SUBSTR( p_struc_type, 1, 1 );
629: --hsiu added for parent_structure_id column
630: OPEN get_structure(p_project_id, 'WORKPLAN');
8398: ,source_object_id
8399: ,source_object_type
8400: )
8401: SELECT
8402: pa_tasks_s.nextval
8403: ,p_dest_project_id
8404: ,ppe.object_type
8405: ,pa_tasks_s.nextval --Set element_number same as proj_element_id
8406: ,l_name
8401: SELECT
8402: pa_tasks_s.nextval
8403: ,p_dest_project_id
8404: ,ppe.object_type
8405: ,pa_tasks_s.nextval --Set element_number same as proj_element_id
8406: ,l_name
8407: ,ppe.DESCRIPTION
8408: ,ppe.STATUS_CODE
8409: ,ppe.WF_STATUS_CODE
9366: ,source_object_id
9367: ,source_object_type
9368: )
9369: SELECT
9370: nvl(pt.task_id,pa_tasks_s.nextval)
9371: ,p_dest_project_id
9372: ,ppe.object_type
9373: ,ppe.element_number
9374: ,ppe.name
9518: ,source_object_id
9519: ,source_object_type
9520: )
9521: SELECT
9522: pa_tasks_s.nextval
9523: ,p_dest_project_id
9524: ,ppe.object_type
9525: ,ppe.element_number
9526: ,ppe.name
9991: FETCH cur_get_shared_ver_id INTO l_shared_dest_ver_id;
9992: CLOSE cur_get_shared_ver_id;
9993:
9994: IF l_debug_mode = 'Y' THEN
9995: Pa_Debug.WRITE(G_PKG_NAME, 'Calling pa_tasks sync up API for struc version :'||l_shared_dest_ver_id,
9996: l_debug_level3);
9997: END IF;
9998:
9999: --Call API to sync up tasks in pa_tasks table, with the new (shared) version [WP version copied from src]
11265: ,WF_PROCESS
11266: ,WF_START_LEAD_DAYS
11267: )
11268: SELECT
11269: pa_tasks_s.nextval
11270: ,p_dest_project_id
11271: ,ppe.object_type
11272: ,ppe.element_number
11273: ,DECODE( ppe.object_type, 'PA_STRUCTURES',l_name, ppe.name )