[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;
2229: l_progress:=150;
2230:
2231: /* If there is only one WOOI record for the same OP_PLAN_INSTANCE_ID,
2232: * it means it is the first step of this plan.
2233: * In this case, update WMS_OP_PLAN_INSTANCES status to 'Active' for this OP_PLAN_INSTANCE_ID.*/
2234:
2235: OPEN c_operation_sequence(l_op_plan_instance_id);
2236:
2237: FETCH c_operation_sequence INTO l_operation_count;
4939: ATTRIBUTE12,
4940: ATTRIBUTE13,
4941: ATTRIBUTE14,
4942: ATTRIBUTE15 */
4943: FROM wms_op_plan_instances
4944: WHERE source_task_id = v_source_task_id;
4945:
4946: CURSOR wooi_cursor(v_op_plan_instance_id NUMBER) IS
4947: SELECT *
5760: * as l_inbound_doc_parent_rec.
5761: */
5762: l_progress := 185;
5763:
5764: -- TODO: how is wms_dispatched_tasks_history linked to wms_op_plan_instances
5765: UPDATE wms_dispatched_tasks_history
5766: SET transaction_quantity = l_inbound_doc_parent_rec.transaction_quantity,
5767: last_update_date = Sysdate -- bug 3827507
5768: WHERE op_plan_instance_id =l_wopi_orig_rec.op_plan_instance_id;
6359:
6360: l_wooi_data_rec c_wooi_data_rec%ROWTYPE:=NULL;
6361: l_wooi_rec wms_op_operation_instances%ROWTYPE:=NULL;
6362:
6363: l_wopi_update_rec wms_op_plan_instances%ROWTYPE:=NULL;
6364: BEGIN
6365:
6366: IF (l_debug = 1) THEN
6367: print_debug(' Entered. ',l_module_name,1);
6823: l_inbound_doc c_inbound_doc%ROWTYPE;
6824: l_operation_instance_rec c_operation_instance%ROWTYPE;
6825: l_plan_status NUMBER := -1;
6826: l_wooi_update_rec WMS_OP_OPERATION_INSTANCES%ROWTYPE;
6827: l_wopi_update_rec WMS_OP_PLAN_INSTANCES%ROWTYPE;
6828: l_parent_source_task_id NUMBER;
6829:
6830:
6831: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7271: CURSOR c_plan_instance(v_op_plan_instance_id NUMBER) IS
7272: SELECT status,
7273: orig_dest_sub_code,
7274: orig_dest_loc_id
7275: FROM WMS_OP_PLAN_INSTANCES
7276: WHERE op_plan_instance_id=v_op_plan_instance_id;
7277:
7278:
7279: l_plan_orig_dest_sub VARCHAR2(10);
7284: l_operation_plan_id NUMBER;
7285: l_operation_instance c_operation_instance%ROWTYPE;
7286: l_plan_inst_status NUMBER := -1;
7287: l_wooi_update_rec WMS_OP_OPERATION_INSTANCES%ROWTYPE:=NULL;
7288: l_wopi_update_rec WMS_OP_PLAN_INSTANCES%ROWTYPE:=NULL;
7289: l_parent_source_task_id NUMBER;
7290: l_document_rec mtl_material_transactions_temp%ROWTYPE;
7291:
7292:
7874: l_op_plan_instance_id NUMBER;
7875: l_wooi_rec wms_op_operation_instances%ROWTYPE;
7876: l_plan_detail_id NUMBER;
7877: l_first_opertn_seq NUMBER;
7878: l_wopi_rec wms_op_plan_instances%ROWTYPE;
7879: l_op_plan_id NUMBER;
7880:
7881: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7882: l_module_name VARCHAR2(30) := 'Rollback_operation_Plan';
8433: WHERE mmtt.transaction_temp_id = p_source_task_id;
8434:
8435: CURSOR plan_status IS
8436: SELECT wopi.status
8437: FROM wms_op_plan_instances wopi
8438: WHERE wopi.activity_type_id = p_activity_type_id
8439: AND wopi.source_task_id = p_source_task_id;
8440:
8441: CURSOR op_plan_status IS
8439: AND wopi.source_task_id = p_source_task_id;
8440:
8441: CURSOR op_plan_status IS
8442: SELECT wopi.status
8443: FROM wms_op_plan_instances wopi
8444: WHERE wopi.op_plan_instance_id = (SELECT op_plan_instance_id
8445: FROM wms_op_operation_instances wooi
8446: WHERE wooi.source_task_id = p_source_task_id
8447: AND wooi.activity_type_id = p_activity_type_id