[Home] [Help]
127: WHERE operation_plan_id=v_operation_plan_id);
128:
129: CURSOR c_plan_instance_exists IS
130: SELECT 1
131: FROM WMS_OP_PLAN_INSTANCES
132: WHERE source_task_id=p_source_task_id
133: AND activity_type_id=p_activity_id;
134:
135: CURSOR c_operation_instance_exists IS
146: l_inbound_doc_rec inbound_document_details%ROWTYPE :=NULL;
147: l_mmtt_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE:=NULL;
148: l_operation_plan_rec c_operation_plan%ROWTYPE:=NULL;
149: l_operation_plan_detail_rec c_plan_detail%ROWTYPE:=NULL;
150: l_op_plan_instance_rec WMS_OP_PLAN_INSTANCES%ROWTYPE:=NULL;
151: l_operation_instance_rec WMS_OP_OPERATION_INSTANCES%ROWTYPE :=NULL;
152: l_operation_plan_id NUMBER;
153: l_operation_exists NUMBER;
154: l_plan_exists NUMBER;
302: CLOSE c_plan_detail;
303: l_progress:=70;
304:
305:
306: /*Query WMS_OP_PLAN_INSTANCES for P_Source_task_ID,
307: if the Source Task ID already has another Operation Plan Instance
308: associated with it raise unexpected error exception. Populate proper error code. */
309:
310: OPEN c_plan_instance_exists;
474: END IF;
475:
476: l_progress:=110;
477:
478: /* Create WMS_OP_PLAN_INSTANCES PL/SQL record with proper operation_plan_ID,
479: activity_type_ID, source_task_ID (P_source_task_ID), and original source/destination
480: data from source task record, with 'Pending' status.*/
481:
482: IF (l_debug=1) THEN
527: print_debug('Orig_dest_sub_code ==>'||l_op_plan_instance_rec.orig_dest_sub_code,l_module_name,4);
528: print_debug('Orig_dest_loc_id ==>'||l_op_plan_instance_rec.orig_dest_loc_id,l_module_name,4);
529: END IF;
530:
531: /*Call WMS_OP_PLAN_INSTANCES table handler, WMS_OP_RUNTIME_PVT_APIS.INSERT_OPERATION_PLAN_INSTANCE,
532: to insert record into the WMS_OP_PLAN_INSTANCES table.*/
533:
534: WMS_OP_RUNTIME_PVT_APIS.INSERT_PLAN_INSTANCE(
535: x_return_status => x_return_status ,
528: print_debug('Orig_dest_loc_id ==>'||l_op_plan_instance_rec.orig_dest_loc_id,l_module_name,4);
529: END IF;
530:
531: /*Call WMS_OP_PLAN_INSTANCES table handler, WMS_OP_RUNTIME_PVT_APIS.INSERT_OPERATION_PLAN_INSTANCE,
532: to insert record into the WMS_OP_PLAN_INSTANCES table.*/
533:
534: WMS_OP_RUNTIME_PVT_APIS.INSERT_PLAN_INSTANCE(
535: x_return_status => x_return_status ,
536: x_msg_count => x_msg_count ,
1754: l_opertn_instance_details c_operation_instance_details%ROWTYPE := NULL;
1755: l_op_plan_instance_id NUMBER;
1756: l_operation_count NUMBER;
1757: l_wooi_rec wms_op_operation_instances%ROWTYPE := NULL;
1758: l_wopi_rec wms_op_plan_instances%ROWTYPE := NULL;
1759: l_sug_sub_code VARCHAR2(10);
1760: l_sug_location_id NUMBER;
1761: l_sug_to_lpn_id NUMBER;
1762: l_dest_param_rec WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE;
2264: l_progress:=150;
2265:
2266: /* If there is only one WOOI record for the same OP_PLAN_INSTANCE_ID,
2267: * it means it is the first step of this plan.
2268: * In this case, update WMS_OP_PLAN_INSTANCES status to 'Active' for this OP_PLAN_INSTANCE_ID.*/
2269:
2270: OPEN c_operation_sequence(l_op_plan_instance_id);
2271:
2272: FETCH c_operation_sequence INTO l_operation_count;
5051: ATTRIBUTE12,
5052: ATTRIBUTE13,
5053: ATTRIBUTE14,
5054: ATTRIBUTE15 */
5055: FROM wms_op_plan_instances
5056: WHERE source_task_id = v_source_task_id;
5057:
5058: CURSOR wooi_cursor(v_op_plan_instance_id NUMBER) IS
5059: SELECT *
5885: * as l_inbound_doc_parent_rec.
5886: */
5887: l_progress := 185;
5888:
5889: -- TODO: how is wms_dispatched_tasks_history linked to wms_op_plan_instances
5890: UPDATE wms_dispatched_tasks_history
5891: SET transaction_quantity = l_inbound_doc_parent_rec.transaction_quantity,
5892: secondary_transaction_quantity = l_inbound_doc_parent_rec.secondary_transaction_quantity, --13431255
5893: last_update_date = Sysdate -- bug 3827507
6489:
6490: l_wooi_data_rec c_wooi_data_rec%ROWTYPE:=NULL;
6491: l_wooi_rec wms_op_operation_instances%ROWTYPE:=NULL;
6492:
6493: l_wopi_update_rec wms_op_plan_instances%ROWTYPE:=NULL;
6494: BEGIN
6495:
6496: IF (l_debug = 1) THEN
6497: print_debug(' Entered. ',l_module_name,1);
6953: l_inbound_doc c_inbound_doc%ROWTYPE;
6954: l_operation_instance_rec c_operation_instance%ROWTYPE;
6955: l_plan_status NUMBER := -1;
6956: l_wooi_update_rec WMS_OP_OPERATION_INSTANCES%ROWTYPE;
6957: l_wopi_update_rec WMS_OP_PLAN_INSTANCES%ROWTYPE;
6958: l_parent_source_task_id NUMBER;
6959:
6960:
6961: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7401: CURSOR c_plan_instance(v_op_plan_instance_id NUMBER) IS
7402: SELECT status,
7403: orig_dest_sub_code,
7404: orig_dest_loc_id
7405: FROM WMS_OP_PLAN_INSTANCES
7406: WHERE op_plan_instance_id=v_op_plan_instance_id;
7407:
7408:
7409: l_plan_orig_dest_sub VARCHAR2(10);
7414: l_operation_plan_id NUMBER;
7415: l_operation_instance c_operation_instance%ROWTYPE;
7416: l_plan_inst_status NUMBER := -1;
7417: l_wooi_update_rec WMS_OP_OPERATION_INSTANCES%ROWTYPE:=NULL;
7418: l_wopi_update_rec WMS_OP_PLAN_INSTANCES%ROWTYPE:=NULL;
7419: l_parent_source_task_id NUMBER;
7420: l_document_rec mtl_material_transactions_temp%ROWTYPE;
7421:
7422:
8004: l_op_plan_instance_id NUMBER;
8005: l_wooi_rec wms_op_operation_instances%ROWTYPE;
8006: l_plan_detail_id NUMBER;
8007: l_first_opertn_seq NUMBER;
8008: l_wopi_rec wms_op_plan_instances%ROWTYPE;
8009: l_op_plan_id NUMBER;
8010:
8011: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8012: l_module_name VARCHAR2(30) := 'Rollback_operation_Plan';
8563: WHERE mmtt.transaction_temp_id = p_source_task_id;
8564:
8565: CURSOR plan_status IS
8566: SELECT wopi.status
8567: FROM wms_op_plan_instances wopi
8568: WHERE wopi.activity_type_id = p_activity_type_id
8569: AND wopi.source_task_id = p_source_task_id;
8570:
8571: CURSOR op_plan_status IS
8569: AND wopi.source_task_id = p_source_task_id;
8570:
8571: CURSOR op_plan_status IS
8572: SELECT wopi.status
8573: FROM wms_op_plan_instances wopi
8574: WHERE wopi.op_plan_instance_id = (SELECT op_plan_instance_id
8575: FROM wms_op_operation_instances wooi
8576: WHERE wooi.source_task_id = p_source_task_id
8577: AND wooi.activity_type_id = p_activity_type_id