APPS.WMS_TASK_MGMT_PUB dependencies on WMS_OP_OPERATION_INSTANCES

Line 953: inv_trx_util_pub.trace('updating wms_op_operation_instances.........');

949: RETURN;
950: END IF;
951: CLOSE c_plan_detail;
952: ELSE
953: inv_trx_util_pub.trace('updating wms_op_operation_instances.........');
954: UPDATE wms_op_operation_instances
955: SET OPERATION_TYPE =l_operation_plan_detail_rec.OPERATION_TYPE ,
956: OPERATION_PLAN_DETAIL_ID=l_operation_plan_detail_rec.OPERATION_PLAN_DETAIL_ID ,
957: OPERATION_SEQUENCE =l_operation_plan_detail_rec.OPERATION_SEQUENCE ,

Line 954: UPDATE wms_op_operation_instances

950: END IF;
951: CLOSE c_plan_detail;
952: ELSE
953: inv_trx_util_pub.trace('updating wms_op_operation_instances.........');
954: UPDATE wms_op_operation_instances
955: SET OPERATION_TYPE =l_operation_plan_detail_rec.OPERATION_TYPE ,
956: OPERATION_PLAN_DETAIL_ID=l_operation_plan_detail_rec.OPERATION_PLAN_DETAIL_ID ,
957: OPERATION_SEQUENCE =l_operation_plan_detail_rec.OPERATION_SEQUENCE ,
958: --ACTIVITY_TYPE=l_operation_plan_detail_rec.ACTIVITY_TYPE ,

Line 4751: FROM wms_op_operation_instances

4747: ROLLBACK to delinb ;
4748: RAISE exc_not_deleted ;
4749: END IF;
4750: DELETE
4751: FROM wms_op_operation_instances
4752: WHERE source_task_id = l_transaction_record.transaction_temp_id;
4753: IF SQL%ROWCOUNT =0 THEN
4754: IF l_debug =1 THEN
4755: debug_print('Count not update the operation instance of this task');